READ Free Dumps For Oracle- 1z0-001
| Question ID 8178 | The employee table contains two columns: BONUS NUMBER(7,2) DEPT_ID NUMBER(9) There are three departments and each department has at least one employee. Bonus values are greater than 500;not all employee receive a bonus. Evaluate this PL/SQL block: DECLARE v_bonus employee.bonus%TYPE:=300; BEGIN UPDATE employee SET bonus=bonus+v_bonus WHERE dept_id IN (10,20,30); COMMIT; END; What will be the result?
|
| Option A | All the employees will be given a 300 bonus.
|
| Option B | A subset of 300 employees will be given a 300 bonus.
|
| Option C | All employees will be given a 300 increase in bonus
|
| Option D | A subset of employees will be given a 300 increase in bonus.
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation: Answer D is correct because only employees from departments 10, 20, 30 will receive a 300 increase in bonus. Incorrect Answers: A: Not all employees have bonus by task description. B: Not 300 employees, but only whose who works in departments 10, 20, 30 will be given a 300 bonus. C: Not all employees have bonus increase. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 211-215 Chapter 5: Introducing PL/SQL
| Question ID 8179 | You have been granted update privileges on the last_name column of the employee table. Which data dictionary view would you query to display the column. The privileges was granted on the schema that owns the employee table?
|
| Option A | ALL_TABLES.
|
| Option B | ALL_SOURCES.
|
| Option C | ALL_OBJECTS.
|
| Option D | TABLE_PRIVILEGES.
|
| Option E | ALL_COL_PRIVS_RECD.
|
| Option F | This information can't be retrieved from a single data dictionary view.
|
| Correct Answer | E |
Explanation Explanation/Reference: Explanation: Answer E is correct because ALL_COL_PRIVS_RECD contains information about column for which you have been granted update privileges. Incorrect Answers: A: ALL_TABLES data dictionary view does not contain information about column for which you have been granted update privileges. B: ALL_SOURCES data dictionary view does not exist. C: ALL_OBJECTS data dictionary view does not contain information about column for which you have been granted update privileges. D: TABLE_PRIVILEGES data dictionary view does not contain information about column for which you have been granted update privileges, it contains only info about privileges on the table level. F: This information can be retrieved from ALL_COL_PRIVS_RECD data dictionary view. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 113-119 Chapter 3: Creating Oracle Database Objects