单项选择题
Evaluate the following command:
SQL>ALTER SYSTEM SET db_securefile = 'IGNORE';
What is the impact of this setting on the usage of SecureFiles?（）
A. It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOB
B. It forces SecureFiles to be created even if the BASICFILE option is specified to create the LOB
C. It does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is specified to create the LOB
D. It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a BasicFile
相关考题
-
多项选择题
View the Exhibit to examine the output for the V$DIAG_INFO view. Which statements are true regarding the location of diagnostic traces?（）
A. The path to the location of the background as well as the foreground process trace files is /u01/oracle/diag/rdbms/orclbi/orclbi/trace.
B. The location of the text alert log file is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.
C. The location of the trace file for the current session is /u01/oracle/diag/rdbms/orclbi/orclbi/trace.
D. The location of the XML-formatted version of the alert log is /u01/oracle/diag/rdbms/orclbi/orclbi/alert. -
单项选择题
You executed the following commands in an RMAN session for your database instance that has failures: RMAN> LIST FAILURE; After some time, you executed the following command in the same session: RMAN> ADVISE FAILURE; But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?（）
A. It produces a warning for new failures before advising for CRITICAL and HIGH failures.
B. It ignores new failures and considers the failures listed in the last LIST FAILURE command only.
C. It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.
D. It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored. -
单项选择题
Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?（）
A. only the control file, the current SPFILE, and data files
B. only the current SPFILE and data files if autobackup is disabled
C. only the data files and the archived redo logs
D. the control file, current SPFILE file, data files, and archived redo logs
