单选题What is the impact of the following backup if it exceeds the duration allowance？（） Backup as compressed backupset duration 2：00 partial minimize load database ；AThe entire backup will fail.It will not be usable for recovery.BThe entire backup will fail

题目
单选题
What is the impact of the following backup if it exceeds the duration allowance？（） Backup as compressed backupset duration 2：00 partial minimize load database ；
A

 The entire backup will fail.It will not be usable for recovery.

B

 The entire backup will failbut any datafile successfully backed up will be usable for recovery.

C

 If this backup fails，subsequent backups will prioritize datafiles not backed up.

D

 If this backup fails，an error will be raised and any other commands will not be executed. 

E

 If this backup fails，no error will be raised and any other commands will be executed.

相似考题

1.多选题Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（）ADatabase datafilesBControl filesCArchived redo logsDOnline redo logsEFlashback logs

2.单选题You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Identify the appropriate configuration to accomplish faster and optimized backups using the above command.（）A The SBT channel must be configured, with the MAXPIECESIZE set to 300 mb.B The SBT channel must be configured, with the parallelism setting for the SBT devices set to 3.C The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.D The SBT channel must be configured, with the default parallelism setting for the SBT devices set to 1

3.多选题You execute the following Recovery Manager （RMAN） commands in he following order：   BACKUP VALIDATE DATABAE RECOVER CORRUPTION LIST；   Which two tasks are performed by these commands？（）ARepair the corrupted blocks. If any. In the backup createdBPopulate VSCOPV_CORRUPTION with names of files that have corrupted blocksCBack up the database after checking whether array of the files have corrupted blocksDDiscover any corrupt blocks that are viewable with the VSDATABASE_BI-OCK_CORBUPTION viewERepair all corrupted blocks that have been logged in the VSDATABASE_BLOCK_ CORRUPTION

4.单选题When manually configuring the SGA，which of the following parameter changes requires an instance restart to take effect？（）   "First Test， First Pass" - www.lead2pass.com 97 Oracle 1Z0-053 ExamADB_CACHE_SIZEBSHARED_POOL_SIZECLARGE_POOL_SIZEDJAVA_POOL_SIZEESGA_MAX_SIZEFSORT_AREA_SIZE

更多“What is the impact of the following backup if it exceeds the”相关问题

  • 第1题：

    单选题
    Examine the exhibit to view the parameters set in your parameter file. (Click the Exhibit(s) button.) You restart the instance. To what value will the MEMORY_MAX_TARGET parameter be set by default?（）
    A

    120M

    B

    320M

    C

    480M

    D

    600M


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

  • 第2题：

    单选题
    Which initialization parameter in an ASM instance specifies the disk groups to be automatically mounted at instance startup？（）
    A

     ASM_DISKMOUNT

    B

     ASM_DISKGROUP

    C

     ASM_DISKSTRING

    D

     ASM_MOUNTGROUP


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

  • 第3题：

    多选题
    Which client requests to the database can be captured as a part of the workload capture？（）
    A

    flashback query

    B

    distributed transactions

    C

    logging in and logging out of sessions

    D

    all DDL statements having bind variables

    E

    direct path load of data from external files


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

  • 第4题：

    多选题
    What elements of globalization can be explicitly defined using the NLS_LANG environment variable？（）
    A

    NLS_LANGUAGE

    B

    NLS_SORT

    C

    NLS_CALENDAR

    D

    NLS_CHARACTERSET

    E

    NLS_TERRITORY


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

  • 第5题：

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


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

  • 第6题：

    单选题
    A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows: SQL> CREATE DISKGROUP dgroup1 NORMAL REDUNDANCY FAILGROUP controller1 DISK '/devices/diska1', '/devices/diska2' FAILGROUP controller2 DISK '/devices/diskb1', '/devices/diskb2' ; What happens when the whole CONTROLLER1 Failure group is damaged?（）
    A

    The transactions that use the disk group will halt.

    B

    The mirroring of allocation units occurs within the CONTROLLER2 failure group.

    C

    The data in the CONTROLLER1 failure group is shifted to the CONTROLLER2 failure group and implicit rebalancing is triggered.

    D

    The ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group.


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

  • 第7题：

    单选题
    Which of the following is not an advantage of block media recovery （BMR）？（）
    A

     Reduced MTTR.

    B

     Datafiles remain offline while corrupt blocks are repaired.

    C

     Datafiles remain online while corrupt blocks are repaired.

    D

     A and C


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

  • 第8题：

    单选题
    When shrinking a table segment， you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use？（）
    A

     INCLUDING DEPENDENCIES

    B

     INCLUDING DEPENDENCIES CASCADE

    C

     COMPACT

    D

     CASCADE

    E

     None of the above


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

  • 第9题：

    多选题
    Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) whileduplicating a running database? （）(Choose Two)
    A

    Creating the control file for the duplicate database

    B

    Restoring the target data files to the duplicate database

    C

    Performing complete recovery using all available backups

    D

    Generating a new, unique DBID for the duplicate database

    E

    Copying the online redo log files from the target database to the duplicate database


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

  • 第10题：

    多选题
    Examine the following command that is used to duplicate a database on the same host: RMAN> RUN { ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; / } Which two statements describe the effect after the database is duplicated successfully? （）(Choose two)
    A

    The data files of the read-only tablespaces in the target database are not duplicated

    B

    The read-only tablespaces in the target database are still defined in new the database

    C

    The read-only tablespaces in the target database are changed to online after duplication

    D

    The data files of the read-only tablespaces in the target database get duplicated

    E

    The read-only tablespaces in the target database are not defined in the new database


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

  • 第11题：

    单选题
    In Recovery Manager （RMAN）， you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task， you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged， you want to place the data file in a different location while resto ing the file.  Which option must you consider for this task？（）
    A

     using only the RMAN SWITCH command to set the new location for the data file

    B

     placing the database in the MOUNT state for the restore and recovery operations

    C

     using an RMAN RUN block with the SET NEWNAME and then the SWITCH command

    D

     configuring two channels： one for the restore operation and the other for the recovery operation


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

  • 第12题：

    单选题
    If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT， what RMAN command would you run to correct the problem？（）
    A

     recover lost blocks

    B

     recover corrupt blocks

    C

     recover media corrupt blocks from list

    D

     recover corrupt blocks from list

    E

     recover corruption list


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

  • 第13题：

    单选题
    The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA’s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework？（）
    A

     statistics recommendations

    B

     SQL profile recommendations

    C

     index-related recommendations

    D

     restructuring of SQL recommendations


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

  • 第14题：

    单选题
    Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?（）
    A

    Segment Advisor

    B

    SQL Access Advisor

    C

    Undo Advisor

    D

    SQL Tuning Advisor


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

  • 第15题：

    单选题
    What is the default value for the ENABLED attribute of a job or program when it is created？（）
    A

     TRUE

    B

     FALSE

    C

     There is no default. It must be defined at creation time.

    D

     PENDING

    E

     NULL


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

  • 第16题：

    单选题
    Which of the following statements is true regarding the VERSIONS BETWEEN clause？（）
    A

     The VERSIONS BETWEEN clause may be used in DML statements.

    B

     The VERSIONS BETWEEN clause may be used in DDL statements.

    C

     The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.

    D

     The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.


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

  • 第17题：

    单选题
    When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（）
    A

     The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGET

    B

     The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGET

    C

     The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory Management

    D

     The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management


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

  • 第18题：

    单选题
    On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30am. Which option must you use to check whether a flashback operation can recover the database to the specified time?（）
    A

    Check the alert log file

    B

    Query the V$FLASHBACK_DATABASE_LOG view

    C

    Query the V$RECOVERY_FILE_DEST_SIZE view

    D

    Query the V$FLASHBACK_DATABASE_STAT view

    E

    Check the value assigned for the UNDO_RETENTION parameter


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

  • 第19题：

    单选题
    How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog？（）
    A

     Issue the grant command from the SYS user （or equivalent） of the target database.

    B

     Issue the grant command from the SYS user （or equivalent） of the recovery-catalog database.

    C

     Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.

    D

     Issue the grant command from RMAN when connected to the recovery catalog-owning schema.

    E

     Issue the grant command from RMAN when connected to the target database.


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

  • 第20题：

    多选题
    You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.  You want the RMAN to import metadata for database IDs 1423241 and 1423242， registered in RCAT10， into the recovery catalog owned by RCO11. You executed the following commands： RMAN> CONNECT CATALOG rco11/password@catdb  RMAN> IMPORT CATALOG rcat10/oracle@inst1 NO UNREGISTER；   Which two statements are true regarding the tasks accomplished with these commands？（）
    A

    They import all metadata from the RCAT10 catalog.

    B

    They unregister the database from the RCAT10 catalog.

    C

    They do not register the databases registered in the RCAT10 catalog.

    D

    They register all databases registered in the RCAT10 catalog.


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

  • 第21题：

    单选题
    Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement？（）
    A

     The SGA Tuning Advisor

    B

     The SQL Access Advisor

    C

     The SQL Tuning Advisor

    D

     The Memory Advisor


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

  • 第22题：

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


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

  • 第23题：

    单选题
    A developer calls and reports that he accidentally dropped an important lookup table from a production database. He needs the table to be recovered. What action would you take？（）
    A

     Initiate an incomplete recovery operation using RMAN.

    B

     Copy the table from a development database.

    C

     Advise the user to rekey the data.

    D

     Perform a Flashback Drop operation.

    E

     Perform a Flashback Recovery operation.


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

  • 第24题：

    多选题
    You executed the following command to drop a user：   DROP USER scott CASCADE；   Which two statements regarding the above command are correct？（）
    A

    All the objects of scott are moved to the Recycle Bin.

    B

    Any objects in the Recycle Bin belonging to scott are purged.

    C

    All the objects owned by scott are permanently dropped from the database.

    D

    All the objects of scott in the Recycle Bin must be purged before executing the DROP command.

    E

    Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.


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

相关内容