READ Free Dumps For Oracle- 1z0-023
| Question ID 8825 | User A grants the SELECT privilege WITH GRANT OPTION on the table EMP to User
|
| Option A | User B then grants SELECT on a EMP to User C. What will happen if User A revokes User B's SELECT privilege?
|
| Option B | User B will not be able to SELECT, and User C will be unaffected.
|
| Option C | An error will occur unless User B first revokes SELECT from user C.
|
| Option D | Nothing, unless the CASCADE CONSTRAINTS option was used.
|
| Option E | Both User B and User C will no longer have SELECT privilege on EMP.
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation: Answer D is correct. When an object privilege is revoked, there are some cascade events. If user A revokes user B's SELECT privilege, both user B and user C will no longer have SELECT privilege on EMP table. Incorrect Answers: A: Both user will be affected, B and C. B: There is no error if user A revokes from user B SELECT privilege, cascade event will happened. C: You don't need to use CASCADE CONSTRAINTS to revoke privilege. Only if the user has been given the REFERENCES privileges and used it to create a FOREIGN KEY constraint to another table, then there is some cascading that must take place in order to complete the revocation of the REFERENCES privilege: REVOKE REFERENCES ON EMP FROM B CASCADE CONSTRAINTS. But this question does say nothing about constraints. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 485-489 Chapter 10: Managing Database Use
| Question ID 8826 | Which two methods will open a database? (Choose two)
|
| Option A | Issue the STARTUP command from SQL*Plus
|
| Option B | Issue the START ORACLE command from SQL* Plus
|
| Option C | Issue the ALTER DATABASE OPEN command from SQL*Plus
|
| Option D | Issue the START ORCL command from the operating system prompt
|
| Option E | Issue the START ORCL command from the operating system prompt
|
| Correct Answer | AC |
Explanation Explanation/Reference: Explanation: Answers A and C are correct. You can use two commands to open a database : STARTUP command and ALTER DATABASE OPEN. Incorrect Answers: B: There is no START ORACLE command in Oracle. D: There is no START ORACLE command in any operation system. E: STARTUP DATABASE OPEN command does not exist in any operation system. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 281-283 Chapter 6: basics of the Oracle Database Architecture