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

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

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

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.


参考答案:B

第2题:

Which of the following commands will show the users that are logged on a system ?()

A. id

B. who

C. whois

D. lsuser


参考答案:B

第3题:

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 channel

B. It backs up two copies of data files to tape and disk, and two copies of archived log file on tape

C. It backs up the data files and archived log files to disk, making two copies of each data file and archived log file

D. It backs up the data files and archived log files to tape, making two copies of each data file and archived log file


参考答案:D

第4题:

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

正确答案:A

第5题:

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

正确答案:A

第6题:

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.


参考答案:A

第7题:

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

正确答案:B,D,E

第8题:

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 backup

B. It contains all data from target database until the current time

C. It contains all data from only the committed transactions in the target database

D. It contains all data except that which is used by the transactions in the current online redo file of target database


参考答案:D

第9题:

Which of the following commands will show the users that are logged on a system ?()

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

正确答案:B

第10题:

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.

正确答案:A

更多相关问题