单选题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.

题目
单选题
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

相似考题

1.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,7B. 6,5,4C. 6,2,3,7D. 1,6,3E. The database cannot be recovered

2.At database startup， you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes？（）A、 Start the database in OPEN mode， and create a new index tablespace.B、 Start the database in OPEN mode， and drop the lost index tablespace from the database.C、Start the database in MOUNT mode， create a new index tablespace， and drop the lost index tablespace from the database.D、 Start the database in MOUNT mode， drop the lost index tablespace from the database， open the database， and create a new index tablespace.

3.A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message . Which is the recommended sequence of operations you need to perform for the query successfully?（）A、Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace. B、Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online. C、Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.D、Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode. 

4.A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message:Which is the recommended sequence of operations you need to perform for the query successfully?（）A. Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace.B. Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online.C. Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.D. Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode.

更多“单选题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.”相关问题

  • 第1题：

    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， f
    • B、c， a， e， b， d， f， g
    • C、c， e， d， g
    • D、b， d， f 
    • E、e， d， g

    正确答案:A

  • 第2题：

    For which database operation would you need the database to be in the MOUNT state（）

    • A、renaming the control files
    • B、re-creating the control files
    • C、dropping a user in your database
    • D、dropping a tablespace in your database
    • E、configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes

    正确答案:E

  • 第3题：

    You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）

    • A、renaming the control files
    • B、dropping a user in your database
    • C、enabling or disabling redo log archiving
    • D、dropping a tablespace in your database
    • E、re-creating the control files， after you lost all the control files in your database

    正确答案:C

  • 第4题：

    You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）

    • A、Restore all the data files and open the database
    • B、Create the data file and perform tablespace recovery
    • C、No need to restore any file， just recover the database
    • D、Restore only the system data file and recover the database
    • E、Restore only lost date file and performtablespacerecovery

    正确答案:A

  • 第5题：

    Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation？（）

    • A、Shut down the database, restore the two data files and then start up the database. 
    • B、Take the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. 
    • C、Shut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open. 
    • D、Take the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.

    正确答案:C

  • 第6题：

    单选题
    For which database operation would you need the database to be in the MOUNT state（）
    A

    renaming the control files

    B

    re-creating the control files

    C

    dropping a user in your database

    D

    dropping a tablespace in your database

    E

    configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes


    正确答案： C
    解析： 暂无解析

  • 第7题：

    单选题
    A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message . Which is the recommended sequence of operations you need to perform for the query successfully?（）
    A

    Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace. 

    B

    Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online. 

    C

    Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.

    D

    Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode. 


    正确答案： B
    解析： 暂无解析

  • 第8题：

    单选题
    Your database is configured in NOARCHIVELOG mode. Due to a media failure， you have lost one of the datafiles belonging to a read-only tablespace. You know that the last backup was performed after the tablespace was made read-only. Which action should you take to restore the missing datafile in the minimum amount of time？（）
    A

     Restore all the datafiles from the backup.

    B

     Restore only the lost datafile from the backup.

    C

     Restore all the datafiles for the lost tablespace from the backup.

    D

     Restore all the datafiles for the lost tablespace and all the SYSTEM and SYSAUX datafiles from the backup.


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    Upon starting your database， you receive the following error：   SQL> startup ORACLE instance started.  Total System Global Area 171581440 bytes Fixed Size 1298640 bytes Variable Size 146804528 bytes Database Buffers 20971520 bytes Redo Buffers 2506752 bytes Database mounted.  ORA-00313： open failed for members of log group 1 of thread 1  ORA-00312： online log 1 thread 1： ’/oracle01/oradata/orcl/redo01.log’ ORA-00312： online log 1 thread 1： ’/oracle01/oradata/orcl/redo01a.log’   You can choose from the following steps：   a. Restore the database datafiles.  b. Issue the alter database clear unarchived logfile group 1 command. c. Issue the alter database open command.  d. Issue the alter database open resetlogs command.  e. Recover the database using point-in-time recovery. f. Issue the Startup Mount command to mount the database.  g. Back up the database.  Which is the correct order of these steps in this case？（）
    A

    a， f， e， d， g

    B

    f， e， d

    C

    f， b， c， g

    D

    a， f， c

    E

    The database cannot be recovered.


    正确答案： C
    解析： 暂无解析

  • 第10题：

    单选题
    Which are the correct steps， in order， to deal with the loss of an online redo log if the database has not yet crashed？（）   a. Issue a checkpoint.  b. Shut down the database.  c. Issue an alter database open command to open the database.  d. Startup mount the database.  e. Issue an alter database clear logfile command.  f. Recover all database datafiles.
    A

    a， b， c， d

    B

    b， d， e， c

    C

    a， b， d， e， c

    D

    b， f， d， f， c

    E

    b， d， a， c


    正确答案： D
    解析： 暂无解析

  • 第11题：

    单选题
    You have joined a new organization as a Database Administrator. The Security Administrator in your organization has kept human errors， such as erroneously dropping users， tables， and important data， to a minimum by carefully granting only the necessary privileges to each user. As a result of several ongoing transactions within your database， you discover that the flashback logs are rapidly increasing in the flash recovery area. To avoid out-of-space errors， you decide to delete the flashback logs from the flash recovery area. How can you delete the flashback logs from the database if your database is up and running？（）
    A

     Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.

    B

     Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement while the database is up and running.

    C

     Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.

    D

     Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    Assume your situation can be described as follows： x A full backup taken using RMAN is available on disk.  x The current control files were NOT damaged and do not need to be restored.  x All data files are damaged or lost.  x The database is in NOARCHIVELOG mode.  Which RMAN command would be most appropriate to use in line 3 of the following RMAN command set to restore and fully recover your database？（） 1. RMAN> STARTUP MOUNT  2. RMAN> RESTORE DATABASE;  3. RMAN> （）  4. RMAN> ALTER DATABASE OPEN;
    A

    RECOVER DATABASE；

    B

    SWITCH DATAFILE ALL；

    C

    RESTORE CONTROL FILE；

    D

    RECOVER DATABASE USING BACKUP CONTROL FILE；


    正确答案： B
    解析： 暂无解析

  • 第13题：

    You have joined a new organization as a Database Administrator. The Security Administrator in your organization has kept human errors， such as erroneously dropping users， tables， and important data， to a minimum by carefully granting only the necessary privileges to each user. As a result of several ongoing transactions within your database， you discover that the flashback logs are rapidly increasing in the flash recovery area. To avoid out-of-space errors， you decide to delete the flashback logs from the flash recovery area. How can you delete the flashback logs from the database if your database is up and running？（）

    • A、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
    • B、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement while the database is up and running.
    • C、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
    • D、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.

    正确答案:A

  • 第14题：

    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

  • 第15题：

    Which are the correct steps， in order， to deal with the loss of an online redo log if the database has not yet crashed？（）   a. Issue a checkpoint.  b. Shut down the database.  c. Issue an alter database open command to open the database.  d. Startup mount the database.  e. Issue an alter database clear logfile command.  f. Recover all database datafiles.

    • A、a， b， c， d
    • B、b， d， e， c
    • C、a， b， d， e， c
    • D、b， f， d， f， c
    • E、b， d， a， c

    正确答案:C

  • 第16题：

    Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to the SYSTEM tablespace and two are assigned to the USERS tablespace. You can choose from the following steps to recover your database：   a. Restore the three database datafiles that were lost.  b. Issue the Startup Mount command to mount the database.  c. Issue the alter database open command.  d. Issue the alter database open resetlogs command.  e. Recover the database using the recover database command. f. Recover the datafiles with the recover datafile command.  g. Take the datafiles offline.  Which is the correct order of these steps in this case？（）

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

    正确答案:A

  • 第17题：

    单选题
    Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation？（）
    A

    Shut down the database, restore the two data files and then start up the database. 

    B

    Take the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. 

    C

    Shut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open. 

    D

    Take the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.


    正确答案： B
    解析： 暂无解析

  • 第18题：

    单选题
    At database startup， you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes？（）
    A

     Start the database in OPEN mode， and create a new index tablespace.

    B

     Start the database in OPEN mode， and drop the lost index tablespace from the database.

    C

    Start the database in MOUNT mode， create a new index tablespace， and drop the lost index tablespace from the database.

    D

     Start the database in MOUNT mode， drop the lost index tablespace from the database， open the database， and create a new index tablespace.


    正确答案： A
    解析： 暂无解析

  • 第19题：

    单选题
    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， f

    B

    c， a， e， b， d， f， g

    C

    c， e， d， g

    D

    b， d， f 

    E

    e， d， g


    正确答案： E
    解析： 暂无解析

  • 第20题：

    单选题
    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


    正确答案： A
    解析： 暂无解析

  • 第21题：

    单选题
    You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）
    A

    Restore all the data files and open the database

    B

    Create the data file and perform tablespace recovery

    C

    No need to restore any file， just recover the database

    D

    Restore only the system data file and recover the database

    E

    Restore only lost date file and performtablespacerecovery


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）
    A

    renaming the control files

    B

    dropping a user in your database

    C

    enabling or disabling redo log archiving

    D

    dropping a tablespace in your database

    E

    re-creating the control files， after you lost all the control files in your database


    正确答案： C
    解析： 暂无解析

  • 第23题：

    单选题
    You have lost datafiles 1 and 3 from your database，and the database has crashed.  In what order should you perform the following steps to recover your database？（） 1. Take the datafiles that were lost offline.  2. startup mount the database  3. Issue the alter database open command. 4. Restore the datafiles that were lost  5. Recover the datafiles with the recover datafile command. 6. Bring the datafiles back online.  7. Recover the database with the recover database command.
    A

     2，1，3，4，5，6

    B

     2，4，5，3

    C

     4，7，3

    D

     2，4，7，3

    E

     2，7，3


    正确答案： E
    解析： 暂无解析

  • 第24题：

    单选题
    Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to the SYSTEM tablespace and two are assigned to the USERS tablespace. You can choose from the following steps to recover your database：   a. Restore the three database datafiles that were lost.  b. Issue the Startup Mount command to mount the database.  c. Issue the alter database open command.  d. Issue the alter database open resetlogs command.  e. Recover the database using the recover database command. f. Recover the datafiles with the recover datafile command.  g. Take the datafiles offline.  Which is the correct order of these steps in this case？（）
    A

    a， b， e， c

    B

    b， e， d

    C

    a， b， d， c

    D

    b， g， c， f

    E

    a， b， d， f


    正确答案： D
    解析： 暂无解析

相关内容