Which of the following objects contains control structures that are considered the bound form of SQL statements?（）A、UDTB、TriggerC、PackageD、Access plan

第1题：

第2题：

A site administrator is configuring Resource-level access control.  Which of the following statements about Resource-level access control are true？ Resource-level access control policies：（）

• A、are optional
• B、are used to protect data beans
• C、provide coarse-grained access control
• D、never specify a relationship

第3题：

You execute the following command to change the status of the SALES tablespace：  SQL> ALTER TABLESPACE sales OFFLINE；  Which statements describe the effect of the command（）

• A、The tablespace would require recovery to go back online.
• B、A checkpoint is taken on all data files that are associated with the SALES tablespace.
• C、The sessions that subsequently try to access the objects in the SALES tablespace receive an error.
• D、The new status of the SALES tablespace is recorded in the control file when the database instance is closed.

第4题：

Which of the following database objects can be used to raise an error if a table is updated?（）

• A、Package
• B、Trigger
• C、Stored Procedure
• D、Informational Constraint

第5题：

Which two statements about the SQL Management Base (SMB) are true? （）(Choose two.)

• A、It contains only SQL profiles generated by SQL Tuning Advisor.
• B、It stores plans generated by the optimizer using a stored outline.
• C、It is part of the data dictionary and stored in the SYSAUX tablespace.
• D、It is part of the data dictionary and stored in the SYSTEM tablespace.
• E、It contains the statement log, the plan history, plan baselines, and SQL profiles.

第6题：

What happens when you run the SQL Tuning Advisor with limited scope？（）  

• A、 Access path analysis is not performed for SQL statements.
• B、 SQL structure analysis is not performed for SQL statements.
• C、 SQL Profile recommendations are not generated for SQL statements.
• D、 Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor.

第7题：

You execute the following commands to audit database activities: SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE; SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about the audit record that generated when auditing after instance restarts?（）

• A、One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.
• B、One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.
• C、One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.
• D、One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.
• E、One audit record is created for the whole session if john successfully executes a SELECT, INSERT,or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.

第8题：

You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?（）

• A、Every SQL statement in the STS is considered only once for execution
• B、The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics
• C、The execution plan and execution statistics are computed for each SQL statement in the STS
• D、The effects of DDL and DML are considered to produce the execution plan and execution statistics

第9题：

Which one of the following files contains records that do not meet the specified load criteria in the SQL*Loader control file？（）

• A、Log file
• B、Discard file
• C、Parameter file
• D、Bad file

第10题：

第11题：

第12题：

第13题：

第14题：

To make audit information more productive， the DBA executes the following command before startingan audit operation：  SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE；  Which statement is true regarding the audit record generated when auditing starts after restarting thedatabase（）

• A、It contains only the plan for the SQL statement executed by the user.
• B、It contains the SQL text executed by the user and the bind variables used with it.
• C、It contains the plan and statistics associated with the SQL statement executed by the user.
• D、It contains the plan for the SQL statement executed by the user and the bind variables used with it.

第15题：

Which of the following database objects is considered executable using SQL?（）

• A、View
• B、Table
• C、Routine
• D、Package

第16题：

Which of the following are types of routine objects?（）

• A、Package and function
• B、Function and userexit
• C、Procedure and package
• D、Function and procedure

第17题：

Which statement is true when you run the SQL Tuning Advisor with limited scope？（）

• A、Access path analysis is not performed for the SQL statements.
• B、SQL structure analysis is not performed for the SQL statements.
• C、SQL Profile recommendations are not generated for the SQL statements.
• D、The staleness and absence of the statistics are not checked for the objects in the query supplied to the SQL Tuning Advisor.

第18题：

You want to analyze a SQL Tuning Set （STS） using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set？（）

• A、 Every SQL statement in the STS is considered only once for execution.
• B、 The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics.
• C、 The execution plan and execution statistics are computed for each SQL statement in the STS. 
• D、 The effects of DDL and DML are considered to produce the execution plan and execution statistics.

第19题：

Which three statements about performance analysis by SQL Performance Analyzer are true？（）

• A、 It detects changes in SQL execution plans.
• B、 It produces results that can be used to create the SQL plan baseline.
• C、 The importance of SQL statements is based on the size of the objects accessed.
• D、 It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.
• E、 It shows only the overall impact on workload and not the net SQL impact on workload.

第20题：

You execute the following command to change the status of the SALES tablespace：SQL> ALTER TABLESPACE sales OFFLINE； Which statements describe the effect of the command（）

• A、The tablespace would require recovery to go back online.
• B、A checkpoint is taken on all data files that are associated with the SALES tablespace.
• C、The sessions that subsequently try to access the objects in the SALES tablespace receive an error
• D、The new status of the SALES tablespace is recorded in the control file when the database instance isclosed

第21题：

第22题：

第23题：