ITPub博客

693. Which two statements are true about an image copy backup? (Choose two.)A. It may only be taken to disk.B. It will contain only the used blocks.C. It will contain all used and unused blocks.D. It can be performed on disk as well as on tape.Answer:AC参考：http://docs.oracle.com/cd/E11882_0...

129.You are managing an Oracle Database 11g database with ASM storage. The ASM disk group has theCOMPATIBLE.ASM attribute set to 11.1. Which statements are true regarding extent management andallocation units in the ASM disk group? (Choose all that apply.)A. The au_size disk group attribute deter...

285.View the Exhibit to examine the error while executing the REPAIR FAILURE command in an RMANsession.What is the reason for this error?A. Another repair session is running concurrently.B. The failure ID has not been mentioned in the command for data file 5.C. There are new failures recorded ...

254.Which three statements correctly describe the features of the I/O calibration process? (Choosethree.)A. Only one I/O calibration process can run at a time.B. It automates the resource allocation for the Automated Maintenance Tasks.C. It improves the performance of the performance-critical se...

649.Examine the CREATE DISKGROUP command used to create a disk group:SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCYDISK 'ORCL: FRA3' NAME misc1, 'ORCL: FRA4' NAME misc2;In which situation would you use this method of disk group creation?A. When two-way disk mirroring is required for the allocati...

678.Which are the two prerequisites before setting up Flashback Data Archive? (Choose two.)A.Flash recovery area must be definedB.Undo retention guarantee must be enabled.C.Database must be running in archivelog mode.D.Automatic undo management must be enabled.E.The tablespace in which the Flas...

337.You have lost all your RMAN backup set pieces due to a disk failure. Unfortunately, you have anautomated cross-check script that also does a delete expired backupset command. You have restored allthe backup set pieces from tape. What command would you use to get those backup set piecesregiste...

173.Which of the following is not a configurable attribute for an individual disk group?A. AU_SIZEB. COMPATIBLE.RDBMSC. COMPATIBLE.ASMD. DISK_REPAIR_TIMEE. DG_DROP_TIMEAnswer: EE选项，貌似没有查到这个参数

516.In a Database Replay workload capture, what client request information is gathered? (Choose all thatapply.)A. SQL textB. Shared server requests (Oracle MTS)C. Bind variable valuesD. Information about transactionsE. Remote DESCRIBE and COMMIT operationsAnswer: ACDhttp://docs.oracle.com/c...

617.A database instance is using an Automatic Storage Management (ASM) instance, which has a diskgroup, DGROUP1, created as follows:SQL> CREATE DISKGROUP dgroup1 NORMAL REDUNDANCYFAILGROUP controller1 DISK '/devices/diska1', '/devices/diska2' FAILGROUP controller2 DISK'/devices/diskb1', '/device...

432.For which of the following can you use Segment Shrink? (Choose all that apply.)A. Heap tablesB. Tables with function-based indexesC. IndexesD. Partitions and subpartitionsE. None of the aboveAnswer: ACD带有函数索引的表不能收缩段参考：https://docs.oracle.com/cd/B28359_01/server.111/b283...

365.Which of the following restrictions are not true with respect to tablespace point-in-time recovery?(Choose all that apply.)A. The target database must be in NOARCHIVELOG mode.B. No backup is required of the database before you perform a TSPITR.C. You must have all archived redo logs generate...

193.What is the purpose of the recover command? (Choose all that apply.)A. Recover database datafiles from physical disk backup sets.B. Recover required incremental backups from physical disk backup sets.C. Recover required archived redo logs from physical disk backup sets.D. Apply incremental b...

425.Which of the following are included in a transportable tablespace set? (Choose all that apply.)A. The datafiles that make up a self-contained group of tablespaces required for copyB. The system tablespaceC. An export of the tablespace metadataD. The spfileE. All of the aboveAnswer: AC...

582.You are trying to recover your database. During the recovery process, you receive the following error:ORA-00279: change 5033391 generated at 08/17/2008 06:37:40 needed for thread 1ORA-00289:suggestion:/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17/o1_mf_1_11_%u_.arcORA-00280: chan...

311.Given the scriptcreate script db_backup_datafile_script{backup datafile and 1, and2 plus archivelog delete input;}What is the result of running this command?Run {execute script db_backup_datafile_script using 2;}A. The script will fail since you instructed RMAN to back up only one datafile ...

411.Which is true concerning Database Replay in an Oracle Real Application Cluster (RAC) database?A. Workload capture is per instance.B. You only need to restart one instance to begin workload capture.C. Specifically in RAC, you shut down all instances, restart them individually, and begin work...

216.Which three elements can a job chain process involve? (Choose three)A. an eventB. a scheduleC. a programD. another chainE. a lightweight jobAnswer: BDE正确答案应为ACD?官方参考：http://docs.oracle.com/cd/B28359_01/server.111/b28310/scheduse009.htm#ADMIN12458Defining Chain StepsAf...

710. You executed the following commands in a database session:Which statement is true about the contents of the recycle bin in this situation?A.They remain unaffected.B.They are moved to flashback logs.C.They are moved to the undo tablespace.D.They are moved to a temporary tablespace.E.The ob...

36.Which two statements are true regarding the functionality of the remap command in ASMCMD?(Choose two.)A. It repairs blocks that have read disk I/O errors.B. It checks whether the alias metadata directory and the file directory are linked correctly.C. It repairs blocks by always reading them f...