READ Free Dumps For Oracle- 1z0-023
| Question ID 8823 | Which four keywords in the CREATE DATABASE command affect the size of the control file? (Choose four)
|
| Option A | MAXLOGFILES
|
| Option B | MAXDATAFILES
|
| Option C | MAXLOGGROUPS
|
| Option D | MAXLOGHISTORY
|
| Option E | MAXLOGMEMBERS
|
| Correct Answer | ABDE |
Explanation Explanation/Reference: Explanation: Answers A, B, D, E are correct. MAXLOGFILES, MAXDATAFILES, MAXLOGHISTORY, MAXLOGMEMBERS will affect the size of the control file. Incorrect Answers: C: MAXLOGGROUPS keyword does not exist in Oracle. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 318-324 Chapter 7: Managing the Physical Database Structure
| Question ID 8824 | Which view shows a DBA which users have the SELECT ANY TABLE privilege?
|
| Option A | DBA_PRIVS
|
| Option B | DBA_TAB_PRIVS
|
| Option C | DBA_SYS_PRIVS
|
| Option D | DBA_COL_PRIVS
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation: Answer C is correct. You can find information about system privileges granted to all users in the DBA_SYS_PRIVS view. Incorrect Answers: A: DBA_PRIVS view shows all available privileges, disregarding of privileges for users. B: DBA_TAB_PRIVS view shows privileges on tables, not system privileges for users. D: DBA_COL_PRIVS view as DBA_TAB_PRIVS view provides information about the object privileges granted in the database. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 489 Chapter 10: Managing Database Use