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- 1z0-007





Question ID 8031

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

Option A

The two statements produce identical results.

Option B

The second statement returns a syntax error.

Option C

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

Option 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 Explanation/Reference: Explanation :the two statement produce identical results as ORDER BY 2 will take the second column as sorting column. Incorrect answer : B there is no syntax error C result are sorted in ascending order by default D ORDER BY 2 will take the second column as sorting column. Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 2-22


Question ID 8032

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

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

Option 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

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

Option 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

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

Option F

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

Correct Answer A
Explanation Explanation/Reference: Explanation : this is the correct MERGE statement syntax Incorrect answer : B it should MERGE INTO table_name C it should be WHEN MATCHED THEN D it should MERGE INTO table_name Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 8-29

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