본문 바로가기

복이의 기술블로그3

[1z0-071 v.2 ]3. Which two queries return rows for employees whose manager works in a different department? Which two queries return rows for employees whose manager works in a different department? - 자신의 매니저와 부서가 다른 직원을 리턴하는 쿼리를 2개 찾으세요. Examine the description of the EMPLOYEES table: Which two queries return rows for employees whose manager works in a different department? (Choose two.) A. B. C. D. E. 답: 2021. 6. 20.
[1z0-071 v.2] 2. Which queries generate the same output? Which queries generate the same output? Examine the data in the PRODUCTS table: Examine these queries: Which queries generate the same output? A. 1 and 2 B. 1 and 3 C. 1, 2, and 3 D. 2 and 3 답 : A 2021. 6. 19.
[1z0-071 v.2] 1. Which statement will do this? Which statement will do this? The SYSDATE function displays the current Oracle Server date as: 5/21/2019 You wish to display the date as: MONDAY, 21 MAY, 2019 Which statement will do this? A. SELECT TO_DATE(SYSDATE, ‘FMDAY, DD MONTH, YYYY’) FROM DUAL; B. SELECT TO_CHAR(SYSDATE, ‘FMDD, DAY MONTH, YYYY’) FROM DUAL; C. SELECT TO_CHAR(SYSDATE, ‘FMDAY, DDTH MONTH, YYYY’) FROM DUAL; D. SELECT TO_CHAR(.. 2021. 6. 19.

티스토리툴바