READ Free Dumps For Oracle- 1z0-023
| Question ID 8771 | Which two dynamic views can be queried when the database is started up in nomount state? (Choose two)
|
| Option A | V$SGA
|
| Option B | V$LOGFILE
|
| Option C | V$INSTANCE
|
| Option D | V$CONTROLFILE
|
| Option E | V$DATAFILE_HEADER
|
| Correct Answer | AC |
Explanation Explanation/Reference: Explanation: Answers A and C are correct. Before database mount and open we can only monitor information regarding instance. So only two views can be queried at this point : V$SGA, responsible for the SGA information, and V$INSTANCE, responsible for the instance. Incorrect Answers: B: Because database is not opened we cannot query V$LOGFILE view because it resides in the data dictionary of the database. D: Because database is not mounted or opened we cannot query V$CONTROLFILE view because it resides in the data dictionary of the database. E: Because database is not mounted or opened we cannot query V$DATAFILE_HEADER view because it resides in the data dictionary of the database. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 281-283 Chapter 6: Basics of the Oracle Database Architecture
| Question ID 8772 | Which two tasks occur as the database transitions from the mount stage to the open stage? (Choose two)
|
| Option A | The online data files are opened.
|
| Option B | Memory for the SGA is allocated.
|
| Option C | The Oracle password file is opened.
|
| Option D | The online redo log files are opened.
|
| Option E | Stored procedures are pinned in the library cache.
|
| Correct Answer | AD |
Explanation Explanation/Reference: A. D Explanation: Answers A and D are correct. When you open database the online datafiles and online redo logs files will be opened. Incorrect Answers: B: Memory for the SGA is allocated when the instance was started, not with open stage. C: The Oracle password file is opened when you try to connect to Server manager to start the instance, if you use password file. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 281-283 Chapter 6: Basics of the Oracle Database Architecture