ITPub博客

143.Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)A. Database must be running in archivelog mode.B. Automatic undo management must be enabled.C. Undo retention guarantee must be enabled.D. The tablespace on which the Flashback Data Archive is created must be mana...

9.Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedurefor LOB space usage?A. It returns space usage of only BasicFile LOB chunks.B. It returns space usage of only SecureFile LOB chunks.C. It returns both BasicFile and SecureFile LOB space usage for only nonp...

121.Which three statements are true regarding the functioning of the Autotask Background Process(ABP)? (Choose three.)A. It creates jobs without considering the priorities associated with them.B. It translates tasks into jobs for execution by the scheduler.C. It determines the list of jobs that ...

610.Which of the following advisors is run in every maintenance window by the auto-task system?A.The Memory AdvisorB.The SQL Tuning AdvisorC.The Undo AdvisorD.The SQL Access AdvisorAnswer: B参考：http://blog.itpub.net/17013648/viewspace-1326757/三种自动任务：SQL> select operation_name fro...

652.Tape streaming is not happening while performing RMAN tape backup. On investigation, you find thatit is not because of the incremental backup or the empty file backup and that RMAN is sending datablocks to the tape drive fast enough.What could be a solution to make tape streaming happen durin...

287.Evaluate the following command:SQL> CREATE TABLE design_data (id NUMBER,doc CLOB) LOB(doc) STORE AS SECUREFILE(DEDUPLICATE);Which statement is true regarding the above command?A. The LOB values are automatically compressed.B. The LOB values are cached by default in the buffer cache.C....

507.Your database is running In ARCIIIVELOG mode. One of the data files, USBRDATAOI. DBF, in theusers tablespace is damaged and you need to recover the file until the point of failure. The backup for thedata file is available.Which three files would be used in the user-managed recovery process pe...

30.Which two statements are true with respect to the maintenance window? (Choose two.)A. A DBA can enable or disable an individual task in all maintenance windows.B. A DBA cannot change the duration of the maintenance window after it is created.C. In case of a long maintenance window, all Automat...

289.You are managing the APPPROD database as a DBA which is not using the Oracle-managed files.You plan to duplicate this database in the same system with the name DUPDB.You want to create thesame directory structure for duplicate database files as of the target database.You executed the followin...

269.Examine the following set of RMAN commands:RMAN> CONFIGURE CHANNEL dc1 DEVICE TYPE DISK FORMAT ?/u02 /backup/ %U' "; RMAN> RUN(ALLOCATE CHANNEL Chi DEVICE TYPE DISK;EXECUTE SCRIPT full_backup;)Which statement is true when the RMAN RUN block Is executed?A. The execution of the script fails...

78.You enable block change tracking. You issue the following command:BACKUP INCREMENTAL LEVEL 0 DATABASE;The next day, you issue the following command:BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;Which statement about the use of the change tracking file is true?A. RMAN reads the block change ...

424.Which of these components correctly identify the unique value of the NAME column in theDBA_RESUMABLE view?A. Username, instance number, session IDB. Instance number, username, session IDC. Instance number, session ID, usernameD. Username, session ID, instance numberE. None of the aboveAns...

77.You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance.At the end of the day, while all three production database instances are running, you execute the followingcommand on the ASM instance :SQL> shutdown immediate;What is the result of executing this comm...

455.When a job exceeds the date specified in its END_DATE attribute, which of the following will happen?(Choose all that apply.)A. The job will be dropped automatically if the value of the AUTO_DROP attribute is TRUE. B. The job will only be disabled if the value of the AUTO_DROP attribute i...

123.What two statements are true regarding the recommendations received from the SQL Access Advisor?(Choose two.)A. It cannot generate recommendations that support multiple workload queries.B. It can recommend partitioning on tables provided that the workloads have some predicates and joinson th...

132.You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, abig file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each. Whichmethod would accomplish the task quickly and efficiently?A. parallel image copy backupB. backup with...

124.You are managing Oracle Database 11g with an ASM storage with high redundancy. The followingcommand was issued to drop the disks from the dga disk group after five hours:ALTER DISKGROUP dga OFFLINE DISKS IN FAILGROUP f2 DROP AFTER 5H;Which statement is true in this scenario?A. It starts the ...

332.David managed to accidentally delete the datafiles for database called DSL. He called Heber andHeber tried to help but he managed to delete the control files of the database. Heber called Bill and Billsaved the day. They are using a recovery catalog for this database. What steps did Bill perfo...

130.Which are the prerequisites for performing flashback transactions on your database? (Choose all thatapply.)A. Undo retention guarantee for the database must be configured.B. Supplemental log must be enabled for the primary key.C. Supplemental log must be enabled.D. Execute permission on the...

96.Examine the following command:SQL> ALTER TABLE booking SHRINK SPACE COMPACT;Which activity is performed when the preceding command is executed?A. The shrink operation touches every block in the BOOKING tableB. The high-water mark (HWM) for the BOOKING table is shifted from its original positi...