网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You are using Recovery Manager （RMAN） with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure， you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You could consider performing the following steps to accomplish this task： 1） Restore an autobackup of the server parameter file. 2） Restore the control file. 3） Start the target database Instance. 4） Mount the database. 5） Restore the data files. 6） Open the database with the RESETLOGS option. 7） Recover the data files. 8） Set DBID for the target database Which option illustrates the correct sequence that you must use？（）
A
8， 1， 3， 2， 4， 5， 7， 6
B
1， 8， 3， 4， 2， 5， 7， 6
C
1， 3， 4， 2， 8， 5， 6， 7
D
1， 3， 2， 4， 6， 5， 7， 8
参考答案
参考解析
解析：
暂无解析
更多 “单选题You are using Recovery Manager （RMAN） with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure， you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You could consider performing the following steps to accomplish this task： 1） Restore an autobackup of the server parameter file. 2） Restore the control file. 3） Start the target database Instance. 4） Mount the database. 5） Restore the data files. 6） Open the database with the RESETLOGS option. 7） Recover the data files. 8） Set DBID for the target database Which option illustrates the correct sequence that you must use？（）A 8， 1， 3， 2， 4， 5， 7， 6B 1， 8， 3， 4， 2， 5， 7， 6C 1， 3， 4， 2， 8， 5， 6， 7D 1， 3， 2， 4， 6， 5， 7， 8” 相关考题
考题
多选题Which three statements are true about persistent configuration?（） (Choose three.)AA user cannot set privileges on the persistent lightweight jobsBPersistent lightweight jobs generate a large amount of metadataCIt is possible to create fully self-contained persistent lightweight jobsDThe use of a template is mandatory to create persistent lightweight jobsEPersistent lightweight jobs are useful when users need to create a large number of jobs in a short time
考题
单选题You have control-file autobackups enabled. When starting your database from SQL*Plus， you receive the following error message： SQL startup ORA-01078： failure in processing system parameters LRM-00109： could not open parameter file ， C:///ORACLE/PRODUCT/11.1.0/DB_1/DATABASE/INITORCL.ORA Using RMAN， how would you respond to this error？（）A
Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.B
Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.C
Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.D
Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.E
Issue the restore spfile from autobackup command from the RMAN prompt.
考题
多选题Evaluate the following statements： CREATE TABLE purchase_orders （po_id NUMBER（4）， po_date TIMESTAMP， supplier_id NUMBER（6）， po_total NUMBER（8，2）， CONSTRAINT order_pk PRIMARY KEY（po_id）） PARTITION BY RANGE（po_date） （PARTITION Q1 VALUES LESS THAN （TO_DATE（？1-apr-2007？d-mon-yyyy？）， PARTITION Q2 VALUES LESS THAN （TO_DATE（？1-jul-2007？d-mon-yyyy？）， PARTITION Q3 VALUES LESS THAN（TO_DATE（？1-oct - 2007？d-mon-yyyy？）， PARTITION Q4 VALUES LESS THAN （TO_DATE（？1-jan-2008？d-mon-yyyy？））； CREATE TABLE purchase_order_items （po_id NUMBER（4） NOT NULL， product_id NUMBER（6） NOT NULL， unit_price NUMBER（8，2）， quantity NUMBER（8）， CONSTRAINT po_items_fk FOREIGN KEY （po_id） REFERENCES purchase_orders（po_id）） PARTITION BY REFERENCE（po_items_fk）； What are the two consequences of the above statements？（）APartitions of PURCHASE_ORDER_ITEMS have system-generated names.BBoth PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each.CPartitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.DThe PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.EPartition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.
考题
单选题Which type of backup must be performed first with an incremental backup？（）A
Level 1B
Level 0C
Level 2D
Level 3
考题
多选题When executing a SQL workload，you choose to generate execution plans only， without collecting execution statistics. Which two statements describe the implications of this？（）AIt produces less accurate results of the comparison analysis.BIt automatically calls the SQL Tuning Advisor for recommendations.CIt shortens the time of execution and reduces the impact on system resources.DOnly the changes in the execution plan，and not performance regression，are detected.
考题
单选题Which command do you use to generate a report of database incarnations？（）A
list incarnation of databaseB
report incarnation of databaseC
list database incarnationD
database incarnation listE
report database incarnation
考题
多选题The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance. SQL STARTUP; Which two activities are performed during a successful start up operation? （）(Choose two.)AThe databases configured to use the ASM instance are mountedBThe disk groups are mounted as per the ASM_DISKGROUPS initialization parameterCASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not startedDASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters
热门标签
最新试卷