单选题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.
单选题
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.
参考解析
解析：
暂无解析
相关考题：
多选题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
单选题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 ExamA DB_CACHE_SIZEB SHARED_POOL_SIZEC LARGE_POOL_SIZED JAVA_POOL_SIZEE SGA_MAX_SIZEF SORT_AREA_SIZE
单选题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.（）AThe SBT channel must be configured, with the MAXPIECESIZE set to 300 mb.BThe SBT channel must be configured, with the parallelism setting for the SBT devices set to 3.CThe COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.DThe SBT channel must be configured, with the default parallelism setting for the SBT devices set to 1
多选题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
单选题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?（）A120MB320MC480MD600M
单选题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 recommendationsB SQL profile recommendationsC index-related recommendationsD restructuring of SQL recommendations
单选题Which initialization parameter in an ASM instance specifies the disk groups to be automatically mounted at instance startup？（）A ASM_DISKMOUNTB ASM_DISKGROUPC ASM_DISKSTRINGD ASM_MOUNTGROUP
单选题Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?（）ASegment AdvisorBSQL Access AdvisorCUndo AdvisorDSQL Tuning Advisor
多选题Which client requests to the database can be captured as a part of the workload capture？（）Aflashback queryBdistributed transactionsClogging in and logging out of sessionsDall DDL statements having bind variablesEdirect path load of data from external files
单选题What is the default value for the ENABLED attribute of a job or program when it is created？（）A TRUEB FALSEC There is no default. It must be defined at creation time.D PENDINGE NULL
多选题What elements of globalization can be explicitly defined using the NLS_LANG environment variable？（）ANLS_LANGUAGEBNLS_SORTCNLS_CALENDARDNLS_CHARACTERSETENLS_TERRITORY
单选题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.
单选题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.Aa， b， c， d， e， f， gBc， d， a， b， e， g， fCf， d， b， g， a， c， eDe， c， d， a， g， f， bEa， f， b， g， e， c， d
单选题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_TARGETB The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGETC 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 ManagementD 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
单选题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?（）AThe transactions that use the disk group will halt.BThe mirroring of allocation units occurs within the CONTROLLER2 failure group.CThe data in the CONTROLLER1 failure group is shifted to the CONTROLLER2 failure group and implicit rebalancing is triggered.DThe ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group.
单选题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?（）ACheck the alert log fileBQuery the V$FLASHBACK_DATABASE_LOG viewCQuery the V$RECOVERY_FILE_DEST_SIZE viewDQuery the V$FLASHBACK_DATABASE_STAT viewECheck the value assigned for the UNDO_RETENTION parameter
单选题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
单选题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.
单选题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 DEPENDENCIESB INCLUDING DEPENDENCIES CASCADEC COMPACTD CASCADEE None of the above
多选题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？（）AThey import all metadata from the RCAT10 catalog.BThey unregister the database from the RCAT10 catalog.CThey do not register the databases registered in the RCAT10 catalog.DThey register all databases registered in the RCAT10 catalog.
多选题Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) whileduplicating a running database? （）(Choose Two)ACreating the control file for the duplicate databaseBRestoring the target data files to the duplicate databaseCPerforming complete recovery using all available backupsDGenerating a new, unique DBID for the duplicate databaseECopying the online redo log files from the target database to the duplicate database
单选题Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement？（）A The SGA Tuning AdvisorB The SQL Access AdvisorC The SQL Tuning AdvisorD The Memory Advisor
多选题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)AThe data files of the read-only tablespaces in the target database are not duplicatedBThe read-only tablespaces in the target database are still defined in new the databaseCThe read-only tablespaces in the target database are changed to online after duplicationDThe data files of the read-only tablespaces in the target database get duplicatedEThe read-only tablespaces in the target database are not defined in the new database
单选题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 switchB You should make a backup of the databaseC You should switch the database to the NONARCHIVELOG modeD You should shut down the database instance and perform a complete database recovery
单选题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 fileB placing the database in the MOUNT state for the restore and recovery operationsC using an RMAN RUN block with the SET NEWNAME and then the SWITCH commandD configuring two channels： one for the restore operation and the other for the recovery operation
单选题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.
单选题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 blocksB recover corrupt blocksC recover media corrupt blocks from listD recover corrupt blocks from listE recover corruption list
多选题You executed the following command to drop a user： DROP USER scott CASCADE； Which two statements regarding the above command are correct？（）AAll the objects of scott are moved to the Recycle Bin.BAny objects in the Recycle Bin belonging to scott are purged.CAll the objects owned by scott are permanently dropped from the database.DAll the objects of scott in the Recycle Bin must be purged before executing the DROP command.EAny objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.