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

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

相似考题

1.You are managing a 24*7 database. The backup strategy for the database is to perform user－managedbackups.Identify two prerequisites to perform the backups. (Choose two.)()A. The database must be opened in restricted mode.B. The database must be configured to run in ARCHIVELOG mode.C. The tablespaces are required to be in backup mode before taking the backup.D. The tablespaces are required to be in read-only mode before taking the backup

2.Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the contents of the V$PARAMETER view is true？（）A、Displays only the list of default valuesB、Displays only the list of all basic parametersC、Displays the currently in effect parameter valuesD、Displays only the list of all advanced parametersE、Displays the list of all the parameter files of a databaseF、Displays the current contents of the server parameter file.

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

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

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

  • 第1题：

    You work as a database administrator for Certkiller .com. You are using Recovery Manager （RMAN） to perform backups in your databases.  Which four backup operations can be performed using RMAN？（）

    • A、A backup of the target database when it is mounted
    • B、A backup of online redo log files when the database is open
    • C、A backup of only used data blocks in the file beingbeingbackup up
    • D、A backup of online， read/write data files when the database is open
    • E、A backup of only those data blocks that have changed since a previous backup
    • F、A backup of online， read/write data files when the database is in the NOMOUNT state.

    正确答案:A,C,D,E

  • 第2题：

    Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？（）

    • A、 open the database with the RESTRICTED option
    • B、 open the database with the RESETLOGS option
    • C、 recover to the required SCN only that data file in which the error occurred
    • D、 recover all the data files to the same system change number （SCN）

    正确答案:B,D

  • 第3题：

    While planning to manage more than one database in your system， you perform the following activities：  1. Organize different categories of files into independent subdirectories.  2. Use consistent naming convention for database files.  3. Separate administrative information pertaining to each database.  Which option corresponds to the type of activities performed by you？（）

    • A、Oracle Managed Files
    • B、Oracle Grid Architecture
    • C、Optimal Flexible Architecture
    • D、Oracle database architecture

    正确答案:C

  • 第4题：

    Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups. Which two backups would you be able to perform when the database is being accessed by users？（）

    • A、 Backup of offline tablespaces.
    • B、 Backup of read-only tablespaces.
    • C、 Backup of system-critical tablespaces.
    • D、 Backup of online， locally managed tablespaces.
    • E、 Backup of read/write dictionary-managed tablespaces.

    正确答案:A,B

  • 第5题：

    One of the tablespaces is read/x7fonly in your database. The loss of all control files forced you to re/x7fcreate the control file.  Which operation do you need to perform after re/x7fcreating the control file and opening the database？（）

    • A、drop and re­create the read­only tablespaces
    • B、rename the read­only data files to their correct file names
    • C、change the tablespace status from read/write to read­only
    • D、re­create the read­only tablespace because it is automatically removed

    正确答案:B

  • 第6题：

    You work as a database administrator for Certkiller .com. In your organization， you have four databases， Certkiller DB01， Certkiller DB02， Certkiller DB03， and Certkiller DB04， which are located in Berlin， Frankfurt，Rammstein， and Munich respectively， and which were created using Database Configuration Assistant （DBCA）.  You want to perform administrative tasks on these databases that include startup and shutdown， taking regular backups， and so on， fromFrankfurtusing Oracle tools. Which Oracle file would you enable to perform this task？（）

    • A、Control file
    • B、Password file
    • C、Parameter file
    • D、Online redo log file
    • E、Listener controller file
    • F、Server parameter file

    正确答案:B

  • 第7题：

    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

  • 第8题：

    单选题
    One of the tablespaces is read/x7fonly in your database. The loss of all control files forced you to re/x7fcreate the control file.  Which operation do you need to perform after re/x7fcreating the control file and opening the database？（）
    A

    drop and re­create the read­only tablespaces

    B

    rename the read­only data files to their correct file names

    C

    change the tablespace status from read/write to read­only

    D

    re­create the read­only tablespace because it is automatically removed


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

  • 第9题：

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


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

  • 第10题：

    单选题
    One of the tablespaces is read-only in your database. The loss of all control files forced you to re-create the control file. Which operation do you need to perform after re-creating the control file and opening the database？（）
    A

     drop and re-create the read-only tablespaces

    B

     rename the read-only data files to their correct file names

    C

     change the tablespace status from read/write to read-only

    D

     re-create the read-only tablespace because it is automatically removed


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

  • 第11题：

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

  • 第12题：

    多选题
    You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups. Identify two prerequisites to perform the backups.（）
    A

    The database must be opened in restricted mode.

    B

    The database must be configured to run in ARCHIVELOG mode.

    C

    The tablespaces are required to be in backup mode before taking the backup.

    D

    The tablespaces are required to be in read-only mode before taking the backup


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

  • 第13题：

    You are using a recovery catalog to maintain Recovery Manager （RMAN） backup information for your production database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups.  Identify two options for completing this task.（）

    • A、 Reregistering the target database in recovery catalog
    • B、 Transporting the new tablespaces to the recovery catalog database
    • C、 Syncronizing the recovery catalog with the target database control file
    • D、 Performing a fresh backup of the target database to include the new data files in the catalog database

    正确答案:C,D

  • 第14题：

    You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？ （）

    • A、Hot backup
    • B、Online backup
    • C、consistent backup
    • D、incremental backup
    • E、inconsistent backup

    正确答案:C

  • 第15题：

    You are managing a 24*7 database. The backup strategy for the database is to perform user-managedbackups.Identify two prerequisites to perform the backups. (Choose two.)（）

    • A、The database must be opened in restricted mode.
    • B、The database must be configured to run in ARCHIVELOG mode.
    • C、The tablespaces are required to be in backup mode before taking the backup.
    • D、The tablespaces are required to be in read-only mode before taking the backup

    正确答案:B,C

  • 第16题：

    Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups.  Which two backups would you be able to perform when the database is being accessed by users？（）

    • A、backup of offline tablespaces
    • B、backup of read­only tablespaces
    • C、backup of system­critical tablespaces
    • D、backup of online， locally managed tablespaces
    • E、backup of read/write dictionary­managed tablespaces

    正确答案:A,B

  • 第17题：

    You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups. Identify two prerequisites to perform the backups.（）

    • A、The database must be opened in restricted mode.
    • B、The database must be configured to run in ARCHIVELOG mode.
    • C、The tablespaces are required to be in backup mode before taking the backup.
    • D、The tablespaces are required to be in read-only mode before taking the backup

    正确答案:B,C

  • 第18题：

    Your boss at Certkiller .com wants you to clarify Oracle 10g. Which two steps are performed the first time any UPDATE statement is issued after the instance is started？（）

    • A、Creating the parse tree of the statement
    • B、Writing the modified data blocks to the data files
    • C、Writing the modified data to the archived redo log files
    • D、Updating the control file to indicate the most recent checkpoint
    • E、Updating the data file header to indicate the most recent checkpoint
    • F、Reading the blocks to database buffer cache if they are not already there

    正确答案:C,D

  • 第19题：

    You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）

    • A、One tablespace has only one datafile
    • B、Many tablespaces can share one datafile
    • C、One tablespace can have many datafiles
    • D、One datafile can contain many tablespaces

    正确答案:C

  • 第20题：

    单选题
    You work as a database administrator for Certkiller .com. In your organization， you have four databases， Certkiller DB01， Certkiller DB02， Certkiller DB03， and Certkiller DB04， which are located in Berlin， Frankfurt，Rammstein， and Munich respectively， and which were created using Database Configuration Assistant （DBCA）.  You want to perform administrative tasks on these databases that include startup and shutdown， taking regular backups， and so on， fromFrankfurtusing Oracle tools. Which Oracle file would you enable to perform this task？（）
    A

    Control file

    B

    Password file

    C

    Parameter file

    D

    Online redo log file

    E

    Listener controller file

    F

    Server parameter file


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

  • 第21题：

    单选题
    You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）
    A

    One tablespace has only one datafile

    B

    Many tablespaces can share one datafile

    C

    One tablespace can have many datafiles

    D

    One datafile can contain many tablespaces


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

  • 第22题：

    多选题
    You work as a database administrator for Certkiller .com. You are using Recovery Manager （RMAN） to perform backups in your databases.  Which four backup operations can be performed using RMAN？（）
    A

    A backup of the target database when it is mounted

    B

    A backup of online redo log files when the database is open

    C

    A backup of only used data blocks in the file beingbeingbackup up

    D

    A backup of online， read/write data files when the database is open

    E

    A backup of only those data blocks that have changed since a previous backup

    F

    A backup of online， read/write data files when the database is in the NOMOUNT state.


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

  • 第23题：

    单选题
    Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the contents of the V$PARAMETER view is true？（）
    A

    Displays only the list of default values

    B

    Displays only the list of all basic parameters

    C

    Displays the currently in effect parameter values

    D

    Displays only the list of all advanced parameters

    E

    Displays the list of all the parameter files of a database

    F

    Displays the current contents of the server parameter file.


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

相关内容