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 7877

Examine the structure if 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 VALUES(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 EXIST 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 c USING 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 VALUES(e.employee_id, e.first_name ||', '||e.last_name);

Correct Answer A
Explanation Explanation/Reference: Explanation: Correct syntax for the MERGE command is MERGE INTO table1 USING table2 on (join_condition) WHEN MATCHED UPDATE SET col1 = value WHEN NOT MATCHED INSERT (column_list) values (column_values). Incorrect Answers B: WHEN EXIST THEN clause cannot be used in the MERGE statement. C: WHEN EXIST THEN clause cannot be used in the MERGE statement. D: FROM clause cannot be used in the MERGE statement. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 273-275 Chapter 6: Manipulating Oracle Data


Question ID 7878

Which two are true about aggregate functions? (Choose two.)

Option A

You can use aggregate functions in any clause of a SELECT statement.

Option B

You can use aggregate functions only in the column list of the SELECT clause and in the WHERE clause of a SELECT statement.

Option C

You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.

Option D

You can pass column names, expressions, constants, or functions as parameters to an aggregate function.

Option E

You can use aggregate functions on a table, only by grouping the whole table as one single group.

Option F

You cannot group the rows of a table by more than one column while using aggregate functions.

Correct Answer CD
Explanation Explanation/Reference: Explanation: It is possible to mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns. Also it is acceptable to pass column names, expressions, constraints, or other functions as parameters to an aggregate function. Incorrect Answers A: You cannot use aggregate functions in any clause of a SELECT statement. For example, they cannot be used with a WHEN statement. B: It is not possible to use aggregate functions in the WHERE clause of a SELECT statement. But they can be used with a HAVING clause used after the GROUP BY clause, for example. E: You don't need to group the whole table as one single group. F: It is possible to group more than one column while using aggregate functions. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 122-135 Chapter 3: Advanced Data Selection in Oracle

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