ITPub博客

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

279.Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window? (Choose all that apply.) A. generating the SQL profile.B. testing and accepting the SQL profileC. generating a list of candidate SQLs for tuningD. adding tuned SQL plans into t...

275.You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUT parameter set to a nonzero value. Which three statements about resumable space allocation are true? (Choose three.)A. Even with resumable space allocation enabled for your database, you can disab...

273.Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g? (Choose all that apply.)A. It does not allow you to change the moving window size.B. Adaptive threshold functionalities use it by default to compute statistics.C. It is created by default wit...

272.You issue the following RMAN command to set a retention policy on a database:RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2;What will be the outcome of issuing this command?A. After two days, a backup will be marked obsoleteB. After two days, a backup will be deleted from the mediaC. If th...

270.Which tasks are run automatically as part of the Automated Maintenance Task by default?(Choose all that apply.)A. Segment AdvisorB. SQL Access AdvisorC. Optimizer statistics gatheringD. Automatic SQL Tuning AdvisorE. Automatic Database Diagnostics MonitorAnswer: ACD 默认情况下，...

263.Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service (IPS) to MetaLink? A. The database must be running in ARCHIVELOG mode.B. No special setup is required, and the feature is enable...

261.In which cases is reference partitioning effective in enhancing performance? A. It is effective only in partition pruning.B. It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.C. It is effective in both partition prun...

200.Which operation requires that you create an auxiliary instance manually before executing the operation? (Choose all that apply.)A. Backup-based database duplication.B. Active database duplication.C. Tablespace point-in-time recovery.D. No operation requires the creation of an auxiliary insta...

197.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;Answer: D参考：http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmreprt.htm#CHDDBJHCRMAN> report schema;使用目标数据库控制文件替代...

196.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 backup-related metadata from the recovery catalogC. To create metadata in the control file and the recovery catalog related to backup set pieces...