ITPub博客

531.When starting up your ASM instance, you receive the following error:What is the cause of the error?A. The ASM_DISKGROUPS parameter is configured for three disk groups: DGROUP1, DGROUP2, andDGROUP3.The underlying disks for these disk groups have apparently been lost.B. The format of the ASM...

326.Which of the following does the recover command not do?A. Restore archived redo logs.B. Apply archived redo logs.C. Restore incremental backups.D. Apply incremental backups.E. Restore datafile images.Answer: E

577.What methods are available to recover lost control files? (Choose all that apply.)A. Backup control file.B. Emergency control file.C. The create controlfile command.D. The restore controlfile SQL*Plus command.E. No backup is required. The database will re-create the control file when it is ...

360.When performing a full database disaster recovery with RMAN, in what order would you executethese steps?A. Restore the control file from autobackups.B. Run the RMAN restore and recover command.C. Restore the database spfile from autobackups.D. Make the RMAN backup set pieces available.E. O...

698. In your production database, you:-Are using Recovery Manager (RMAN) with a recovery catalog to perform the backup operation at regularintervals-Set the control file autobackup to “on”-Are maintaining image copies of the database filesYou have lost the server parameter file (SPFILE) and t...

99.View the Exhibit and examine the steps that you executed to create a database resource plan.Subsequently, you execute the following procedure which results in an error:SQL> EXECUTE dbms_resources_manager.validate_pending_area ( );What could be the reason?Exhibit:A. The pending area is autom...

85.You executed the following command to drop a user:DROP USER scott CASCADE;Which two statements regarding the above command are correct? (Choose two.)A. All the objects of scott are moved to the Recycle Bin.B. Any objects in the Recycle Bin belonging to scott are purged.C. All the objects own...

449.Which of the following objects can be directly referenced by a window object? (Choose all that apply.)A. Schedule objectB. Program objectC. Job objectD. Resource planE. Resource consumer groupAnswer: ADWindow是Oracle数据库用来管理schedule jobs的一个工具，可以通过resource plan控制分配给作...

385.Which of the following statements is true regarding implementing a Flashback Table recovery?A. An SCN is never used to perform a Flashback Table recovery.B. If a significant number of changes have been made to the table, row movement must be enabled.C. The tablespace must be offline before pe...

100.Examine the following command that is used to duplicate a database on the same host:RMAN> RUN{ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK;DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; \ }Which two statements describe the effect after the database is duplicated successfully? (Choo...

513.What RMAN command is used to execute a tablespace point-in-time recovery?A. recoverB. duplicateC. restoreD. copyE. None of the aboveAnswer: A

98.You plan to execute the following command to perform a Flashback Database operation in yourdatabase:SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24);Which two statements are true about this? (Choose two)A. The database must have multiplexed redo log filesB. The database must be in the MO...

142.In which situations will the ASM metadata backup help you recover the ASM disk in a disk group?(Choose all that apply.)A. when one or more file directory paths are accidentally deleted from an ASM disk groupB. when one of the disks in a disk group is accidentaly unpluggedC. when the data fil...

291.ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is trueregarding the effect of queries and data manipulation language (DML) statements on the encrypted datain the tables?A. The data is decrypted during SORT and JOIN operations.B. The data remains encrypt...

540.Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION torecord the status of the operation?A. ADD DIRECTORYB. DROP DISKC. RESIZE DISKD. REBALANCEE. ADD FAILGROUPAnswer: A

412.Performance divergence indicated in the Workload Replay report is most likely due to what?A. DML and SQL statement results that do not match between the capture and replay systemsB. When errors that occur in the capture system dont occur in the replay systemC. Top SQL statementsD. Infrastruc...

208.You want to enable resumable space allocation at the instance level. Which two actions would enableresumable space allocation at the instance level? (Choose two.)A. issuing the ALTER SYSTEM ENABLE RESUMABLE; statementB. issuing the ALTER SESSION ENABLE RESUMABLE; statementC. modifying the RE...

568.Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOGmode? (Choose all that apply.)A. Database datafilesB. Control filesC. Archived redo logsD. Online redo logsE. Flashback logsAnswer: ABD

706. You execute the following command to set the redundancy retention policy in Recovery Manager(RMAN):RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 3;Identify the statement that correctly describes the implications of this command.A, when there are already three backups, for the fourth backup...

290.What are the recommendations for Oracle Database 11g installation to make it Optimal FlexibleArchitecture (OFA)-compliant? (Choose all that apply.)A. ORACLE_BASE should be set explicitly.B. An Oracle base should have only one Oracle home created in it.C. Flash recovery area and data file loc...