单选题Examine the following command:ALTER SYSTEM SET enable_ddl_logging=FALSE;Which statement is true?（）A None of the data definition language (DDL) statements are logged in the trace file.B Only DDL commands that resulted in errors are logged in the alert l

第1题：

You are the newly appointed system administrator at Certkiller.com. The previous administratorcreated a Microsoft ASP.NET application using Microsoft .NET Framework v3.5.  You need to capture the timing and performance information of the application. Managementwants you to make sure that data is only accessible when a client is logged onto the Web servernot the individual Web pages.  What should you do？（）

• A、You should consider adding <compilation debug="true" /> to the Web.config file.
• B、You should consider adding <compilation debug="false" urlLinePragmas="true" /> to theWeb.config file.
• C、You should consider adding <trace enabled="true" writeToDiagnosticsTrace="true"pageOutput="true" localOnly="true" /> to the Web.config file.
• D、You should consider adding <trace enabled="true" pageOutput="false" localOnly="true" /> tothe Web.config file.

第2题：

Which of the following commands will show the users that are logged on a system ?（）

• A、id
• B、who
• C、whois
• D、lsuser

第3题：

Examine the following command:ALTER SYSTEM SET enable_ddl_logging=FALSE;Which statement is true?（）

• A、None of the data definition language (DDL) statements are logged in the trace file.
• B、Only DDL commands that resulted in errors are logged in the alert log file.
• C、A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.
• D、Only DDL commands that resulted in the creation of new database files are logged.

第4题：

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.

第5题：

Which two statements are true about standard database auditing（）

• A、DDL statements can be audited.
• B、Statements that refer to stand-alone procedure can be audited.
• C、Operations by the users logged on as SYSDBA cannot be audited.
• D、Only one audit record is ever created for a session per audited statement even though it is executedmore than once.

第6题：

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

第7题：

In your test database， you find that a user’s session is executing a lot of SQL statements， resulting in the generation of a large number of trace files. While investigating the reason， you find that SQL trace has been enabled at the instance level. You want to disable SQL trace， remotely， only for that user session to reduce the volume of trace data being generated.How do you achieve this objective？（）

• A、 by setting the SQL_TRACE parameter to FALSE in the parameter file
• B、 by using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user session
• C、 by setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user session
• D、 by setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user session

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Which of the following commands should be used to watch system errors as they are logged？（）

• A、 errpt -c
• B、 tail -f /var/adm/ras/errlog
• C、 syslogd -d
• D、 /usr/lib/errdemon -s 8192

第14题：

Which of the following commands can be used to watch system errors as they are logged？（）

• A、 smit errpt
• B、 smit errdemon
• C、 smit alog
• D、 smit syslogd

第15题：

Examine the following command; ALTER SYSTEM SET enable_ddl_logging = TRUE; Which statement is true?（）

• A、Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.
• B、All DDL commands are logged in the alert log file.
• C、All DDL commands are logged in a different log file that contains DDL statements and their execution dates.
• D、Only DDL commands that resulted in the creation of new segments are logged.
• E、All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.

第16题：

Examine the following query output: You issue the following command to import tables into the hr schema: $ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y Which statement is true?（）

• A、All database operations performed by the impdp command are logged.
• B、Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.
• C、Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.
• D、None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.

第17题：

Examine the following statement that is used to modify the constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）

• A、The constraint remains valid.
• B、The index on the constraint is dropped.
• C、It allows the loading of data into the table using SQL*Loader.
• D、New data conforms to the constraint， but existing data is not checked
• E、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

第18题：

What are three benefits of performing data definition language （DDL） statements against a partitioned table with the UPDATE GLOBAL INDEXES clause？（）

• A、Global indexes are rebuilt automatically at the end of the DDL operation thereby avoiding problems with the UNUSABLE status. 
• B、You do not have to search for invalid global indexes after the DDL command completes and rebuild them individually. 
• C、Global indexes are maintained during the operation of the DDL command and therefore can be used by any concurrent query. 
• D、Global indexes remain intact and available for use by data manipulation language （DML） statements even for sessions that have not enabled the skipping of unusable indexes.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：