ITPub博客

（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)(...

（223）You plan to set up the Automatic Workload Repository baseline metric thresholds for a moving window baseline.Which action would you take before performing this task?A. Compute the baseline statistics.B. Take an immediate AWR snapshot.C. Decrease the window size for the baseline...

（222）You are managing an Oracle Database 11g instance with ASM storage.The ASM instance is down.To know the details of the disks in the DATA disk group,you issued the following ASMCMD command:ASMCMD>lsdsk -I -d DATAWhich statement is true regarding the outcome of this command?A.The ...

(221)To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code:BEGIN  dbms_advisor.create_task(dbms_advisor.sqlaccess_advisor, 'TASK1');END;...

（220）Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package? (Choose all that apply.)A. It can be used to allow the access privilege settings for users but not roles.B. It can be used to allow the access privilege settings for users as well as roles.C. It can b...

（219）You executed the following PL/SQL block successfully:VARIABLE tname VARCHAR2(20)BEGIN  dbms_addm.insert_finding_directive(NULL, DIR_NAME=>'Detail CPU Usage',         &nb...

（218）Your database is running in ARCHIVELOG mode.You are performing a user-managed backup of the DATA1 tablespace.You place the DATA1 tablespace in backup mode by issuing the following statement:ALTER TABLESPACE data1 BEGIN BACKUP;While you are performing the backup,an error occurs that...

（217）Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment.At the end of the upgrade,you observe that the DBA executes the following script: SQL>@utlrp.sqlWhat is the significance of executing this script?A. It perfo...