niusouti.com

多选题Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available.  Which three files would be

题目
多选题
Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available.  Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（）
A

redo logs

B

control file

C

temporary files of temporary tablespace

D

the latest backup of only the damaged data file

E

the latest backup of all the data files In the USERS tablespace

相似考题

1.Your database is running in ARCHIVELOG mode. One of the data files,USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?（）A. Redo logsB. Control fileC. The latest backup of only the damaged data fileD. The latest backup of all the data file in the USERS tablespaceE. Temporary files of temporary tablespaceF. Archive Logs since the latest backup to point of failure

2. You work as a database administrator for Certkiller .com. You received the following error while working on your database： ORA-01555： snapshot too old  In which situation would you receive such an error？（）A、You performed rollback after commit.B、If a log switch occurs in your database.C、Thearchiverfails to generate an archived log file.D、Instance recovery fails to find one of the redo log files.E、A long-running query is unable to get read-consistent image.F、If you perform manual undo management operations in auto mode.

3. Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command：   RESTORE CONTROLFILE FROM AUTOBACKUP；   Which of the following statements is true？（） A、 The command restores only the missing control file.B、 The command restores all the control files.C、 The command fails because the database is running.D、 This is the correct way to address this problem.E、 This is not the correct way to address this problem.

4.You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode. Which two statements are correct in this scenario？ （）A、 The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.B、 The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.C、 Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.D、 The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.

更多“Your database is running In ARCIIIVELOG mode. One of the dat”相关问题

  • 第1题：

    Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）

    • A、The database is in mount state.
    • B、One of the tablespaces is offline.
    • C、One of the tablespaces is read only.
    • D、The database operates in ARCHIEVELOG mode. 
    • E、The database operates in NOARCHIEVELOG mode.

    正确答案:E

  • 第2题：

    Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available.  Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（） 

    • A、 redo logs
    • B、 control file
    • C、 temporary files of temporary tablespace
    • D、 the latest backup of only the damaged data file
    • E、 the latest backup of all the data files In the USERS tablespace

    正确答案:A,B,D

  • 第3题：

    Your database is in ARCHIVELOG mode. You have two online redo log groups，each of which contains one redo member.  When you attempt to start the database， you receive the following errors：（）

    • A、 ALTER DATABASE DROP LOGFILE GROUP 1
    • B、 ALTER DATABASE CLEAR LOGFILE GROUP 1
    • C、 ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1
    • D、 ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’

    正确答案:C

  • 第4题：

    Your boss at Certkiller .com wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）

    • A、The database is in mount state.
    • B、One of the tablespaces is offline.
    • C、One of the tablespaces is read only.
    • D、The database operates in ARCHIEVELOG mode.
    • E、The database operates in NOARCHIEVELOG mode.

    正确答案:E

  • 第5题：

    多选题
    In order to perform Flashback Transaction Query operations， which of these steps are required？（）
    A

    Ensure that database is running with version 10.1 compatibility.

    B

    Enable Flashback Logging.

    C

    Enable Supplemental Logging.

    D

    Ensure that the database is running with version 10.0 compatibility.

    E

    Ensure that the database is in ARCHIVELOG mode.


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

  • 第6题：

    单选题
    Your test database is running in NOARCHIVELOG mode. What are the implications of this？ （）
    A

    You can perform open database backups.

    B

    You can perform closed database backups.

    C

    You cannot perform schema-level logical backups.

    D

    You can perform the backup of only the SYSTEM tablespace when the database is open.


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

  • 第7题：

    单选题
    The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. Oneof the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?（）
    A

    You should perform a log switch

    B

    You should make a backup of the database

    C

    You should switch the database to the NONARCHIVELOG mode

    D

    You should shut down the database instance and perform a complete database recovery


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

  • 第8题：

    单选题
    Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）
    A

    You can perform online whole database backups.

    B

    You can performofflinewhole database backups.

    C

    You cannot perform schema-level export/import operations.

    D

    You can perform the backup of only the SYSTEM tablespace when the database is open.


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

  • 第9题：

    多选题
    Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator （）(DBA)? (Choose Three)
    A

    Redo logs

    B

    Control file

    C

    The latest backup of only the damaged data file

    D

    The latest backup of all the data file in the USERS tablespace

    E

    Temporary files of temporary tablespace

    F

    Archive Logs since the latest backup to point of failure


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

  • 第10题：

    多选题
    You work as a database administrator for Certkiller .com. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode.  How would you do this？（）
    A

    Execute the ALTER DATABASE ARCHIVELOG statement

    B

    Select ARCHIVELOG option in the database control and restart the database to apply the changes.

    C

    Shut down and start the instance, and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.

    D

    Shut down and start the instance, mount the database, then execute the ALTER DATABASE ARCHIVELOG statement.


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

  • 第11题：

    单选题
    You work as a database administrator for Supportcenter.cn. You received the following error while working on your database： ORA-01555： snapshot too old ，In which situation would you receive such an error？（）
    A

    You performed rollback after commit.

    B

    If a log switch occurs in your database.

    C

    Thearchiverfails to generate an archived log file.

    D

    Instance recovery fails to find one of the redo log files.

    E

    A long-running query is unable to get read-consistent image.

    F

    If you perform manual undo management operations in auto mode.


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

  • 第12题：

    单选题
    The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file：   ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3；   Which action should you perform immediately after using this command？（）
    A

     You should perform a log switch

    B

     You should make a backup of the database

    C

     You should switch the database to the NONARCHIVELOG mode

    D

     You should shut down the database instance and perform a complete database recovery


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

  • 第13题：

    In order to perform Flashback Transaction Query operations， which of these steps are required？（）

    • A、 Ensure that database is running with version 10.1 compatibility.
    • B、 Enable Flashback Logging.
    • C、 Enable Supplemental Logging.
    • D、 Ensure that the database is running with version 10.0 compatibility.
    • E、 Ensure that the database is in ARCHIVELOG mode.

    正确答案:C,D

  • 第14题：

    The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）

    • A、 Enable flashback logging.
    • B、 Start the database in the ARCHIVELOG mode.
    • C、 Issue the ALTER DATABASE FLASHBACK ON； command.
    • D、 Set the FAST_START_MTTR_TARGET initialization parameter.

    正确答案:A

  • 第15题：

    You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8：00 P.M. Your database is running in ARCHIVELOG mode. On Monday， at 9：00 A.M.， a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace.  Which two clauses can you use with the RECOVER command？（）

    • A、 UNTIL SEQUENCE
    • B、 UNTIL SCN
    • C、 UNTIL CHANGE
    • D、 UNTIL CANCEL

    正确答案:C,D

  • 第16题：

    多选题
    Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command：   RESTORE CONTROLFILE FROM AUTOBACKUP；   Which of the following statements is true？（）
    A

    The command restores only the missing control file.

    B

    The command restores all the control files.

    C

    The command fails because the database is running.

    D

    This is the correct way to address this problem.

    E

    This is not the correct way to address this problem.


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

  • 第17题：

    单选题
    Your database is in ARCHIVELOG mode. You have two online redo log groups，each of which contains one redo member.  When you attempt to start the database， you receive the following errors：（）
    A

     ALTER DATABASE DROP LOGFILE GROUP 1

    B

     ALTER DATABASE CLEAR LOGFILE GROUP 1

    C

     ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1

    D

     ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’


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

  • 第18题：

    单选题
    The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each.One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file: ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?（）
    A

    You should perform a log switch

    B

    You should make a backup of the database

    C

    You should switch the database to the NONARCHIVELOG mode

    D

    You should shut down the database instance and perform a complete database recovery


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

  • 第19题：

    多选题
    Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true？（）
    A

    The destination must be global only.

    B

    A maximum of five destinations can be assigned.

    C

    A maximum of ten different destinations can be assigned.

    D

    All the destinations are determined by the server automatically.

    E

    The destination may be local or remote for a Standby Database.

    F

    The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.


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

  • 第20题：

    多选题
    Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available.  Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（）
    A

    redo logs

    B

    control file

    C

    temporary files of temporary tablespace

    D

    the latest backup of only the damaged data file

    E

    the latest backup of all the data files In the USERS tablespace


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

  • 第21题：

    单选题
    Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）
    A

    The database is in mount state.

    B

    One of the tablespaces is offline.

    C

    One of the tablespaces is read only.

    D

    The database operates in ARCHIEVELOG mode. 

    E

    The database operates in NOARCHIEVELOG mode.


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

  • 第22题：

    多选题
    Your database is running in ARCHIVELOG mode. One of the data files， USERDATA01.dbf， in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available.  Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（）
    A

    Redo logs

    B

    Control file

    C

    The latest backup of only the damaged data file

    D

    The latest backup of all the data file in the USERS tablespace

    E

    Temporary files of temporary tablespace

    F

    Archive Logs since the latest backup to point of failure


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

  • 第23题：

    多选题
    You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode.   Which two statements are correct in this scenario？（）
    A

    The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.

    B

    The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.

    C

    Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA  memory management.

    D

    The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA  memory management mode.


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

  • 第24题：

    单选题
    You work as a database administrator for Certkiller .com. 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 performtablespacerecovery

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

相关内容