itgle.com

单选题What is the correct order of steps to perform an online database backup？（）   a. alter database begin backup b. alter database end backup c. Back up the database datafiles d. Back up the archive log files e. alter system switch logfileA a， b， c， d， eB e

题目
单选题
What is the correct order of steps to perform an online database backup？（）   a. alter database begin backup b. alter database end backup c. Back up the database datafiles d. Back up the archive log files e. alter system switch logfile
A

a， b， c， d， e

B

e， d， a， b， c

C

a， c， b， d， e

D

d， b， c， a， e

E

a， c， b， e， d

相似考题

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. Consider the recovery steps in each of the cases given below：  Case 1：  Shut down the database and perform a backup.  Restore all the data files.  Mount the database.  Recover the database.  Without applying all the redo log files， open the database using the RESETLOGS option.  Back up the database.  Case 2：  Shut down the database and perform a backup.  Restore only the data files of the tablespace where user error damaged the data.  Mount the database.  Recover the database.  Open the database with the RESETLOGS option.  Back up the database.  Case 3： Shut down the database  Restore the data files  Open the database  Perform recovery to the current point in time.  Which case has the correct steps for an incomplete recovery？（）A、only case 1B、only case 2C、only case 3D、case 1 and 2E、case 2 and 3F、case 1 and 3G、all cases： case 1， case 2 and case 3

3.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.

4. You executed the following command to perform a backup of the USERS tablespace：  SQL> ALTER TABLESPACE users BEGIN BACKUP； ALTER TABLESPACE users BEGIN BACKUP *  ERROR at line 1：  ORA-01123： cannot start online backup； media recovery not enabled  What could be the reason for this error（）A、The MTTR Advisor is disabled.B、The database is in NOARCHIVELOG mode.C、The tablespace is already in backup mode.D、The Flash Recovery Area is not configured.

参考答案和解析
正确答案： E
解析： 暂无解析
更多“单选题What is the correct order of steps to perform an online database backup？（）   a. alter database begin backup b. alter database end backup c. Back up the database datafiles d. Back up the archive log files e. alter system switch logfileA a， b， c， d， eB e”相关问题

  • 第1题：

    You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode.  Which two options do you have for performing user-managed backups（）

    • A、You can perform consistent backups only.
    • B、You can perform a complete database backup without shutting down the database instance.
    • C、You can back up data files only when all data files have the same SCN recorded in the control file.
    • D、You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.

    正确答案:B,D

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    Which is the correct command to back up the database， back up the archived redo logs， and then remove the backed-up archived redo logs？（）  

    • A、 backup database
    • B、 backup database and archivelogs
    • C、 backup database plus archivelogs
    • D、 backup database plus archivelog delete input
    • E、 backup database and archivelog delete input

    正确答案:D

  • 第5题：

    单选题
    Which is the correct command to back up the database， back up the archived redo logs， and then remove the backed-up archived redo logs？（）
    A

     backup database

    B

     backup database and archivelogs

    C

     backup database plus archivelogs

    D

     backup database plus archivelog delete input

    E

     backup database and archivelog delete input


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

  • 第6题：

    多选题
    You are working on a database that must be functioning 24 hours a day， 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）
    A

    You can perform consistent backups only.

    B

    You can perform a complete database backup without shutting down the database instance.

    C

    You can back up data files only when all data files have the same SCN recorded in the control file.

    D

    You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands


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

  • 第7题：

    单选题
    Which command will result in a trace file being created with the create controlfile command contained in it？（）
    A

     alter database backup controlfile

    B

     alter database backup controlfile to trace

    C

     alter database controlfile backup

    D

     alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’

    E

     alter database begin controlfile backup


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

  • 第8题：

    单选题
    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
    解析： 暂无解析

  • 第9题：

    单选题
    What is the correct order of steps to perform an online database backup？（）   a. alter database begin backup b. alter database end backup c. Back up the database datafiles d. Back up the archive log files e. alter system switch logfile
    A

    a， b， c， d， e

    B

    e， d， a， b， c

    C

    a， c， b， d， e

    D

    d， b， c， a， e

    E

    a， c， b， e， d


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

  • 第10题：

    多选题
    You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode.  Which two options do you have for performing user-managed backups（）
    A

    You can perform consistent backups only.

    B

    You can perform a complete database backup without shutting down the database instance.

    C

    You can back up data files only when all data files have the same SCN recorded in the control file.

    D

    You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.


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

  • 第11题：

    单选题
    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
    解析： 暂无解析

  • 第12题：

    单选题
    You want to migrate your database to ASM， so you have done a clean shutdown， made a closed backup of the entire You wa database， noted the location of your control files and online redo log files， and changed your spfile to use OMF. The last step is to run an RMAN script to do the conversion.  Using the following steps，what is the correct order in which the following RMAN commands should be executed？（）   1. STARTUP NOMOUNT  2. ALTER DATABASE OPEN RESETLOGS  3. SQL "ALTER DATABASE RENAME ，，logfile1 path TO ，，+dgrp4 ，，" # plus all other logfiles  4. SWITCH DATABASE TO COPY  5. BACKUP AS COPY DATABASE FORMAT ，，+dgrp4 6. ALTER DATABASE MOUNT  7. RESTORE CONTROLFILE FROM ，，controlfile_location
    A

     2， 5， 3， 1， 7， 6， 4

    B

     1， 7， 6， 5， 4， 3， 2

    C

     5， 1， 2， 7， 4， 6， 3

    D

     7， 3， 1， 5， 6， 2， 4


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

  • 第13题：

    Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（）  

    • A、 Put the database in hot backup mode and perform an online backup，including backing up the  archived redo logs.
    • B、 Just back up the database datafiles without shutting down the database.
    • C、 You will have to wait until you can shut down the database to perform the backup.
    • D、 Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.
    • E、 Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the  course of the remaining backup

    正确答案:C

  • 第14题：

    When performing an online backup，what is the proper order of the following steps？（）   a. Issue the alter database end backup command. b. Back up the archived redo logs. c. Issue the alter database begin backup command.  d. Back up the database files.  e. Determine the beginning log sequence number. f. Determine the ending log sequence number.  g. Force a log switch with the alter system switch logfile command.

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

    正确答案:D

  • 第15题：

    Which command will result in a trace file being created with the create controlfile command contained in it？（）  

    • A、 alter database backup controlfile
    • B、 alter database backup controlfile to trace
    • C、 alter database controlfile backup
    • D、 alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’
    • E、 alter database begin controlfile backup

    正确答案:B

  • 第16题：

    What is the correct order of steps to perform an online database backup？（）   a. alter database begin backup b. alter database end backup c. Back up the database datafiles d. Back up the archive log files e. alter system switch logfile

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

    正确答案:E

  • 第17题：

    单选题
    When performing an online backup，what is the proper order of the following steps？（）   a. Issue the alter database end backup command. b. Back up the archived redo logs. c. Issue the alter database begin backup command.  d. Back up the database files.  e. Determine the beginning log sequence number. f. Determine the ending log sequence number.  g. Force a log switch with the alter system switch logfile command.
    A

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

    B

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

    C

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

    D

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

    E

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


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

  • 第18题：

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


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

  • 第19题：

    单选题
    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
    解析： 暂无解析

  • 第20题：

    单选题
    Consider the recovery steps in each of the cases given below：  Case 1：  Shut down the database and perform a backup.  Restore all the data files.  Mount the database.  Recover the database.  Without applying all the redo log files， open the database using the RESETLOGS option.  Back up the database.  Case 2：  Shut down the database and perform a backup.  Restore only the data files of the tablespace where user error damaged the data.  Mount the database.  Recover the database.  Open the database with the RESETLOGS option.  Back up the database.  Case 3： Shut down the database  Restore the data files  Open the database  Perform recovery to the current point in time.  Which case has the correct steps for an incomplete recovery？（）
    A

    only case 1

    B

    only case 2

    C

    only case 3

    D

    case 1 and 2

    E

    case 2 and 3

    F

    case 1 and 3

    G

    all cases： case 1， case 2 and case 3


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

  • 第21题：

    单选题
    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
    解析： 暂无解析

  • 第22题：

    单选题
    When performing an online backup，what is the proper order of the following steps？（）   a. Issue the alter database end backup command. b. Back up the archived redo logs. c. Issue the alter database begin backup command.  d. Back up the database files.  e. Determine the beginning log sequence number. f. Determine the ending log sequence number.  g. Force a log switch with the alter system switch logfile command.
    A

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

    B

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

    C

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

    D

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

    E

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


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

  • 第23题：

    单选题
    What is the correct order of steps to perform an online database backup？（）   a. alter database begin backup b. alter database end backup c. Back up the database datafiles d. Back up the archive log files e. alter system switch logfile
    A

    a， b， c， d， e

    B

    e， d， a， b， c

    C

    a， c， b， d， e

    D

    d， b， c， a， e

    E

    a， c， b， e， d


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

  • 第24题：

    单选题
    Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（）
    A

     Put the database in hot backup mode and perform an online backup，including backing up the  archived redo logs.

    B

     Just back up the database datafiles without shutting down the database.

    C

     You will have to wait until you can shut down the database to perform the backup.

    D

     Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.

    E

     Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the  course of the remaining backup


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

相关内容