ITPub博客

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

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