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 7840

You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others. Which statement accomplishes this?

Option A

GRANT select, insert, update ON student_grades TO manager

Option B

GRANT select, insert, update ON student_grades TO ROLE manager

Option C

GRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;

Option D

GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;

Option E

GRANT select, insert, update ON student_grades TO ROLE manager WITH GRANT OPTION;

Option F

F.GRANT select, insert, modify ON student_grades TO ROLE manager WITH GRANT OPTION;

Correct Answer D
Explanation Explanation/Reference: Explanation: This answer provides correct syntax of GRANT command to give the MANAGER role all asked privileges. Clause WITH GRANT OPTION will allow this role to pass those privileges on to others. Incorrect Answers A: This statement would be correct if it included WITH GRANT OPTION clause to allow this role to pass those privileges on to others. B: This statement uses incorrect clause TO ROLE. C: There is no option with name MODIFY in the GRANT command. E: This statement uses incorrect clause TO ROLE. F: There is no option with name MODIFY in the GRANT command. And this statement also uses incorrect clause TO ROLE. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 356-365 Chapter 8: User Access Control in Oracle


Question ID 7841

Examine the data in the EMPLOYEES table:

LAST_NAME DEPARTMENT_ID SALARY

Getz 10 3000

Davis 20 1500

Bill 20 2200

Davis 30 5000 ...

Which three subqueries work? (Choose three)

Option A

SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id);

Option B

SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);

Option C

SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);

Option D

SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);

Option E

SELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);

Option F

SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));

Correct Answer CDE
Explanation Explanation/Reference: Explanation: These answers show correct syntax, because they use ANY and ALL keywords for convert multi-row output of sub-query to one-row result. Incorrect Answers A: This SELECT statement is incorrect because of multi-row return of sub-query: it will return minimal salary for EACH department. B: This SELECT statement is incorrect because of multi-row return of sub-query: it will return average salary for EACH department. F: This SELECT statement is incorrect because GROUP BY clause cannot contain functions, like AVG(), MIN (), MAX() and so on. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 145-156 Chapter 4: Subqueries

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