Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.
All DDL commands are logged in the alert log file.
All DDL commands are logged in a different log file that contains DDL statements and their execution dates.
Only DDL commands that resulted in the creation of new segments are logged.
All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
第1题:
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.
第2题:
A. id
B. who
C. whois
D. lsuser
第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
第4题:
Which of the following commands can be used to watch system errors as they are logged?()
第5题:
Which of the following commands should be used to watch system errors as they are logged?()
第6题:
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.
第7题:
When does a transaction complete?()
第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
第9题:
Which of the following commands will show the users that are logged on a system ?()
第10题:
Examine the following command:ALTER SYSTEM SET enable_ddl_logging=FALSE;Which statement is true?()