单选题Using the command shown here， what time format must you specify to recover the database until a point-in-time？（） SQL RECOVER DATABASE UNTIL TIME ’’；AYYYY-DD-MM:HH24:SS:MI BYYYY-DD-MM:HH24:SS:MM CYYYY-MM-DD:HH24:MI:SS DYYYY-DD-MM:SS:MI:HH24
单选题
Using the command shown here， what time format must you specify to recover the database until a point-in-time？（） SQL> RECOVER DATABASE UNTIL TIME ’’；
A
YYYY-DD-MM:HH24:SS:MI
B
YYYY-DD-MM:HH24:SS:MM
C
YYYY-MM-DD:HH24:MI:SS
D
YYYY-DD-MM:SS:MI:HH24
参考解析
解析：
暂无解析
相关考题：
创建数据库实例时，需要修改日期格式为________A.YYYY-MM-DD HH24:MI:SSB.MM-DD-YYYY HH24:MI:SSC.DD-MM-YYYY HH24:MI:SSD.MM-DD-YYYY HH:MI:SS
Usingthecommandshownhere,whattimeformatmustyouspecifytorecoverthedatabaseuntilapoint－in－time?()SQLRECOVERDATABASEUNTILTIME’timeformat’; A.YYYY-DD-MM:HH24:SS:MIB.YYYY-DD-MM:HH24:SS:MMC.YYYY-MM-DD:HH24:MI:SSD.YYYY-DD-MM:SS:MI:HH24
Which command will restore all datafiles to the date 9/30/2008 at 18:00 hours? （）A、restore datafiles until time '09/28/2008:21:03:11'B、restore database files until time '09/28/2008:18:00:00'C、restore database until time '09/28/2008:18:00:00'D、recover database until time '09/28/2008:18:00:00'E、recover database until timestamp '09/28/2008:18:00:00'
When you are performing media recover， and an archived log is lost or corrupt， which type of recover must you perform？（）A、Until SCNB、Until timeC、Until cancelD、Recover using backup control file.
You want to perform in incomplete recovery of your database. You plan to use these commands to recover your database： SET UNTIL TIME = ’2000-12-09：11：44：00’； RESTORE DATABASE； RECOVER DATABASE； How should the commands be executed？ （）A、Only the SET command must be within a RUN block.B、All commands should be executed at the RMAN prompt.C、All three commands must be within a single RUN block.D、Only the RESTORE and RECOVER commands must be within a single RUN block.
创建数据库实例时，需要修改日期格式为（）A、YYYY-MM-DD HH24:MI:SSB、MM-DD-YYYY HH24:MI:SSC、DD-MM-YYYY HH24:MI:SSD、MM-DD-YYYY HH:MI:SS
You want to import schema objects of the HR user using Oracle Data Pump from the development database，DEVDB， to the production database， PRODDB. A database link devdb.us.oracle.com is created betweenPRODDB and DEVDB. You execute the following command on the PRODDB database server：$ impdp system/manager directory = DB_DATAdumpfile = schemas.datschemas = hr flashback_time = "TO_TIMESTAMP（’25-08-2007 14：35：00’， ’DD-MM-YYYY HH24：MI：SS’）"The command fails displaying the following error：ORA-39001： invalid argument valueORA-39000： bad dump file specification ORA-31640： unable to open dump file "/home/oracle/schema/schemas.dat" for read ORA-27037： unable toobtain file status What would you do to overcome the error（）A、Add the user， SYSTEM， to the schemas option.B、Add the network_link = devdb.us.oracle.com option.C、Change the dumpfile option to schema.dat@devdb.us.oracle.com.D、Replace the schemas option with the network_link = devdb.us.oracle.comE、Replace the dumpfile option with the network_link = devdb.us.oracle.com
Your Certkiller .com database is in ARCHIVELOG mode. The data file that belongs to the SYSTEMtablespacehas become corrupted. Up to what point can you recover the database？（）A、Until last commitB、Until the time you perform recoveryC、Until the time the date file got corruptedD、Until the point where the last transaction begunE、You cannot recover the SYSTEMtablespaceand must re-create the database.
You performed an incomplete recovery on your Oracle Database 10g database using the following command： SQL RECOVER DATABASE 2 UNTIL TIME ’2004-08-05：12：10：03’ 3 USING BACKUP CONTROLFILE； In which situation would the above recovery be required？（）A、 A user table was lost at the specified time.B、 A redo log file was lost at the specified time.C、 The backup control file is on a faster disk than the current one.D、 The current control file has a different path compared with the intended time of recovery.E、 The current control file does not match the physical structure of the database at the intended time of recovery.
Your Supportcenter.cn database is in ARCHIVELOG mode. The data file that belongs to the SYSTEM tablespace has become corrupted. Up to what point can you recover the database？（）A、Until last commitB、Until the time you perform recoveryC、Until the time the date file got corruptedD、Until the point where the last transaction begunE、You cannot recover the SYSTEMtablespaceand must re-create the database.
查询出当前的数据库系统时间，精确到秒（）A、select to_date(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;B、select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;C、select date(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;D、select chr(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;
You need to restore your database back to 9/30/2008 at 18：00. In what order would you run the following commands to compete this task？（） a. restore controlfile until time `09/30/2008：18：00：00’ b. restore database until time `09/30/2008：18：00：00’ c. restore spfile until time `09/30/2008：18：00：00’ d. recover database until time `09/30/2008：18：00：00’ e. alter database open resetlogs f. alter database openA、 b， d， eB、 b， d， fC、 c， a， b， d， eD、 c， a， b， d， fE、 a， b， d， e
Using the command shown here， what time format must you specify to recover the database until a point-in-time？（） SQL RECOVER DATABASE UNTIL TIME ’’；A、YYYY-DD-MM:HH24:SS:MI B、YYYY-DD-MM:HH24:SS:MM C、YYYY-MM-DD:HH24:MI:SS D、YYYY-DD-MM:SS:MI:HH24
What will be the end result of this set of RMAN commands？（） shutdown abort startup mount restore datafile 4 until time ，，09/30/2008：15：00：00； recover datafile 4 until time ，，09/29/2008：15：00：00； alter database open resetlogs；A、 Datafile 4 will be recovered until 9/30/2008 at 15：00 and the database will open.B、 The restore command will fail.C、 The recover command will fail.D、 The alter database open resetlogs command will fail.E、 All these commands will fail because they must be in the confines of a run block.
You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode. At 06：00 p.m.， you discovered that a table in the SYSTEM tablespace that does not belong to the data dictionary was dropped at 03：00 p.m. What would you do to recover the table？（）A、 use the Flashback Transaction Query feature to identify the relevant SQL statement and use it to undrop the tableB、 restore the entire database from the most recent backup and open itC、 recover the table by using the Flashback Table featureD、 perform point-in-time recovery to recover the table
单选题You want to perform in incomplete recovery of your database. You plan to use these commands to recover your database： SET UNTIL TIME = ’2000-12-09：11：44：00’； RESTORE DATABASE； RECOVER DATABASE； How should the commands be executed？ （）AOnly the SET command must be within a RUN block.BAll commands should be executed at the RMAN prompt.CAll three commands must be within a single RUN block.DOnly the RESTORE and RECOVER commands must be within a single RUN block.
单选题You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode. At 06：00 p.m.， you discovered that a table in the SYSTEM tablespace that does not belong to the data dictionary was dropped at 03：00 p.m. What would you do to recover the table？（）A use the Flashback Transaction Query feature to identify the relevant SQL statement and use it to undrop the tableB restore the entire database from the most recent backup and open itC recover the table by using the Flashback Table featureD perform point-in-time recovery to recover the table
单选题Your Certkiller .com database is in ARCHIVELOG mode. The data file that belongs to the SYSTEMtablespacehas become corrupted. Up to what point can you recover the database？（）AUntil last commitBUntil the time you perform recoveryCUntil the time the date file got corruptedDUntil the point where the last transaction begunEYou cannot recover the SYSTEMtablespaceand must re-create the database.
单选题What will be the end result of this set of RMAN commands？（） shutdown abort startup mount restore datafile 4 until time ，，09/30/2008：15：00：00； recover datafile 4 until time ，，09/29/2008：15：00：00； alter database open resetlogs；A Datafile 4 will be recovered until 9/30/2008 at 15：00 and the database will open.B The restore command will fail.C The recover command will fail.D The alter database open resetlogs command will fail.E All these commands will fail because they must be in the confines of a run block.
单选题You want to import schema objects of the HR user using Oracle Data Pump from the development database，DEVDB， to the production database， PRODDB. A database link devdb.us.oracle.com is created betweenPRODDB and DEVDB. You execute the following command on the PRODDB database server：$ impdp system/manager directory = DB_DATAdumpfile = schemas.datschemas = hr flashback_time = "TO_TIMESTAMP（’25-08-2007 14：35：00’， ’DD-MM-YYYY HH24：MI：SS’）"The command fails displaying the following error：ORA-39001： invalid argument valueORA-39000： bad dump file specification ORA-31640： unable to open dump file "/home/oracle/schema/schemas.dat" for read ORA-27037： unable toobtain file status What would you do to overcome the error（）AAdd the user， SYSTEM， to the schemas option.BAdd the network_link = devdb.us.oracle.com option.CChange the dumpfile option to schema.dat@devdb.us.oracle.com.DReplace the schemas option with the network_link = devdb.us.oracle.comEReplace the dumpfile option with the network_link = devdb.us.oracle.com
单选题创建数据库实例时，需要修改日期格式为（）AYYYY-MM-DD HH24（）MI（）SSBMM-DD-YYYY HH24（）MI（）SSCDD-MM-YYYY HH24（）MI（）SSDMM-DD-YYYY HH（）MI（）SS
单选题You performed an incomplete recovery on your Oracle Database 10g database using the following command： SQL RECOVER DATABASE 2 UNTIL TIME ’2004/x7f08/x7f05：12：10：03’ 3 USING BACKUP CONTROLFILE; In which situation would the above recovery be required？（）AA user table was lost at the specified time.BA redo log file was lost at the specified time.CThe backup control file is on a faster disk than the current one.DThe current control file has a different path compared with the intended time of recovery.EThe current control file does not match the physical structure of the database at the intended time of recovery.
单选题Your Supportcenter.cn database is in ARCHIVELOG mode. The data file that belongs to the SYSTEM tablespace has become corrupted. Up to what point can you recover the database？（）AUntil last commitBUntil the time you perform recoveryCUntil the time the date file got corruptedDUntil the point where the last transaction begunEYou cannot recover the SYSTEMtablespaceand must re-create the database.
单选题You need to restore your database back to 9/30/2008 at 18：00. In what order would you run the following commands to compete this task？（） a. restore controlfile until time `09/30/2008：18：00：00’ b. restore database until time `09/30/2008：18：00：00’ c. restore spfile until time `09/30/2008：18：00：00’ d. recover database until time `09/30/2008：18：00：00’ e. alter database open resetlogs f. alter database openA b， d， eB b， d， fC c， a， b， d， eD c， a， b， d， fE a， b， d， e
单选题You performed an incomplete recovery on your Oracle Database 10g database using the following command： SQL RECOVER DATABASE 2 UNTIL TIME ’2004-08-05：12：10：03’ 3 USING BACKUP CONTROLFILE； In which situation would the above recovery be required？（）A A user table was lost at the specified time.B A redo log file was lost at the specified time.C The backup control file is on a faster disk than the current one.D The current control file has a different path compared with the intended time of recovery.E The current control file does not match the physical structure of the database at the intended time of recovery.
单选题查询出当前的数据库系统时间，精确到秒（）Aselect to_date(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;Bselect to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;Cselect date(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;Dselect chr(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;
单选题You want to import schema objects of the HR user using Oracle Data Pump from the development database，DEVDB， to the production database， PRODDB. A database link devdb.us.oracle.com is created betweenPRODDB and DEVDB. You execute the following command on the PRODDB database server：$ impdp system/manager directory = DB_DATAdumpfile = schemas.datschemas = hr flashback_time = "TO_TIMESTAMP（’25-08-2007 14：35：00’， ’DD-MM-YYYY HH24：MI：SS’）"The command fails displaying the following error：ORA-39001： invalid argument valueORA-39000： bad dump file specification ORA-31640： unable to open dump file "/home/oracle/schema/schemas.dat" for read ORA-27037： unable toobtain file status What would you do to overcome the error（）AAdd the user， SYSTEM， to the schemas option.BAdd the network_link = devdb.us.oracle.com option.CChange the dumpfile option to schema.dat@devdb.us.oracle.com.DReplace the schemas option with the network_link = devdb.us.oracle.comEReplace the dumpfile option with the network_link = devdb.us.oracle.com