READ Free Dumps For Oracle- 1z0-023
| Question ID 8767 | Which view will show a list of privileges that are available for the current session to a user?
|
| Option A | SESSION_PRIVS
|
| Option B | DBA_SYS_PRIVS
|
| Option C | DBA_COL_PRIVS
|
| Option D | DBA_SESSION_PRIVS
|
| Correct Answer | A |
Explanation Explanation/Reference: Explanation: Answer A is correct. SESSION_PRIVS will show a list of privileges that are available for the current session to a user. Incorrect Answers: B: DBA_SYS_PRIVS view identifies all the role and user grantees and granted system privileges to those roles and users. C: There is no DBA_COL_PRIVS view in Oracle. D: There is no DBA_SESSION_PRIVS view in Oracle. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 495 Chapter 10: Managing Database Use
| Question ID 8768 | How does a DBA specify multiple control files?
|
| Option A | With the ADD CONROLFILE command.
|
| Option B | By using the files in the STARTUP command.
|
| Option C | With the MULTIPLEX control file command.
|
| Option D | By listing the files in the CONTROL_FILES parameter.
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation: Answer D is correct. There is CONTROL_FILES parameter in initSID.ora file, it is used to multiplex control files. Incorrect Answers: A: There is no ADD CONTROLFILE in Oracle. B: STARTUP command uses initSID.ora file parameters, you can not use other files, except initSID.ora, in the STARTUP command in Oracle. C: There is no MULTIPLEX control file command in Oracle. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 571-572 Chapter 12: Overview of Backup and Recovery