单项选择题

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.

<上一题目录下一题>

热门试题

单项选择题IfyouissuethecommandshutdownabortpriortotryingtoputthedatabaseinARCHIVELOGmode，whatwillbetheresultwhenyouissuethecommandalterdatabasearchivelog？（）

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

单项选择题AnotherDBAissuesashutdownabortcommandonadatabaseonwhichyouwererunninganonlinebackup.Whatwillhappenwhenyoutrytorestartthedatabase？（）

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.

单项选择题Whichviewprovidesinformationonthebackupstatusofthedatafilesinthedatabase？（）

A. V$BACKUP
B. V$BACKUP_STATUS
C. V$BACKUP_DATAFILE
D. V$DATAFILE_BACKUP
E. V$TABLESPCE_BACKUP

单项选择题What will be the result of the following configuration？（） Log_archive_dest_1=location=c： oracle arch mydb Log_archive_dest_2=location=z： oracle arch mydb

A. An error will occur during database startup because the second parameter is not valid.
B. An error will occur during database startup since you are trying to create archived redo logs in two different locations.
C. Archived redo logs will be created in two different locations by the ARCH process.
D. Archived redo logs will be created in two different locations by the LGWR process.
E. Neither parameter setting is valid， so the database will not start up.

单项选择题ArchivedredologscanbecopiedtomorethanonedestinationbyOracle.（）

A. True
B. False