ITPub博客

（117）Which two changes and their effect on the system can be tested by using the Database Replay feature?(Choose two.)A. multiplexing of the control fileB. adding the redo log member to the databaseC. database and operating system upgradesD. changing the database storage to ASM-mana...

（116）Which two are the uses of the ASM metadata backup and restore(AMBR) feature?(Choose two.)A. It can be used to back up all data on ASM disks.B. It can be used to recover the damaged ASM disk group along with the data.C. It can be used to gather information about a preexisting ASM di...

（115）What are the advantages of variable extent size support for large ASM files?(Choose two.)A. It improves resync operations when the disk comes online after being taken offline for maintenance purposes.B. It improves performance in the extended cluster configuration by reading from a loc...

（114）Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g?(Choose all that apply.)A. Generate reports on data failure such as data file failures.B. You can track the Service Request(SR)and implement repairs.C. You can package and upload d...

（113）Which statement is true regarding virtual private catalogs?A. A virtual private catalog owner can create a local stored script,and have read/write access to a global stored script.B. The virtual private catalog owner cannot create and modify the stored scripts.C. The set of views a...

（112）Your database initialization parameter file has the following entry:SEC_MAX_FAILED_LOGIN_ATTEMPTS = 3Which statement is true regarding this setting?A. It drops the connection after the specified number of login attempts fail for any user.B. It is enforced only if the password p...

（111）Which three statements are true regarding persistent lightweight jobs?(Choose three.)A. Persistent lightweight jobs modify several tables in the data dictionary to generate a lot of redo.B. The user cannot set privileges on persistent lightweight jobs.C. Persistent lightweight jobs...

（110）You plan to collect the Automatic Workload Repository(AWR) data every Monday morning for a month.You want Oracle Database to automatically create a baseline every Monday and remove the old baseline.What is the correct action to achieve this?A. Create and populate a SQL Tuning Set f...

（109）Which statement describes the effect of table redefinition on the triggers attached to the table?A. All triggers on the table are invalidated and are automatically revalidated with the next DML execution on the table.B. All triggers on the table are invalidated and must be manually rec...

（108）You are managing an Oracle Database 11g instance with ASM storage.You lost an ASM disk group DATA.You have RMAN backup of data as well as ASM metadata backup.You want to re-create the missing disk group by using the ASMCMD md_restore command.Which of these methods would you use to ...

（107）Which components are needed for successful and most efficient recovery. （废题）A. The backup RB3 and the current online redo log filesB. the backup RB2 and the archived redo log files after the log sequence number 15622C. Backup R81 and the archived redo log hies after the log seq...

（106）You are working as a DBA on the decision support system.There is a business requirement to track and store all transactions for at least three years for a few tables in the database.Automatic undo management is enabled in the database.Which configuration should you use to accomplis...

（105）Which statements are true regarding table compression?(Choose all that apply.)A. It saves disk space and reduces memory usage.B. It saves disk space but has no effect on memory usage.C. It incurs extra CPU overhead during DML as well as direct loading operations.D. It incurs ex...

（104）You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high.One of the disks in the disk group becomes unavailable because of power failure.Which statements will be true in this scenar...

（103）Observe the following PL/SQL block:BEGIN  dbms_spm.configure('SPACE_BUDGET_PERCENT', 30);END;Which statement is correct regarding the above PL/SQL block?A. It automatically purges the SQL management objects when SMB occupies more than 30%of the SYSAUX tablespace....

（102）Examine the following values of the initialization parameters in the database having the SID ORCL:BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdumpUSER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udumpCORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdumpDIAGNO...

（101）Identify two situations in which you can use Data Recovery Advisor for recovery.(Choose two.)A. The user has dropped an important table that needs to be recovered.B. The database files are corrupted when the database is open.C. You are not able to start up the database instance bec...

（100）Examine the following command that is used to duplicate a database on the same host:RMAN>RUN{  ALLOCATE AUXILIARY CHANNEL aux1 DEVICE TYPE DISK;  DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY;...

（99）View the Exhibit and examine the steps that you executed to create a database resource plan.Subsequently,you execute the following procedure which results in an error:SQL>EXECUTE dbms_resources_manager.validate_pending_area();What could be the reason?Exhibit:A. The pending a...

（98）You plan to execute the following command to perform a Flashback Database operation in your database: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...