1.
How many individual archive-log destination directories are supported by Oracle Database 11g?
- A.7
- C.10
- E.21
- B.1
- D.11
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| Oracle provides support for up to 10 different archive-log destination directories. |
2.
Your archive-log destination directory runs out of space. What is the impact of this on the
database?
- A.None. The database will switch over to the stand-by archive-log destination directory.
- B.A warning message will be written to the alert log of the database, but no adverse impacts to the database will be experienced.
- C.The database will shut down, and will not restart until you correct the out-of-space situation.
- D.The database will continue to try to write to the archive-log destination directory for one hour. After one hour, the database will shut down normally.
- E.Once Oracle has cycled through all online redo logs, it will stop processing any DML or DDL until the out-of-space condition is corrected.
- Answer & Explanation
- Report
Answer : [E]
Explanation :
Explanation :
| Oracle will cycle through all of the online redo logs, trying to archive them after they have been filled. After cycling through the last online redo log, Oracle will suspend all database operations until the out-of-space condition is corrected. |
3.
If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode, what will be the result when you issue the command alter
database archivelog?
- A.The alter database archivelog command will fail.
- B.The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG mode.
- C.The alter database archivelog command will succeed.
- D.The alter database archivelog command will ask if you want to make the database consistent first.
- E.There is no alter database archivelog command. The correct command is alter database alterlogging.
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| The alter database archivelog command will fail. You will need to open the database and then shut it down in a consistent manner. |
4.
What is the proper command to shut down the database in a consistent manner?
- A.Shutdown abort
- B.Shutdown kill
- C.Shutdown nowait
- D.shutdown immediate
- E.shutdown halt
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| The shutdown immediate command is used to shut down the database in a consistent manner. |
5.
Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database?
- A.Oracle will automatically take the datafile out of hot backup mode, generate a warning message, and then open the database.
- B.Oracle will automatically take the datafile out of hot backup mode and then open the database.
- C.Oracle will generate an error when trying to open the database, indicating that a datafile is in hot backup mode. You will need to correct this error before you can open the database.
- D.The database will open with the file in hot backup mode. You can restart the backup at any time.
- E.The datafile in hot backup mode will be corrupted and you will have to recover it.
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| Oracle will generate an error indicating that a datafile is in hot backup mode. You will need to issue the alter database end backup command to make sure all datafiles in hot backup mode are no longer in hot backup mode. You can then use the alter database open command to open the database. |
|
|
||||||||||||||||||||||||||||
