ITPub博客

686. You execute the following FLASHBACK TABLE command:Which two statements are correct?(Choose two.)A.The EMP table that was dropped by mistake earlier is restored.B.The FLASHBACK TABLE statement is executed as a single transaction.C.The FLASHBACK TABLE statement does not maintain existing ind...

实验的时候碰到一个错误：SQL> create table t1 as select rownum rn from dual connect by rownum <= 10000;create table t1 as select rownum rn from dual connect by rownum <= 10000                                  &nb...

20.View the Exhibit and examine the resource consumption details for the current plan in use by thedatabase instance.Which two statements are true based on the output? (Choose two.)Exhibit:A. An attempt to start a new session by the user belonging to DSS_QUERIES fails with an errorB. A user be...

206.Which statements are true regarding the Query Result Cache? (Choose all that apply.)A. It can be set at the system, session, or table level.B. It is used only across statements in the same session.C. It can store the results from normal as well as flashback queries.D. It can store the resu...

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...