READ Free Dumps For Oracle- 1z0-001
| Question ID 8077 | Which privilege concerns with system level security?
|
| Option A | Drop any table.
|
| Option B | DELETE
|
| Option C | ALTER
|
| Option D | INDEX
|
| Option E | UPDATE
|
| Correct Answer | A |
Explanation Explanation/Reference: Explanation: Answer A is correct because only DROP ANY TABLE privilege from all choices belongs to SYSTEM level security, all others - not. Incorrect Answers: B: DELETE is object privilege. Permits the grantee of this object privilege to delete data from a table or view. C: ALTER is object privilege. Permits the grantee of this object privilege to alter the definition of a table or sequence only. The ALTER privileges on all other database objects are considered system privileges. D: INDEX is object privilege. Permits the grantee of this object privilege to create an index on a table already defined. E: UPDATE is object privilege. Permits the grantee of this object privilege to update data into a table or view. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 485 Chapter 10: Managing Database Use
| Question ID 8078 | Evaluate the SQL statement. CREATE ROLE manager; CREATE ROLE clerk; CREATE ROLE inventory; CREATE USER scott IDENTIFIED BY tiger; GRANT inventory TO clerk; GRANT clerk TO manager; GRANT inventory TO scott; / How many roles will user scott have access to?
|
| Option A | 0
|
| Option B | 1
|
| Option C | 2
|
| Option D | 3
|
| Correct Answer | B |
Explanation Explanation/Reference: Explanation: Answer B is correct because of only INVENTORY role will be granted to user SCOTT. Incorrect Answers: A: One role (INVENTORY) is granted to user SCOTT, not zero. C: This choice would be correct if role CLERK would be granted to SCOTT because this role includes INVENTORY role. D: This choice would be correct if role MANAGER would be granted to SCOTT because this role includes INVENTORY and CLERK roles. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 490-494 Chapter 10: Managing Database Use