摘要:
You notice that a long-running transaction is suspended due to a space constraint, and there is no AFTER SUSPEND triggered event addressing the issue. 阅读全文
摘要:
The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his unique knowledge of the application. Which of these are 阅读全文
摘要:
Which of the following are true concerning block media recovery? (Choose all that apply.)A. Any gap in archive logs ends the recovery.B. If a gap in a 阅读全文
摘要:
In a Database Replay workload capture, what client request information is gathered? (Choose all thatapply.)A. SQL textB. Shared server requests (Oracl 阅读全文
摘要:
A developer calls and reports that he accidentally dropped an important lookup table from aproduction database. He needs the table to be recovered. Wh 阅读全文
摘要:
A user performs an update on a table. Shortly after committing the transaction, they realize that theyhad an error in their WHERE clause causing the w 阅读全文
摘要:
What RMAN command is used to execute a tablespace point-in-time recovery?A. recoverB. duplicateC. restoreD. copyE. None of the above You use the recov 阅读全文
摘要:
Which operation requires that you create an auxiliary instance manually before executing theoperation? (Choose all that apply.)A. Backup-based databas 阅读全文
摘要:
When youre performing a tablespace point-in-time recovery, which tablespaces will always berestored to the auxiliary instance? (Choose all that apply. 阅读全文
摘要:
What are the two different types of database duplication? (Choose two.)A. ActiveB. PassiveC. OnlineD. Backup-basedE. Failure driven Active database du 阅读全文
摘要:
Which of the following commands will fail?A. report schema;B. report need backup;C. report need backup days 3;D. report user; E. report obsolete; Ther 阅读全文
摘要:
What is the purpose of the catalog command?A. To review RMAN control file and recovery catalog metadata and ensure that its correctB. To delete RMAN b 阅读全文
摘要:
What is the purpose of the list expired backup command?A. Lists all backups impacted by a resetlogs commandB. Lists all backups that are subject to re 阅读全文
摘要:
What is an obsolete backup set?A. A backup set that is missing one or more backup set piecesB. A backup that has exceeded the retention criteria and i 阅读全文
摘要:
What is the purpose of the recover command? (Choose all that apply.)A. Recover database datafiles from physical disk backup sets.B. Recover required i 阅读全文
摘要:
What is the purpose of the until change option of the restore command?A. It allows you to select the SCN that you want to restore to. B. It allows you 阅读全文
摘要:
While working on a data problem, Curt, Bill, Ben, Mike, and Matt introduced a vast amount ofcorrupted data into the database. Pablo has discovered thi 阅读全文
摘要:
You have control-file autobackups enabled. When starting your database from SQL*Plus, you receive the following error message:SQL> startup ORA-01078: 阅读全文
摘要:
What RMAN command must you use before you can back up a database using the recovery catalog?A. create catalogB. install databaseC. catalog databaseD. 阅读全文
摘要:
You can back up the RMAN recovery catalog with RMAN.A. TrueB. False You can back up any database without connecting to the recovery catalog,includingt 阅读全文