You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?() A. Mount the database B. Open the database in NORMAL mode C. Open the database in RESTRICTED mode D. Open the database with the RESETLOGS option
举一反三
- The Database must be in this mode for the instance to be started:() A: MOUNT B: OPEN C: NOMOUNT D: None
- Tom issued a command to startup the database. What modes does the Instance and Database pass through to finally have the database open?() A: OPEN, NOMOUNT, MOUNT B: NOMOUNT, MOUNT, OPEN C: NOMOUNT, OPEN, MOUNT D: MOUNT, OPEN, NOMOUNT
- Which of the following is a prerequisite for running DBMS_TDB.CHECK_DB to a successful completion?() A: The database must be in read-write mode. B: The database must have no external files. C: The database must open in read-only mode. D: The database must be mounted but not opened.
- 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 open A: b, d, e B: b, d, f C: c, a, b, d, e D: c, a, b, d, f E: a, b, d, e
- (19)打开数据库abc的正确命令是 A) OPEN DATABASE abc B)USE abc C) USE DATABASE abc D) OPEN abc