单选题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：（）AALTER DATABASE DROP LOGFILE GROUP 1BALTER DATABASE CLEAR LOGFI

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

相似考题

1.单选题Which components are needed for successful and most efficient recovery.（）AThe backup RB3 and the current online redo log filesBthe backup RB2 and the archived redo log files after the log sequence number 15622CBackup R81 and the archived redo log hies after the log sequence number 12871DThe backup RB3 and the archived redo log files after the log sequence number 16721

2.单选题Tape streaming is not happening while performing RMAN tape backup. On investigation， you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to the tape drive fast enough. What could be a solution to make tape streaming happen during the backup？（）AConfigure backup optimizationBConfigure the channel to increase MAXOPENFILESCConfigure the channel to increase the capacity with the RATE parameterDConfigure the channel to adjust the tape buffer size with the BLKSIZE option

3.多选题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.（）AReregistering the target database in recovery catalogBTransporting the new tablespaces to the recovery catalog databaseCSyncronizing the recovery catalog with the target database control fileDPerforming a fresh backup of the target database to include the new data files in the catalog database

4.单选题You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository. Which condition must be met before you create the VPC?（）A A base catalog existsB The recovery catalog is emptyC The base recovery catalog must be droppedD A target database is registered in the recovery catalog

更多“Your database is in ARCHIVELOG mode. You have two online red”相关问题

  • 第1题：

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

  • 第2题：

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

  • 第3题：

    单选题
    How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has alreadycompleted?（）
    A

    Issue the ALTER DISKGROUP ... ADD DISK command.

    B

    Issue the ALTER DISKGROUP ... UNDROP DISKS command.

    C

    Issue the ALTER DISKGROUP ... DROP DISK CANCEL command.

    D

    Retrieve the disk from the Recycle Bin after the operation completes


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

  • 第4题：

    单选题
    Given the following steps, which would be the correct order to create a backup of an Oracle database in NOARCHIVELOG mode?（） 1.shutdown immediate from RMAN 2.Log into RMAN 3.startup mount from RMAN 4.backup database 5.alter database open 6.backup database plus archivelog delete input
    A

    2，3，1，4，5

    B

    2，1，3，6，5

    C

    1，3，5，4

    D

    2，1，3，5，6

    E

    2，1，3，4，5


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

  • 第5题：

    多选题
    The EMP table exists in your schema. You want to execute the following query：   SELECT ename， sal FROM emp AS OF TIMESTAMP （SYSTIMESTAMP - INTERVAL ’6’ MINUTE）   WHERE ename = ’ALLEN’；   What are the minimum requirements for the statement to execute successfully？（）
    A

    ARCHIVELOG mode must be enabled

    B

    Row Movement must be enabled for the table

    C

    FLASHBACK must be set to ON for the database

    D

    The UNDO_MANAGEMENT parameter must be set to AUTO

    E

    The UNDO_RETENTION parameter must be set appropriately


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

  • 第6题：

    单选题
    What command is used to reset a database to a previous incarnation？（）
    A

     reset incarnation

    B

     incarnation reset

    C

     reset database to incarnation

    D

     reset database incarnation

    E

     reset databse incarnation number


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

  • 第7题：

    单选题
    What does the output on this report indicate？（）   RMAN> report need backup；  RMAN retention policy will be applied to the command  RMAN retention policy is set to redundancy 1  Report of files with less than 1 redundant backups  File #bkps Name  5 0 C:///ORACLE/ORADATA/ORCL/MY_DATA_01.DBF
    A

     The my_data_01.dbf datafile is corrupted and needs to be restored.

    B

     The my_data_01.dbf datafile has not yet been backed up. This report does not imply that the data in the datafile can not be recovered.

    C

     The my_data_01.dbf datafile has not yet been backed up. This report implies that the data in the datafile can not be recovered.

    D

     The my_data_01.dbf datafile no longer meets the retention criteria for backups.

    E

     Datafile 5 is missing.


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

  • 第8题：

    单选题
    To view the results of the most recent Automatic SQL Tuning Advisor task, which sequence should you follow?（）
    A

    EM Database home page, Software and Support, SQL Advisors, Automatic SQL Tuning Advisor.

    B

    EM Database home page, Software and Support, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor.

    C

    EM Database home page, Software and Support, Support Workbench, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor.

    D

    Either B or C

    E

    All of the above


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

  • 第9题：

    单选题
    You issue the following RMAN command to set a retention policy on a database: RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of issuing this command?（）
    A

    After two days, a backup will be marked obsolete

    B

    After two days, a backup will be deleted from the media

    C

    If the RMAN repository has records of two or more recent backups of a file, then older backups will be deleted from the media.

    D

    If the RMAN repository has records of two or more recent backups of a file, then older backups will be marked obsolete.


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

  • 第10题：

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


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

  • 第11题：

    多选题
    Which two client requests are captured during database replay Capture？（）
    A

    Flashback queries

    B

    Shared server requests

    C

    Login and logoff activities of sessions

    D

    Direct path load of data from external files by using utilities such as SQL *loader

    E

    Data definition language （DDL） and data manipulation language （DML） operations


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

  • 第12题：

    单选题
    What is the default AU size of an ASM disk group？ What is the maximum AU size in an ASM disk group？（）
    A

     100KB default， 10TB maximum

    B

     256KB default， 1024MB maximum

    C

     10MB default， 126PB maximum

    D

     64KB default， 1EB maximum

    E

     1MB default， 64MB maximum


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

  • 第13题：

    单选题
    You issued the following command on the temporary tablespace LMTEMP in your database：   SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M；   Which requirement must be fulfilled for this command to succeed？（）
    A

     The tablespace must be locally managed.

    B

     The tablespace must have only one temp file.

    C

     The tablespace must be made nondefault and offline.

    D

     The tablespace can remain as the default but must have no active sort operations.


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

  • 第14题：

    单选题
    To clean up old records that are in a Flashback Data Archive and are past the retention period， what must the DBA do？（）
    A

     TRUNCATE the archive table.

    B

     DROP the Flashback Data Archive.

    C

     Nothing；expired rows are automatically removed.

    D

     Nothing；expired rows are moved to an archive table.

    E

     Delete entries from the archive where the metadata date retained is greater than the retention period.


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

  • 第15题：

    单选题
    Examine the following values of the initialization parameters in the database having the SID ORCL: BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST= The environment variables have the following value: ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1 What is the location of the Automatic Diagnostic Repository (ADR) home?（）
    A

    /u01/app/oracle/product/11.1.0/db_1

    B

    /u01/app/oracle

    C

    $ORACLE_HOME/bdump

    D

    $ORACLE_HOME/log


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

  • 第16题：

    单选题
    Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS  which statement is true？（）
    A

     You cannot perform the TSPITR with the constraints enabled.

    B

     You must perform the TSPITR recovery of both tablespaces for it to be successful.

    C

     You can perform TSPITR only on the USERS tablespace.

    D

     RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it  automatically.

    E

     The TSPITR will only be successful if the constraint is enabled.


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

  • 第17题：

    多选题
    Which operation requires that you create an auxiliary instance manually before executing the operation？（）
    A

    Backup-based database duplication.

    B

    Active database duplication.

    C

    Tablespace point-in-time recovery.

    D

    No operation requires the creation of an auxiliary instance.


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

  • 第18题：

    单选题
    What does the DB_FLASHBACK_RETENTION_TARGET parameter configure？（）
    A

     An upper limit on how far you can flash back the database，depending on the information in the redo logs

    B

     An upper limit on how far you can flash back the database，depending on the information in the undo tablespace

    C

     The amount of time for which the flashback data is to be kept in the flash recovery area， provided that there is enough space

    D

     The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace，provided that there is enough space


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

  • 第19题：

    单选题
    What is the danger associated with stopping a running job by using the STOP_JOB procedure？（）
    A

     The job will need to be reenabled before it will execute again.

    B

     The job may hold locks on objects referenced within it.

    C

     All jobs within the job group will also be stopped.

    D

     The job may leave data in an inconsistent state.

    E

     There is no danger in using the STOP_JOB procedure.


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

  • 第20题：

    单选题
    You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2. The SALES table has a materialized view， materialized log， indexes， referential integrity constraint， and triggers with the PRECEDES clause existing on it.  What action is required for dependent objects when you perform online table redefinition？（）
    A

     The dependent materialized view should have a complete refresh performed after the online table redefinition process.

    B

     Triggers with the PRECEDES clause should be disabled before the online table redefinition process.

    C

     Referential integrity constraints must be manually enabled after the online table redefinition process.

    D

     The materialized log should be dropped before the online table redefinition process.


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

  • 第21题：

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

  • 第22题：

    多选题
    Which statement describes the significance of the CHANGE FAILURE command in RMAN？（）
    A

    It is used to change failure priority only for HIGH or LOW priorities.

    B

    It is used to execute the advised repair script.

    C

    It is used to change failure priority only for the CRITICAL priority.

    D

    It is used to explicitly close the open failures.

    E

    It is used to inform the database about the repair after the repair script executes.


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

  • 第23题：

    多选题
    You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps.  What configuration would you effect to achieve your objective？（）
    A

    Set the ASM compatibility attribute for the ASM disk group to 11.1.0.

    B

    Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.

    C

    Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.

    D

    Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.


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

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

相关内容