单选题Which command would correctly start a TSPITR of the USERS tablespace？（）A recover tablespace users until time ，，10/06/2008：22：42：00 auxiliary ，，c/oracle/auxiliaryB recover tablespace users time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliary； time ，， 10/06/2008：22：42：00 auxiliary destination ，，c/oracle/auxiliaryC recover tablespace users to point-in.D recover tablespace users except time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliaryE recover tablespace users until time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliary
单选题
Which command would correctly start a TSPITR of the USERS tablespace？（）
A
recover tablespace users until time ，，10/06/2008：22：42：00 auxiliary ，，c/oracle/auxiliary
B
recover tablespace users time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliary； time ，， 10/06/2008：22：42：00 auxiliary destination ，，c/oracle/auxiliary
C
recover tablespace users to point-in.
D
recover tablespace users except time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliary
E
recover tablespace users until time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliary
参考解析
解析：
暂无解析
相关考题：
多选题ou are using the flash recovery area （fast recovery area in 11g Release 2） to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is （jetting filled up very fast and it is running out of space. Your database flash recovery area is low on specie and you have no more room on disk. Proactively， which two options could you use to make more space available in the flash recovery（）AChange the RMAN archived log deletion policy.BUse the RMAN CROSSCHECK command to reclaim the archived log space.CChange the RMAN retention policy to retain backups for a shorter period of time.DUse OS command to move files from the flash recovery area to some other location.
多选题Which two changes and their effect on the system can be tested by using the Database Replay feature？（）Amultiplexing of the control fileBadding the redo log member to the databaseCdatabase and operating system upgradesDchanging the database storage to ASM-managed storage
多选题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
单选题How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has already completed？（）A Issue the ALTER DISKGROUP ... ADD DISK command.B Issue the ALTER DISKGROUP ... UNDROP DISKS command.P.... DROP DISK CANCEL command.C Issue the ALTER DISKGROUD Retrieve the disk from the Recycle Bin after the operation completes.
单选题Examine the CREATE DISKGROUP command used to create a disk group： SQL CREATE DISKGROUP misc EXTERNAL REDUNDANCY DISK ’ORCL： FRA3’ NAME misc1， ’ORCL： FRA4’ NAME misc2； In which situation would you use this method of disk group creation？（）A When two-way disk mirroring is required for the allocation unitsB When three-way disk mirroring is required for the allocation unitsC When using hardware mirroring or RAIDD When disk mirroring is required for the Automatic Storage Management （ASM） disks
多选题Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?（） (Choose three.)ABoth source and target database must be the same character setBBoth source and target database must have the same endian formatCThe COMPATIBLE parameter must be the same in the source and target databases.DThe minimum compatibility level for both the source and target database must be 10.0.0.EAll read-only and offline data files that belong to the tablespace to be transported must be platform aware.
多选题You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUTparameter set to a nonzero value.Which three statements about resumable space allocation are true? （）(Choose three.)AEven with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.BA resumable statement is suspended only if an out of space error occurs.CWhen a resumable statement is suspended, the transaction that contains the statement is also suspended.DA resumable statement can only be suspended and resumed once during the execution of the statement.EYou can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session
单选题You executed the following PL/SQL block successfully： VARIABLE tname VARCHAR2（20） BEGIN dbms_addm.insert_finding_directive （NULL， DIR_NAME=’Detail CPU Usage’， FINDING_NAME=’CPU Usage’， MIN_ACTIVE_SESSIONS=0， MIN_PERC_IMPACT=90）； ：tname ：= ’database ADDM task4’； dbms_addm.analyze_db（：tname， 150， 162）； END； / Then you executed the following command： SQL SELECT dbms_addm.get_report（：tname） FROM DUAL； The above command produces Automatic Database Diagnostic Monitor （ADDM） analysis（）A with the CPU Usage finding if it is less than 90B without the CPU Usage finding if it is less than 90C with the CPU Usage finding for snapshots below 90D with the CPU Usage finding for snapshots not between 150 and 162
单选题Which statement is true regarding virtual private catalogs?（）AA virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.BThe virtual private catalog owner cannot create and modify the stored scripts.CThe set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.DTo perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database
单选题If a backup set is expired， what can you do to correct the problem？（）A Change the retention criteria.B Make the lost backup set pieces available to RMAN again.C Run the crosscheck command to correct the location for the backup set piece contained in the metadata.D Nothing. The backup set piece is lost forever.E Call Oracle support，their assistance is required.
单选题In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN: RMAN CONFIGURE DEVICE TYPE disk PARALLELISM 2 BACKUP TYPE TO BACKUPSET; RMAN CONFIGURE CHANNEL 1 DEVICE TYPE disk FORMAT '/home/oracle/disk1/%U'; RMAN CONFIGURE CHANNEL 2 DEVICE TYPE disk FORMAT '/home/oracle/disk2/%U'; You issue the following RMAN command to backup the database: RMAN RUN 2 { 3 ALLOCATE CHANNEL ch1 DEVICE TYPE disk; 4 BACKUP DATABASE; 5 } Which statement is true about the outcome?（）AOnly one channel is allocated and the backup is created in the flash recovery areaBOnly one channel is allocated and the backup is created in the destination specified for channel 1CTwo channels are allocated and backup sets are created in the destinations specified for channels 1 and 2DThree channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA
单选题You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time. How would you accomplish this task？（）A Set metric thresholdB Implement Database Resource ManagerC Enable resumable timeout for user sessionsD Add directives to Automatic Database Diagnostic Monitor （ADDM）
单选题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
单选题What type of backup is stored in a proprietary RMAN format？（）A Backup setB Image copyC Backup sectionD Backup group
单选题Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement？（）A SQL Repair AdvisorB SQL OptimizerC SQL Access AdvisorD SQL Tuning Advisor
单选题You create two resource plans，one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity. How would you achieve this？（）A Implement job classesB Implement Scheduler windowsC Implement the mapping rule for the consumer groupsD Set the SWITCH_TIME resource plan directive for both the resource plans
单选题Which command would you use to determine what database backups are currently available for restore？（）A list database backupB report database backupC list backup of databaseD list summary backupE report backup of database
单选题Which command is used to begin a tablespace point-in-time recovery？（）A Restore tablespaceB Recover tablespaceC Tablespace recoverD Recover to timeE recover datafile
多选题The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management （ASM） instance. SQL STARTUP； Which two activities are performed during a successful start up operation？（）AThe databases configured to use the ASM instance are mountedBThe disk groups are mounted as per the ASM_DISKGROUPS initialization parameterCASM starts the Oracle Cluster Synchronization Services （CSS） daemon if it is not startedDASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters
单选题Which of the following does the recover command not do？（）A Restore archived redo logs.B Apply archived redo logs.C Restore incremental backups.D Apply incremental backups.E Restore datafile images.
单选题Which of the following is a potential performance tuning recommendation from the SQL Access Advisor？（）A Create new indexes.B Modify existing indexes.C Implement partitioning on a nonpartitioned table.D Create materialized views.E All of the above
多选题Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager （RMAN）.（）AYou can use RMAN stored scriptsBRecovery is faster if data is stored in catalog in addition to the control fileCYou can store backup information of all registered databases in one placeDDatabase backups are automatically deleted when they are older than the specified time period
单选题You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command. Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?（）ARestore the backup control file and open the database with RESETLOGS option.BPerform point-in-time recovery because flashback cannot be performed again on this tableCExecute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571DExecute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571
多选题You want to enable resumable space allocation at the instance level. Which two actions would enable resumable space allocation at the instance level？（）Aissuing the ALTER SYSTEM ENABLE RESUMABLE；statementBissuing the ALTER SESSION ENABLE RESUMABLE；statementCmodifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero valueDissuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=；statement
多选题Which of the following Oracle features utilize the undo tablespace？（）AFlashback QueryBFlashback DropCFlashback TableDFlashback DatabaseETransaction ProcessingFRecycle Bin
多选题The NLS_TERRITORY parameter specifies the default conventions to be used for which of the following globalization elements？（）ADate formatBDecimal characterCGroup separatorDFirst day of the monthENone of the aboveFAll of the above
多选题To enable faster incremental backups， you enabled block change tracking for the database. Which two statements are true about the block change tracking file？（）AMultiple change tracking files can be created for a database.BThe change tracking file must be created after the first level 0 backup.CRMAN does not support backup and recovery of the change tracking file.DThe database clears the change tracking file and starts tracking changes again，after whole database restore and recovery operations.
单选题Which type of backup contains only the blocks that have changed since the last level 0 incremental backup？（）A a cumulative level 1 backupB a differential level 1 backupC a full backupD a whole backup