网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You discover that your Recycle Bin contains two tables with the same name， MY_TABLE. You also have a table named MY_TABLE in your schema. You execute the following statement： FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2； What will be the result of executing this statement？（）
A
One of the tables is recovered from the Recycle Bin using a First In First Out （FIFO） approach.
B
One of the tables is recovered from the Recycle Bin using a Last In First Out （LIFO） approach.
C
Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.
D
None of the tables are recovered from the Recycle Bin， and the statement returns an error.
参考答案
参考解析
解析：
暂无解析
更多 “单选题You discover that your Recycle Bin contains two tables with the same name， MY_TABLE. You also have a table named MY_TABLE in your schema. You execute the following statement： FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2； What will be the result of executing this statement？（）A One of the tables is recovered from the Recycle Bin using a First In First Out （FIFO） approach.B One of the tables is recovered from the Recycle Bin using a Last In First Out （LIFO） approach.C Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.D None of the tables are recovered from the Recycle Bin， and the statement returns an error.” 相关考题
考题
单选题Which of the following statements is true regarding the initialization parameter DIAGNOSTIC_DEST？（） The default value is the value of the environment variable $ORACLE_HOME； if $ORACLE_HOME isn’t setA
then the default is set to $ORACLE_BASE The default value is the value of the environment variable $ORACLE_BASE； if $ORACLE_BASE isn’t set，B
then it is set to $ORACLE_HOMEC
DIAGNOSTIC_DEST is always equal to $ORACLE_HOMED
DIAGNOSTIC_DEST is always equal to $ORACLE_BASE
考题
单选题Examine the following values of the initialization parameters in the database having the SID ORCL: BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST= The environment variables have the following value: ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1 What is the location of the Automatic Diagnostic Repository (ADR) home?（）A
/u01/app/oracle/product/11.1.0/db_1B
/u01/app/oracleC
$ORACLE_HOME/bdumpD
$ORACLE_HOME/log
考题
多选题To enable faster incremental backups， you enabled block change tracking for the database. Which two statements are true about the block change tracking file？（）AMultiple change tracking files can be created for a database.BThe change tracking file must be created after the first level 0 backup.CRMAN does not support backup and recovery of the change tracking file.DThe database clears the change tracking file and starts tracking changes again，after whole database restore and recovery operations.
考题
单选题In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file. Which option must you consider for this task?（）A
using only the RMAN SWITCH command to set the new location for the data fileB
placing the database in the MOUNT state for the restore and recovery operations.C
using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.D
configuring two channels: one for the restore operation and the other for the recovery operation
考题
多选题For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?（）(Choose two.)AviewsBfixed tablesCheap tablesDexternal tablesEtemporary tablesFindex-organized tables (IOT)
考题
单选题Your database interface is running. A user SCOTT starts a SQL *Plus session， and issues the following query： SQL SELECT * FROM sales； Which process would retrieve the result from the database and return it to the client program？（）A
User processB
Server processC
System Monitor （SMON）D
Process Monitor （PMON）E
Checkpoint process （CKPT）
考题
单选题A user named Arren is executing this query： select table_name，operation，undo_sql from flashback_transaction_query t， （select versions_xid as xid from employees versions between scn minvalue and maxvalue where employee_id = 123） e where t.xid = e.xid； When the query runs，he receives an ORA-01031： insufficient privileges error. Since the user owns the employees table，you know that it is not the problem. Which of the following SQL statements will correct this problem？（）A
GRANT SELECT ANY TRANSACTION TO ARRENB
GRANT SELECT ON FLASHBACK_TRANSACTION_QUERY TO ARRENC
GRANT SELECT_ANY_TRANSACTION TO ARREND
GRANT FLASHBACK TO ARRENE
GRANT SELECT ANY VIEW TO ARREN
考题
单选题Which of the following is a benefit of ASM fast disk resync？（）A
Failed disks are taken offline immediately but are not dropped.B
Disk data is never lost.C
By default， the failed disk is not dropped from the disk group ever， protecting you from loss of that disk.D
The failed disk is automatically reformatted and then resynchronized to speed up the recovery process.E
Hot spare disks are automatically configured and added to the disk group.
考题
单选题The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below： LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’ LOG_ARCHIVE_DEST_2 = ’SERVICE = stdb1’ DB_RECOVERY_FILE_DEST = ’/u01/oradata’ Examine the following RMAN command issued to set the deletion policy for archived log files： RMAN CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO sbt； Which statement is true regarding what this command accomplishes？（）A
All archived redo log files backed up at least twice to tape are deleted.B
All archived redo log files backed up at least once to tape are eligible for deletion.C
All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.D
All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.
考题
单选题A developer calls and reports that he accidentally dropped an important lookup table from a production database. He needs the table to be recovered. What action would you take？（）A
Initiate an incomplete recovery operation using RMAN.B
Copy the table from a development database.C
Advise the user to rekey the data.D
Perform a Flashback Drop operation.E
Perform a Flashback Recovery operation.
考题
单选题In Recovery Manager （RMAN）， you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task， you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged， you want to place the data file in a different location while resto ing the file. Which option must you consider for this task？（）A
using only the RMAN SWITCH command to set the new location for the data fileB
placing the database in the MOUNT state for the restore and recovery operationsC
using an RMAN RUN block with the SET NEWNAME and then the SWITCH commandD
configuring two channels： one for the restore operation and the other for the recovery operation
热门标签
最新试卷