单选题Which command is used to open the database after an incomplete recovery?()A  alter database openB  alter database open repairlogC  alter database open resetlogsD  alter database open resetlogE  alter database resetlogs open

题目
单选题
Which command is used to open the database after an incomplete recovery?()
A

 alter database open

B

 alter database open repairlog

C

 alter database open resetlogs

D

 alter database open resetlog

E

 alter database resetlogs open

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database?()

  • A、’SQL ALTER DATABASE OPEN’;
  • B、SQL ALTER DATABASE ’OPEN’;
  • C、OPEN DATABASE;
  • D、DATABASE OPEN

正确答案:C

第2题:

After performing a clean shut down of the database instance for maintenance, you mount the database andthen execute a command to open the database:SQL> ALTER DATABASE OPEN; Which two statements are true()

  • A、The online redo log files and online data files are opened.
  • B、All the online data file headers are checked for consistency.
  • C、Instance recovery is performed before opening the database.
  • D、The path and existence of all the log file members are checked

正确答案:A,B

第3题:

Upon starting your database, you receive the following error:You can choose from the following steps:1.Restore the database datafiles.2.Issue the alter database clear unarchived logfile group 1 command.3.Issue the alter database open command.4.Issue the alter database open resetlogs command.5.Recover the database using point-in-time recovery.6.Issue the Startup Mount command to mount the database.7.Back up the database.Which is the correct order of these steps in this case?()

A. 1,6,5,4,7

B. 6,5,4

C. 6,2,3,7

D. 1,6,3

E. The database cannot be recovered


参考答案:C

第4题:

Which of the following commands cannot be executed when the database open?()

  • A、RECOVER DATABASE
  • B、RECOVER TABLESPACE
  • C、RECOVER DATAFILE
  • D、ALTER DATABASE RECOVER DATAFILE

正确答案:B

第5题:

After performing a clean shut down of the database instance for maintenance, you mount thedatabase and then execute a command to open the database: SQL> ALTER DATABASE OPEN;  Which two statements are true()

  • A、The online redo log files and online data files are opened.
  • B、All the online data file headers are checked for consistency.
  • C、Instance recovery is performed before opening the database.
  • D、The path and existence of all the log file members are checked

正确答案:A,B

第6题:

Which command is used to open the database after an incomplete recovery?()

  • A、 alter database open
  • B、 alter database open repairlog
  • C、 alter database open resetlogs
  • D、 alter database open resetlog
  • E、 alter database resetlogs open

正确答案:C

第7题:

You have lost all your SYSTEM tablespace datafiles (system_01.dbf and system_02.dbf) nd the database has crashed.  What would be the appropriate order of operations to correct the situation?()   a. Mount the database with the startup mount command.  b. Take the SYSTEM datafile offline with the alter database command.  c. Restore the SYSTEM_01.dbf datafile from backup media with the required archived redo logs.  d. Restore all SYSTEM tablespace-related datafiles from backup media. e. Issue the recover tablespace SYSTEM command.  f. Issue the recover datafile SYSTEM_01.dbf command.  g. Open the database with the alter database open command.  h. Open the database with the alter database open resetlogs command.

  • A、a, c, f, g
  • B、b, d, e, h
  • C、a, b, c, f, g
  • D、d, a, e, g
  • E、b, c, f, e, g

正确答案:D

第8题:

If a log file becomes corrupted, it may cause the database to stall. How would you correct such a situation?()  

  • A、 Recover the online redo log from backup.
  • B、 Delete and re-create the log file.
  • C、 Use the alter database clear logfile command to clear the log file.
  • D、 Shut down the database and restart it.
  • E、 Shut down the database and then mount it. Clear the log file with the alter database clear logfile command and then restart the database with alter database open resetlogs.

正确答案:C

第9题:

Which of the following represents the correct way to perform an online recovery of datafile 4, which is assigned to a tablespace called USERS?()  

  • A、 shutdown restore datafile 4; recover datafile 4; alter database open;
  • B、 Sql alter database datafile 4 offline; restore datafile 4; recover datafile 4; alter database open;
  • C、 Sql alter database datafile 4 offline; restore datafile 4; Sql alter database datafile 4 online;
  • D、 Sql alter database datafile 4 offline; restore database datafile 4; recover database datafile 4;Sql alter database datafile 4 online;
  • E、 Sql alter database datafile 4 offline; restore datafile 4; recover datafile 4; Sql alter database datafile 4 online;

正确答案:E

第10题:

After the recovery is complete, which command should you execute?()

  • A、ALTER DATABASE OPEN;
  • B、ALTER DATABASE CLEAR LOGFILE;
  • C、ALTER DATABASE OPEN RESETLOGS;
  • D、ALTER DATABASE OPEN NORESETLOGS;

正确答案:C

更多相关问题