ITPub博客

（242）You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository.Which condition must be met before you create the VPC?A. A base catalog existsB. The recovery catalog is empty...

（241）You issued the following RMAN command to back up the database:RMAN> RUN{  ALLOCATE CHANNEL c1 DEVICE TYPE sbt  BACKUP DATABASE  TAG quarterly  KEEP FOREVER...

（240）You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks.One of the disks in the disk group becomes unavailable because of power failure.You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours:ALTER D...

（239）Evaluate the following command:SQL>ALTER SYSTEM SET db_securefile = 'IGNORE';What is the impact of this setting on the usage of SecureFiles?A. It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOB.B. It forces SecureFiles to be created ...

（238）View the Exhibit to examine the output for the V$DIAG_INFO view.Which statements are true regarding the location of diagnostic traces?(Choose all that apply.)A. The path to the location of the background as well as the foreground process trace files is/u01/oracle/diag/rdbms/orclbi/orclb...

（237）You executed the following commands in an RMAN session for your database instance that has failures:RMAN>LIST FAILURE;After some time,you executed the following command in the same session:RMAN>ADVISE FAILURE;But there are new failures recorded in the Automatic Diagnostic Repos...

（236）Your database is running in ARCHIVELOG mode,and the database is open.You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?A. only the control file,the current SPFILE,and data filesB. only the current SPFILE and data fil...

（235）The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration.You executed the following command to startup the Automatic Storage Management(ASM)instance.SQL>STARTUP;Which two activities are performed during a successful start up operation?(Choose two....

（234）Which type of backup contains only the blocks that have changed since the last level 0 incremental backup?A. a cumulative level 1 backupB. a differential level 1 backupC. a full backupD. a whole backup答案：（A）

（233）Your system has been upgraded from Oracle Database 10g to Oracle Database 11g.You imported SQL Tuning Sets(STS) from the previous version.After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer,you observed performance regression f...

（232）What recommendations does the SQL Access Advisor provide for optimizing SQL queries?(Choose all that apply.)A. selection of SQL plan baselinesB. partitioning of tables and indexesC. creation of index-organized tablesD. creation of bitmap,function-based,and B-tree indexesE. ...

（231）You upgraded Oracle Database 10g to Oracle Database 11g.How would this affect the existing users' passwords?A. All passwords automatically become case-sensitive.B. All passwords remain non-case-sensitive till they are changed.C. All passwords remain non-case-sensitive and canno...

（230）You plan to use Flashback Drop feature to recover a dropped table SALES_EMP.No other table with the same name exists in the schema.You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows:You then issue the following statement to recover the table:SQL>FLASHB...

（229）Which statements are true regarding SecureFile LOBs?(Choose all that apply.)A. The amount of undo retained is user controlled.B. SecureFile LOBs can be used only for nonpartitioned tables.C. Fragmentation is minimized by using variable-sized chunks dynamically.D. SecureFile enc...

（228）Evaluate the following statements:CREATE TABLE purchase_orders(  po_id       NUMBER(4),  po_date     TIMESTAMP,  supplier_id NUM...

（227）You plan to control idle sessions that are blocking other sessions from performing transactions.Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time.How would you accomplish this task?A. Set metric threshold...

（226）Examine the following PL/SQL block:DECLARE  my_plans pls_integer;BEGIN  my_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE(sql_id => '9twu5t2dn5xd');END;Which statement is...

（225）View the Exhibit to examine the Automatic Database Diagnostic Monitor(ADDM)tasks.You executed the following commands:SQL>VAR tname VARCHAR2(60);BEGIN  DBMS_ADDM.INSERT_SEGMENT_DIRECTIVE(:tname, 'Sg_directive', 'SCOTT');...

（224）You need to create a partitioned table to store historical data and you issued the following command:CREATE TABLE purchase_intervalPARTITION BY RANGE(time_id) INTERVAL(NUMTOYMINTERVAL(1, 'month'))STORE IN(tbs1, tbs2, tbs3)(...