ITPub博客

449.Which of the following objects can be directly referenced by a window object? (Choose all that apply.)A. Schedule objectB. Program objectC. Job objectD. Resource planE. Resource consumer groupAnswer: ADWindow是Oracle数据库用来管理schedule jobs的一个工具，可以通过resource plan控制分配给作...

385.Which of the following statements is true regarding implementing a Flashback Table recovery?A. An SCN is never used to perform a Flashback Table recovery.B. If a significant number of changes have been made to the table, row movement must be enabled.C. The tablespace must be offline before pe...

100.Examine the following command that is used to duplicate a database on the same host:RMAN> RUN{ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK;DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; \ }Which two statements describe the effect after the database is duplicated successfully? (Choo...

513.What RMAN command is used to execute a tablespace point-in-time recovery?A. recoverB. duplicateC. restoreD. copyE. None of the aboveAnswer: A

98.You plan to execute the following command to perform a Flashback Database operation in yourdatabase:SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24);Which two statements are true about this? (Choose two)A. The database must have multiplexed redo log filesB. The database must be in the MO...

142.In which situations will the ASM metadata backup help you recover the ASM disk in a disk group?(Choose all that apply.)A. when one or more file directory paths are accidentally deleted from an ASM disk groupB. when one of the disks in a disk group is accidentaly unpluggedC. when the data fil...

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

540.Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION torecord the status of the operation?A. ADD DIRECTORYB. DROP DISKC. RESIZE DISKD. REBALANCEE. ADD FAILGROUPAnswer: A

412.Performance divergence indicated in the Workload Replay report is most likely due to what?A. DML and SQL statement results that do not match between the capture and replay systemsB. When errors that occur in the capture system dont occur in the replay systemC. Top SQL statementsD. Infrastruc...

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