网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
Which two statements are true about the Automatic Diagnostic Repository （ADR）？（）
A
The ADR base keeps all diagnostic information in binary format
B
SQL*Plus provides the ADRI script， which can be used to work with ADR
C
The ADR can be used for problem diagnosis only when the database is open
D
The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null
E
The ADR can be used for problem diagnosis even when the database instance is down
F
The ADR base is shared across multiple instances
参考答案
参考解析
解析：
暂无解析
更多 “多选题Which two statements are true about the Automatic Diagnostic Repository （ADR）？（）AThe ADR base keeps all diagnostic information in binary formatBSQL*Plus provides the ADRI script， which can be used to work with ADRCThe ADR can be used for problem diagnosis only when the database is openDThe ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to nullEThe ADR can be used for problem diagnosis even when the database instance is downFThe ADR base is shared across multiple instances” 相关考题
考题
单选题To clean up old records that are in a Flashback Data Archive and are past the retention period， what must the DBA do？（）A
TRUNCATE the archive table.B
DROP the Flashback Data Archive.C
Nothing；expired rows are automatically removed.D
Nothing；expired rows are moved to an archive table.E
Delete entries from the archive where the metadata date retained is greater than the retention period.
考题
单选题A user sends you an email with the following error message： create table idtable（id number） * ERROR at line 1： ORA- 01110： data file 4： ，，/oracle01/oradata/orcl/users01.dbf ORA-27041： 01116： error in opening database file 4 ORA-unable to open file Linux Error： 2： No such file or directory Additional information： 3 You can choose from the following steps： a. Restore the missing database datafiles. b. Take the missing datafile offline. c. Shut down the database. d. Issue the recover tablespace USERS command. e. Issue the Startup Mount command to mount the database. f. Bring the USERS tablespace online. g. Issue the alter database open command. Which is the correct order of these steps in this case？（）A
b， a， d， fB
c， a， e， b， d， f， gC
c， e， d， gD
b， d， f E
e， d， g
考题
多选题On which two database objects can the VERSIONS clause of the Flashback Versions Query be used？（）Afixed tablesBheap tablesCexternal tablesDtemporary tablesEIndex-Organized Tables （IOTs）
考题
单选题Examine the following scenario: - Database is running in ARCHIVELOG mode. - Complete consistent backup is taken every Sunday. - On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted - The disk having active online redo log files is also corrupted. - The hardware is repaired and the paths for online redo log files and control files are still valid. Which option would you use to perform the recovery of database till the point of failure?（）A
Restore the latest whole backup, perform complete recovery, and open the database normallyB
Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS option.C
Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS option.D
Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option.
考题
单选题What is the net effect of the following command？（） alter diskgroup dgroup1 drop disk abc；A
The disk ABC will be dropped from the disk group. Since you did not issue a rebalance command，the data on that disk will be lost.B
The command will raise an error indicating that you need to rebalance the disk group to remove the data from that disk prior to dropping the disk.C
The disk group will be automatically rebalanced during the drop operation. Once the rebalancing is complete，the disk will be dropped.D
This command will fail because you cannot drop a specific disk in an ASM disk group.E
The disk drop command will be suspended for a predetermined amount of time，waiting for you to also issue an alter diskgroup rebalance command. Once you have issued the rebalance command，ASM will proceed to rebalance the disk group and then drop the disk.
考题
单选题You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option. After some days， you want to change the status of the database backup and you issued the following command： RMANCHANGE BACKUPSET 231 NOKEEP； What is the implication of this command？（）A
The backup is deleted.B
The backup is marked unavailable.C
The backup overrides the backup retention policy.D
the backup becomes eligible for deletion according to the existing retention policy.
考题
多选题What is the purpose of the recover command？（）ARecover database datafiles from physical disk backup sets.BRecover required incremental backups from physical disk backup sets.CRecover required archived redo logs from physical disk backup sets.DApply incremental backups to recover the database.EApply archived redo logs to recover the database.
考题
单选题Because of a logical corruption in your production database， you wanted to perform Tablespace Point in Time Recovery （TSPITR）. But before you start the recovery，you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object？（）A
Perform Export before TSPITR and Import after TSPITRB
Move objects to another schema that has the same tablespace assignedC
Perform Incomplete Recovery before TSPITR with the Log Sequence Number （LSN）D
Perform Incomplete Recovery before TSPITR with the System Change Number （SCN）
考题
多选题Which two statements are true regarding Health Monitor checks in Oracle Database 11g？（）AHealth Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption.BHealth Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible，corrupt or inconsistent.CHealth Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically.DHealth Monitor checks are always initiated manually when there is some critical error.
考题
单选题Note the output of the following query； SQL SELECT flashback_archieve_name， status FROM dba_flashback_archieve； FLASHBACK_ARCHIEVE_NAME STATUS FLA1 You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table： ALTER TABLE exchange_rate FLASHBACK ARCHIEVE； What is the outcome of this command？（）A
The table uses the default Flashback Data Archive.B
The Flashback Data Archive Is created In the SYSAUX tablespace.C
The Flashback Data Archive is created in the same tablespace where the tables are stored.D
The command generates an error because no flashback Data Archive name is specified and there is no default Flashback Data Achieve.
考题
单选题Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode？（）A
alter tablespace DAVE_TBS backup modeB
alter tablespace DAVE_TBS start backupC
alter tablespace DAVE_TBS begin backupD
alter tablespace DAVE_TBS backup beginE
alter tablespace DAVE_TBS backup
热门标签
最新试卷