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 7845

Examine the description of the EMPLOYEES table:

EMP_ID NUMBER(4) NOT NULL

LAST_NAME VARCHAR2(30) NOT NULL

FIRST_NAME VARCHAR2(30)

DEPT_ID NUMBER(2)

JOB_CAT VARCHARD2(30)

SALARY NUMBER(8,2)

Which statement shows the maximum salary paid in each job category of each department?

Option A

SELECT dept_id, job_cat, MAX(salary) FROM employees WHERE salary > MAX (salary);

Option B

SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id,job_cat;

Option C

SELECT dept_id, job_cat, MAX(salary) FROM employees;

Option D

SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id;

Option E

SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept _ id job _ cat salary;

Correct Answer B
Explanation Explanation/Reference: Explanation: This answer provides correct syntax and semantics to show the maximum salary paid in each job category of each department. Incorrect Answers A: This query will not return any row because condition SALARY > MAX(SALARY) is FALSE. C: This query will return error because you cannot show maximum salary with DEPT_ID and JOB_CAT without grouping by these columns. D: The GROUP BY clause is missing JOB_ID column. E: You don't need to group results of query by SALARY in the GROUP BY column. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 356-365 Chapter 8: User Access Control in Oracle


Question ID 7847

Which syntax turns an existing constraint on?

Option A

ALTER TABLE table_name ENABLE constraint_name;

Option B

ALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint _ name;

Option C

ALTER TABLE table_name ENABLE CONSTRAINT constraint _ name;

Option D

ALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint _ name;

Option E

ALTER TABLE table_name TURN ON CONSTRAINT constraint _ name;

Option F

ALTER TABLE table_name TURN ON CONSTRAINT constraint _ name;

Correct Answer C
Explanation Explanation/Reference: Explanation: ALTER TABLE statement with ENABLE CONSTRAINT keywords is correct answer to enable an existing constraint. Incorrect Answers A: This statement is missing CONSTRAINT keyword. B: "STATUS =" is incorrect syntax to enable constraint for the table. D: There is no STATUS keyword in the command to enable constraint. E: There is no TURN ON keywords in the command to enable constraint. F: There is no TURN ON keywords in the command to enable constraint. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 239-240 Chapter 5: Creating Oracle Database Objects

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