231、

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 cannot be changed.D. All passwords remain non-case-sensitive until their password attribute in the profile is altered.

 

232、

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. optimization of materialized views for maximum query usage and fast refresh

 

233、

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 for a few SQL statements. What would you do with these SQL statements?A. Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.B. Capture the plans from the previous version using STS and then load them into the stored outline.C. Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB). D. Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.

 

234、

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

 

235、

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.)A. The databases configured to use the ASM instance are mountedB. The disk groups are mounted as per the ASM_DISKGROUPS initialization parameterC. ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not startedD. ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters