itgle.com

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 CLE

题目

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
相似考题

1.What two are the prerequisites for enabling Flashback Database?()A. The database must be in ARCHIVELOG modeB. The database must be in MOUNT EXCLUSIVE modeC. The database must be opened in RESTRICTED modeD. The database instance must be started in the NOMOUNT stateE. The database instance must have the keep buffer pool defined

2.Youhavecreatedascriptintherecoverycatalogcalledbackup_database.Whichofthefollowingcommandswouldsuccessfullyexecutethatscript?()A.run{openscriptbackup_database；runscriptbackup_database}B.run{engagescriptbackup_database；}C.run{runscriptbackup_database；}D.Run{executescriptbackup_database；}E.Thenamebackup_databaseisaninvalidnameforanRMANscript.TryingtorunitfromRMAN wouldresultinanerror.

3.Which command do you use to generate a report of database incarnations？（）  A、 list incarnation of databaseB、 report incarnation of databaseC、 list database incarnationD、 database incarnation listE、 report database incarnation

4.You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database.You executed the following RMAN commands:What are the implications of this command?（）A. It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.B. It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.C. It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.D. It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.

更多“The database is ”相关问题

  • 第1题：

    Which statement is true about the database and database-user used during installation of IMS Server？（）

    • A、A preexisting database user may be used but a new database has to be created during installation.
    • B、A preexisting database may be used but a new database user has to be created during installation.
    • C、A preexisting database and user may be used or a new database and user are created during installation.
    • D、A preexisting database and user cannot be used； a new database and user are created during  installation.

    正确答案:C

  • 第2题：

    Which command is used to open the database after an incomplete recovery？（）

    • A、 alter database open
    • B、 alter database open repairlog
    • C、 alter database open resetlogs
    • D、 alter database open resetlog
    • E、 alter database resetlogs open

    正确答案:C

  • 第3题：

    You plan to execute the following command to perform a Flashback Database operation in your database：   SQL> FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）；   Which two statements are true about this？（）

    • A、 The database must have multiplexed redo log files
    • B、 The database must be in the MOUNT state to execute the command
    • C、 The database must be in the NOMOUNT state to execute the command
    • D、 The database must be opened in RESTRICTED mode before this operation
    • E、 The database must be opened with the RESETLOGS option after the flashback operation

    正确答案:B,E

  • 第4题：

    You are managing a single instance Oracle 10g database that utilizes the following parameters：  Which of the following set of commands must you execute to enable Flashback Database？（）

    • A、  STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；
    • B、  STARTUP MOUNT  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；
    • C、  STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；
    • D、  STARTUP MOUNT  ALTER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；

    正确答案:D

  • 第5题：

    多选题
    You plan to execute the following command to perform a Flashback Database operation in your database: SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24); Which two statements are true about this?（）
    A

    The database must have multiplexed redo log files

    B

    The database must be in the MOUNT state to execute the command

    C

    The database must be in the NOMOUNT state to execute the command

    D

    The database must be opened in RESTRICTED mode before this operation

    E

    The database must be opened with the RESETLOGS option after the flashback operation


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

  • 第6题：

    单选题
    Which command is used to open the database after an incomplete recovery？（）
    A

     alter database open

    B

     alter database open repairlog

    C

     alter database open resetlogs

    D

     alter database open resetlog

    E

     alter database resetlogs open


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

  • 第7题：

    单选题
    You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database. You executed the following RMAN commands：   RMAN> CONNECT TARGET sys/sys@APPPROD RMAN> CONNECT AUXILIARY sys/sys@DUPDB RMAN> DUPLICATE TARGET DATABASE TO dupdb  FROM ACTIVE DATABASE PASSWORD FILE SPILE  NOFILENAMECHECK；   What are the implications of this command？（）
    A

     It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.

    B

     It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.

    C

     It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.

    D

     It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.


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

  • 第8题：

    多选题
    What two are the prerequisites for enabling Flashback Database?（） (Choose two)
    A

    The database must be in ARCHIVELOG mode

    B

    The database must be in MOUNT EXCLUSIVE mode

    C

    The database must be opened in RESTRICTED mode

    D

    The database instance must be started in the NOMOUNT state

    E

    The database instance must have the keep buffer pool defined


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

  • 第9题：

    多选题
    You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?（）
    A

    The source database backup must be copied over the net for test database.

    B

    The source database must be run in ARCHIVELOG mode if the database is open.

    C

    The source database must be shut down cleanly if the database is in mounted state.

    D

    A net service name should be set up and a listener configured with the target as well as the source database.


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

  • 第10题：

    单选题
    What is the correct order of steps for upgrading a cisco wcs？（）
    A

    back up the database， stop the wcs， upgrade the wcs， restore the database， start the wcs 

    B

    stop the wcs， back up the database， upgrade the wcs， restore the database， start the wcs

    C

    back up the database， stop the wcs， upgrade the wcs， start the wcs， restore the database 

    D

    stop the wcs， back up the database， upgrade the wcs， start the wcs， restore the database


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

  • 第11题：

    多选题
    Which two database operations can be performed at the MOUNT stage of database startup？（）
    A

    renaming of data files

    B

    dropping the database user

    C

    renaming of control files

    D

    multiplexing of control files

    E

    configuring the database in ARCHIVELOG mode


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

  • 第12题：

    单选题
    Which statement is true about the database and database-user used during installation of IMS Server？（）
    A

    A preexisting database user may be used but a new database has to be created during installation.

    B

    A preexisting database may be used but a new database user has to be created during installation.

    C

    A preexisting database and user may be used or a new database and user are created during installation.

    D

    A preexisting database and user cannot be used； a new database and user are created during  installation.


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

  • 第13题：

    What two are the prerequisites for enabling Flashback Database?（） (Choose two)

    • A、The database must be in ARCHIVELOG mode
    • B、The database must be in MOUNT EXCLUSIVE mode
    • C、The database must be opened in RESTRICTED mode
    • D、The database instance must be started in the NOMOUNT state
    • E、The database instance must have the keep buffer pool defined

    正确答案:A,B

  • 第14题：

    If you lost your entire database，including the database spfile，control files，online redo logs，and database datafiles，what kind of recovery would be required with RMAN？（）  

    • A、 Complete database recovery.
    • B、 Incomplete database recovery.
    • C、 Approximate database recovery.
    • D、 Archived database recovery.
    • E、 The database could not be recovered with RMAN.

    正确答案:B

  • 第15题：

    What two are the prerequisites for enabling Flashback Database？（） 

    • A、 The database must be in ARCHIVELOG mode
    • B、 The database must be in MOUNT EXCLUSIVE mode
    • C、 The database must be opened in RESTRICTED mode
    • D、 The database instance must be started in the NOMOUNT state
    • E、 The database instance must have the keep buffer pool defined

    正确答案:A,B

  • 第16题：

    What are the prerequisites for enabling Flashback Database？ （）

    • A、 The database must be started in the MOUNT EXCLUSIVE state.
    • B、 The database must have multiplexed control files.
    • C、 The database must be opened by using a text-based parameter file instead of a server parameter file （SPFILE）.
    • D、 The database must be in ARCHIVELOG mode.
    • E、 The database must be in the NOMOUNT state.
    • F、 The database must be opened in RESTRICTED mode.

    正确答案:A,D

  • 第17题：

    单选题
    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a SQL Server 7.0 database. You upgrade the database to the SQL Server instance. According to the company requirement, you must make sure that suspect pages can be detected in the database. So what action should you perform to achieve this goal?（）
    A

    For the database, you should turn on the TRUSTWORTHY database option

    B

    For the database, the PAGE_VERIFY database option should be set to CHECKSUM

    C

    For the database, the database compatibility level option should be set to 10

    D

    For the model database, the PAGE_VERIFY database option should be set to TORN_PAGE_DETECTION. 


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

  • 第18题：

    多选题
    What two are the prerequisites for enabling Flashback Database?（）
    A

    The database must be in ARCHIVELOG mode

    B

    The database must be in MOUNT EXCLUSIVE mode

    C

    The database must be opened in RESTRICTED mode

    D

    The database instance must be started in the NOMOUNT state

    E

    The database instance must have the keep buffer pool defined


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

  • 第19题：

    单选题
    While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective？（）
    A

    configure the database to run in ARCHIVELOG mode

    B

    configure the Flash Recovery Area to enable automatic database backup

    C

    schedule the database backup using DBMS_JOB package after creating the database

    D

    schedule the database backup using Recovery Manager （RMAN）commands after creating the database

    E

    schedule the database backup using Database Configuration Assistant （DBCA）while creating the database


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

  • 第20题：

    单选题
    You find today’s performance of your production database to be the best ever. Therefore， you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this？（）
    A

    create baseline metrics for today’s performance

    B

    write the current database metrics to a database table and create a trigger to compare with future database statistics

    C

    write the current database metrics to a flat file and create an operating script to compare with future database statistics

    D

    write the current database metrics to a database table and create a procedure to compare with future database statistics

    E

    write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics


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

  • 第21题：

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

  • 第22题：

    单选题
    If you lost your entire database，including the database spfile，control files，online redo logs，and database datafiles，what kind of recovery would be required with RMAN？（）
    A

     Complete database recovery.

    B

     Incomplete database recovery.

    C

     Approximate database recovery.

    D

     Archived database recovery.

    E

     The database could not be recovered with RMAN.


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

  • 第23题：

    单选题
    You are managing a single instance Oracle 10g database that utilizes the following parameters：  Which of the following set of commands must you execute to enable Flashback Database？（）
    A

      STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；

    B

      STARTUP MOUNT  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；

    C

      STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；

    D

      STARTUP MOUNT  ALTER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；


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

  • 第24题：

    单选题
    RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）
    A

    ’SQL ALTER DATABASE OPEN’；

    B

    SQL ALTER DATABASE ’OPEN’；

    C

    OPEN DATABASE；

    D

    DATABASE OPEN


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

相关内容