单选题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

第1题：

第2题：

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

第3题：

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

第4题：

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.

第5题：

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.

第6题：

You issue this RMAN command：   RMAN> create script Level0Backup {   backup   incremental level 0   format ‘/u01/db01/backup/%d_%_Sp’   fileperset 5   （database include current controlfile）；   sql ‘alter database archive log current’；   }  Which three statements are true about the Level0Backup script you just created？（）

• A、The script is stored only in the control file.
• B、The script is stored only in the recover catalog.
• C、The script can be executed only by using the RMAN RUN command.
• D、The commands of the script can be displayed with the LIST command.
• E、The commands of the script can be displayed with the PRINT command.
• F、The commands of the script can be displayed with the REPORT command.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

When does a transaction complete?（）

• A、when a DELETE statement is executed 
• B、when a ROLLBACK command is executed 
• C、when a PL/SQL anonymous block is executed 
• D、when a data definition language (DDL) statement is executed 
• E、when a TRUNCATE statement is executed after the pending transact ion

第14题：

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

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

第15题：

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.

第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题：

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.

第18题：

Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs. You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands: SQL > SHUTDOWN IMMEDIATE SQL > STARTUP MOUNT SQL > FLASHBACK DATABASE to TIME “TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”; Examine following commands: 1. ALTER PLUGGABLE DATABASE ALL OPEN; 2. ALTER DATABASE OPEN; 3. ALTER DATABASE OPEN RESETLOGS; Which command or commands should you execute next to allow updates to the flashback back schema?（）

• A、Only 1
• B、Only 2
• C、Only 3
• D、3 and 1
• E、1 and 2

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：