In the ORACLE system, sets of SQL statements and control flow statements that have been named, compiled ,and stored in database are referred to as storedA．batchesB．proceduresC．triggersD．transactions

第1题：

Which statement correctly describes SQL and /SQL*Plus?（）

• A、Both SQL and /SQL*plus allow manipulation of values in the database.
• B、/SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.
• C、/SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.
• D、/SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.

第2题：

Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you.  Which two statements are true in this scenario？（）

• A、The instance aborts.
• B、The database cannot be recovered.
• C、The database can be recovered by restoring the control files from the backup.
• D、The database remains opened and you have to shut it down with the ABORT option.
• E、The database can be restored till the point of the last closed whole database backup.

第3题：

On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: $> sqlldr hr/hr@pdb table=employees Which two statements are true regarding the command?（）

• A、It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.
• B、It fails because no SQL *Loader data file location is specified.
• C、It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.
• D、It fails because no SQL *Loader control file location is specified.

第4题：

You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database？（） 

• A、 The audit trail is stored in an operating system file.
• B、 Auditing is disabled for all privileges.
• C、 The audit trail is stored in the database.
• D、 Auditing is enabled for all privileges.
• E、 Auditing is enabled for certain privileges related to database security.

第5题：

You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? （）

• A、Library cache 
• B、Row cache
• C、Dictionary cache 
• D、Large area 
• E、Buffer cache

第6题：

Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.（）

• A、Change in the Oracle Database version
• B、Change in your network infrastructure
• C、Change in the hardware configuration of the database server
• D、Migration of database storage from non-ASM to ASM storage
• E、Database and operating system upgrade

第7题：

A Windows Azure application stores data in a SQL Azure database.  The application will start an operation that includes three insert statements.  You need to recommend an approach for rolling back the entire operation if the connection to SQL Azure is lost.  What should you recommend？（）

• A、 Ensure that all statements execute in the same database transaction.
• B、 Create a stored procedure in the database that wraps the insert statements in a TRY CATCH block.
• C、 Create a stored procedure in the database that wraps the insertstatements in a TRANSACTION block.
• D、 Open a new connection to the database. Use a separate transaction scope to roll back the original operation.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Which of these appropriately describes the results of a manual SQL Tuning Advisor task?（）

• A、A list of SQL statements and recommendations for tuning
• B、A list of SQL statements that have been tuned by the Advisor, with before and after metrics
• C、Graphs showing the actual performance improvement made by the Advisor after it implemented the recommended changes
• D、All of the above

第14题：

In your Certkiller .com database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting？（）

• A、The source PL/SQL code will be stored in native machine code.
• B、The source PL/SQL code will be stored in interpreted byte code.
• C、The compiled PL/SQL code will be stored in native machine code.
• D、The compiled PL/SQL code will be stored in interpreted byte code.

第15题：

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.

第16题：

Examine the commands executed to monitor database operations: $> conn sys oracle/oracle@prod as sysdba SQL > VAR eid NUMBER SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING => ‘Y’); Which two statements are true?（）

• A、Database operations will be monitored only when they consume a significant amount of resource.
• B、Database operations for all sessions will be monitored.
• C、Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + tuning.
• D、Only DML and DDL statements will be monitored for the session.
• E、All subsequent statements in the session will be treated as one database operation and will be monitored.

第17题：

You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in /etc. Which two statements are true regarding this oranfstab file？（））  

• A、 Its entries are specific to a single database.
• B、 It contains file systems that have been mounted by Direct NFS.
• C、 It is globally available to all Oracle 11g databases on the machine.
• D、 It contains file systems that have been mounted by the kernel NFS system.

第18题：

In your Supportcenter.cn database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting？（）

• A、The source PL/SQL code will be stored in native machine code.
• B、The source PL/SQL code will be stored in interpreted byte code.
• C、The compiled PL/SQL code will be stored in native machine code.
• D、The compiled PL/SQL code will be stored in interpreted byte code.

第19题：

第20题：

第21题：

第22题：

第23题：