网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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.
参考答案
参考解析
解析：
暂无解析
更多 “单选题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.” 相关考题
考题
You issued the following commands to configure setting in RMAN;Then you issued the following command to take the backup:RMAN BACKUP DATABASE PLUS ARCHIVELOG;Which statement is true about the execution of the above command?（）A. The backup will terminate because the FORMAT clause was not configured for the channelB. It backs up two copies of data files to tape and disk, and two copies of archived log file on tapeC. It backs up the data files and archived log files to disk, making two copies of each data file and archived log fileD. It backs up the data files and archived log files to tape, making two copies of each data file and archived log file
考题
Examine the following scenario:The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:Which statement is true about the duplicate database in this scenario?（）A. It contains data till the last backupB. It contains all data from target database until the current timeC. It contains all data from only the committed transactions in the target databaseD. It contains all data except that which is used by the transactions in the current online redo file of target database
考题
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.
考题
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.
考题
Which of the following commands will show the users that are logged on a system ?()
A. idB. whoC. whoisD. lsuser
考题
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
考题
Which of the following commands should be used to watch system errors as they are logged？（）A、 errpt -cB、 tail -f /var/adm/ras/errlogC、 syslogd -dD、 /usr/lib/errdemon -s 8192
考题
Which of the following commands will show the users that are logged on a system ?（）A、idB、whoC、whoisD、lsuser
考题
Which of the following commands can be used to watch system errors as they are logged？（）A、 smit errptB、 smit errdemonC、 smit alogD、 smit syslogd
考题
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.
考题
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.
考题
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.
考题
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.
考题
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.
考题
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.
考题
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 1B、Only 2C、Only 3D、3 and 1E、1 and 2
考题
单选题Which of the following commands can be used to watch system errors as they are logged？（）A
smit errptB
smit errdemonC
smit alogD
smit syslogd
考题
单选题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.
考题
单选题Examine the following scenario： The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host， using the Recovery Manager （RMAN） duplicate command as follows： RMAN RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK； DUPLICATE TARGET DATABASE TO auxdb； } Which statement is true about the duplicate database in this scenario？（）A
It contains data till the last backupB
It contains all data from target database until the current timeC
It contains all data from only the committed transactions in the target databaseD
It contains all data except that which is used by the transactions in the current online redo file of target database
考题
多选题When does a transaction complete?（）Awhen a DELETE statement is executedBwhen a ROLLBACK command is executedCwhen a PL/SQL anonymous block is executedDwhen a data definition language (DDL) statement is executedEwhen a TRUNCATE statement is executed after the pending transact ion
考题
多选题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?（）ADatabase operations will be monitored only when they consume a significant amount of resource.BDatabase operations for all sessions will be monitored.CDatabase operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + tuning.DOnly DML and DDL statements will be monitored for the session.EAll subsequent statements in the session will be treated as one database operation and will be monitored.
考题
多选题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？（）AThe script is stored only in the control file.BThe script is stored only in the recover catalog.CThe script can be executed only by using the RMAN RUN command.DThe commands of the script can be displayed with the LIST command.EThe commands of the script can be displayed with the PRINT command.FThe commands of the script can be displayed with the REPORT command.
考题
单选题You issued the following commands to configure setting in RMAN; Then you issued the following command to take the backup: RMAN BACKUP DATABASE PLUS ARCHIVELOG; Which statement is true about the execution of the above command?（）A
The backup will terminate because the FORMAT clause was not configured for the channelB
It backs up two copies of data files to tape and disk, and two copies of archived log file on tapeC
It backs up the data files and archived log files to disk, making two copies of each data file and archived log fileD
It backs up the data files and archived log files to tape, making two copies of each data file and archived log file
考题
单选题Which of the following commands will show the users that are logged on a system ?（）A
idB
whoC
whoisD
lsuser
考题
单选题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.
考题
单选题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.
考题
单选题Which of the following commands should be used to watch system errors as they are logged？（）A
errpt -cB
tail -f /var/adm/ras/errlogC
syslogd -dD
/usr/lib/errdemon -s 8192
热门标签
最新试卷