AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z1-051





Question ID 4956

Evaluate these two SQL statements:
SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC;
What is true about them?
 

Option A

A.    The two statements produce identical results.
 

Option B

B.    The second statement returns a syntax error.
 

Option C

C.    There is no need to specify DESC because the results are sorted in descending order by default.
 

Option D

D.    The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.
 

Correct Answer A
Explanation


Question ID 4957

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:
EMPLOYEES
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE
NEW_EMPLOYEES
EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2(60)
Which MERGE statement is valid?

Option A

A. MERGE INTO new_employees c
USING employees e
ON (c.employee_id = e.employee_id) WHEN MATCHED THEN
UPDATE SET
 

Option B

B.    name = e.first_name ||','|| e.last_name WHEN NOT MATCHED THEN
INSERT
value
S(e.employee_id, e.first_name ||',
'||e.last_name);
 

Option C

C.    MERGE new_employees c
USING employees e
ON (c.employee_id = e.employee_id)
WHEN EXISTS THEN UPDATE SET
 

Option D

D.    name = e.first_name ||','|| e.last_name WHEN NOT MATCHED THEN INSERT valueS(e.employee_id, e.first_name ||', '||e.last_name);
 

Option E

E.    MERGE INTO new_employees cUSING employees e ON (c.employee_id = e.employee_id)
WHEN EXISTS THEN
UPDATE SET
 

Correct Answer A
Explanation

Send email to admin@getfreedumps for new dumps request!!!