ITPub博客

208.You want to enable resumable space allocation at the instance level. Which two actions would enableresumable space allocation at the instance level? (Choose two.)A. issuing the ALTER SYSTEM ENABLE RESUMABLE; statementB. issuing the ALTER SESSION ENABLE RESUMABLE; statementC. modifying the RE...

568.Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOGmode? (Choose all that apply.)A. Database datafilesB. Control filesC. Archived redo logsD. Online redo logsE. Flashback logsAnswer: ABD

706. You execute the following command to set the redundancy retention policy in Recovery Manager(RMAN):RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 3;Identify the statement that correctly describes the implications of this command.A, when there are already three backups, for the fourth backup...

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

469.Which of the following NLS_SORT parameter values would result in case-insensitive andaccent-insensitive binary sorts?A. NLS_SORT = BINARYB. NLS_SORT = BINARY_AIC. NLS_SORT = BINARY_CID. NLS_SORT = BINARY_AI_CIE. Binary sorts are case insensitive and accent insensitive by default.Answer: B...

207.You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database.Which two statements are true regarding the activities performed during the test execution of SQLs in aSQL Tuning Set? (Choose two.)A. Every SQL statement in the STS is considered only once for execut...

328.You have backed up your database using image copies. You have lost the SYSTEM tablespace andneed to restart your database as quickly as possible. What is the correct solution?A. Restore the SYSTEM tablespace from the last backup set and then recover the database.B. Restore the SYSTEM tablespa...

486.You execute the following Recovery Manager (RMAN) commands in (he following order:BACKUP VALIDATE DATABAERECOVER CORRUPTION LIST;Which (two tasks are performed by these commands? (Choose two.)A. Repair the corrupted blocks. If any. In the backup created.B. Populate V$COPV_CORRUPTION with na...

145.You need to perform an online table redefinition of an existing SALES table to partition it into twotablespaces TBS1 and TBS2. The SALES table has a materialized view, materialized log, indexes,referential integrity constraint, and triggers with the PRECEDES clause existing on it.What action ...

487.When executing a SQL workload, you choose to generate execution plans only, without collectingexecution statistics.Which two statements describe the implications of this? (Choose two.)A. It produces less accurate results of the comparison analysis.B. It automatically calls the SQL Tuning Adv...

169.Exhibit #1:Exhibit #2:View the Exhibit exhibit1 to observe the maintenance window property. View the Exhibit exhibit2 toexamine the output of the query.Which two statements describe the conclusions? (Choose two.)A. RESOURCE_PERCENTAGE should be increased.B. The repeat time for the window...

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

http://mp.weixin.qq.com/s?__biz=MjM5MDAxOTk2MQ==&mid=402587120&idx=1&sn=1304b693d66997f38a1643199eebe034&scene=1&srcid=0322mRQqbOYHF13JMJoBQITv&from=groupmessage&isappinstalled=0#wechat_redirect

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选项，貌似没有查到这个参数