随笔分类 - 归档
摘要:Given the following steps, which would be the correct order to create a backup of an Oracle database in NOARCHIVELOG mode?A. shutdown immediate from R
阅读全文
摘要:Consider the following command:Backup database plus archivelog delete input;How many backup sets would be created by this command if the following wer
阅读全文
摘要:You are trying to recover your database. During the recovery process, you receive the following error:ORA-00279: change 5033391 generated at 08/17/200
阅读全文
摘要:You have lost all your online redo logs. As a result, your database has crashed. You have tried to restart the database and clear the online redo log
阅读全文
摘要:Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to theSYSTEM tablespace and two are assigned to the USERS tables
阅读全文
摘要:Your developers have asked you to restore the development database, which is in NOARCHIVELOG mode, back to last Tuesday the 20th. Your last backup is
阅读全文
摘要:Which files are required for a full recovery of the database in ARCHIVELOG mode? (Choose three.)A. Database datafilesB. Online redo logsC. Archived re
阅读全文
摘要:Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOGmode? (Choose all that apply.)A. Database datafilesB. Cont
阅读全文
摘要:How many individual archive-log destination directories are supported by Oracle Database11g?A. 7B. 1C. 10D. 11E. 21 Oracle provides support for up to
阅读全文
摘要: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 sta
阅读全文
摘要: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 alte
阅读全文
摘要:What will be the result of the following configuration?Log_archive_dest_1=location=c:\oracle\arch\mydbLog_archive_dest_2=location=z:\oracle\arch\mydbA
阅读全文
摘要:Archived redo logs can be copied to more than one destination by Oracle.A. TrueB. False Oracle can be configured to copy archived redo logs to up to 1
阅读全文
摘要:Which of the following parameters defines the location where Oracle should create archived redologs?A. LOG_ARCHIVE_1B. LOG_DESTINATION_1C. LOG_ARCHIVE
阅读全文
摘要:What is the correct order of steps to perform an online database backup?A. alter database begin backup;B. alter database end backup;C. Back up the dat
阅读全文
摘要:Which is the correct command to put the database in ARCHIVELOG mode?A. alter database archivelogB. alter system enable archivelog modeC. alter databas
阅读全文
摘要:What are the different logging modes available in Oracle Database 11g? (Choose two.)A. NOLOG modeB. NOARCHIVELOG modeC. LOGGING modeD. HOTDATABASE mod
阅读全文
摘要:You backed up the database at 8 a.m. today using an online backup. Accounting made a largechange to the underlying data between 10 a.m. and noon. Whic
阅读全文
摘要:Your database is in NOARCHIVELOG mode. You start to do a backup, but your users complain thatthey dont want you to shut down the database to perform t
阅读全文
摘要:If a log file becomes corrupted, it may cause the database to stall. How would you correct such asituation?A. Recover the online redo log from backup.
阅读全文
浙公网安备 33010602011771号