ITPub博客

393.Which of the following initialization parameters have been deprecated in Oracle 11g because of the introduction of the Automatic Workload Repository? (Choose all that apply.)A. BACKGROUND_DUMP_DESTB. FOREGROUND_DUMP_DESTC. CORE_DUMP_DESTD. USER_DUMP_DESTE. DIAGNOSTIC_DESTF. All of the abov...

389.The _______ writes the Flashback Database logs in the flash recovery area.A. FLSHB. FLDBC. RVWRD. RVRWE. FBDAAnswer: C哪一个进程将闪回数据库日志写入闪回恢复区。

386.You have just performed a FLASHBACK TABLE operation using the following command:flashback table employees to scn 123456;The employees table has triggers associated with it. Which of the following statements is true regarding the state of the triggers during the Flashback Table operation?A. Al...

383.At the request of a user, you issue the following command to restore a dropped table: flashback table "BIN$F2JFfMq8Q5unbC0ceE9eJg==$0" to before drop;Later, the user notifies you that the data in the table seems to be very old and out of date. What might be the problem?A. Because a proper ran...

379.Users notify you that their application is failing every time they try to add new records. Because of poor application design, the actual ORA error message is unavailable. What might be the problem?(Choose the best answers.)A. The application user has exceeded their undo quota.B. The FLASHBACK...

378.In order to perform Flashback Transaction Query operations, which of these steps are required?(Choose all that apply.)A. Ensure that database is running with version 10.1 compatibility.B. Enable Flashback Logging.C. Enable Supplemental Logging.D. Ensure that the database is running with vers...

377.AUM has been retaining about 15 minutes worth of undo. You want to double the retention period, but not at the expense of new transactions failing. You decide to alter the system to set the parameter UNDO_RETENTION=18000. However, AUM still retains only about 15 minutes worth of undo. What is th...

373.Which of the following Oracle features utilize the undo tablespace? (Choose all that apply)A. Flashback QueryB. Flashback DropC. Flashback TableD. Flashback DatabaseE. Transaction ProcessingF. Recycle BinAnswer: ACE以下哪些Oracle特性是使用了撤消表空间？闪回查询，闪回表，事务处理。...

370.Why should you back up a duplicated tablespace after a TSPITR is complete?A. The tablespace cannot be duplicated or restored to any point in time after the duplication.B. The tablespace cannot be duplicated or restored to the point in time before the duplication.C. The entire database cannot ...

366.If you are going to run a TSPITR recovery, which view will help you to determine which objects will be lost during the TSPITR?A. TS_OBJECTS_TO_BE_DROPPEDB. TS_PTTR_OBJECT_DROPPEDC. TS_PITR_OBJECTS_TO_BE_DROPPEDD. TS_OBJECTS_DROPPEDE. TS_DROPPED_OBJECTSAnswer: C如果你要运行表空间时间点恢...

358.What command is used to reset a database to a previous incarnation?A. reset incarnationB. incarnation resetC. reset database to incarnationD. reset database incarnationE. reset databse incarnation numberAnswer: C使用什么命令将数据库重新设置到以往的场景？

354.Which command is used to begin a tablespace point-in-time recovery?A. Restore tablespaceB. Recover tablespaceC. Tablespace recoverD. Recover to timeE. recover datafileAnswer: B哪个命令用来开始一个表空间时间点的恢复？

353.True or false: tablespace point-in-time recovery is possible only with RMAN.A. TrueB. FalseAnswer: B表空间时间点只能用RMAN恢复？B、错。Tablespace point-in-time recovery has been done in Oracle for some time, using various means and methods. RMAN simply automates and simplifies the proces...

352.If a backup is expired, which of the following is true?A. It can never be used for a restore/recover operation.B. Oracle will remove the backup set pieces from the flash recovery area.C. The backup has been used at least once to restore and recover the database.D. The backup is no longer val...

351.What information does the report schema command not provide? (Choose all that apply.) A. Size of the datafilesB. Size of the tempfilesC. Date of last backup for datafiles and tempfilesD. Filenames for each datafileE. Checkpoint SCN associated with the last RMAN backupAnswe...

292.You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in /etc. Which two statements are true regarding this oranfstab file? (Choose two.) A. Its entries are specific to a single database.B. It contains file systems that have been mount...

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

290.What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (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 l...

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 matically compressed.B. The LOB values are cached bvalues are autoy default in the buffer cache.C. Th...

282.You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLTME.ASM attribute is set to 11.1. Which two statements are true ...