随笔 - 499&
&&&&&&&&&&&
601.You need to perform a block media recovery on the tools01.dbf data file in the SALES database byusing Recovery Manager (RMAN).Which two are the prerequisites to perform this operation? (Choose two)A. You must configure block change tracking fileB. You must have first level 1 backups for RMAN to restore blocksC. You must ensure that the SALES database is mounted or openD. You must have full or level 0 backups for RMAN to restore blocksE. You must take the tools01.dbf data file offline before you start a block media recoveryAnswer: CD602.On Friday at 11:30 am you decided to flash back the database because of a user error that occurredat 8:30 am.Which option must you use to check whether a flashback operation can recover the database to thespecified time?A. Check the alert log fileB. Query the V$FLASHBACK_DATABASE_LOG viewC. Query the V$RECOVERY_FILE_DEST_SIZE viewD. Query the V$FLASHBACK_DATABASE_STAT viewE. Check the value assigned for the UNDO_RETENTION parameterAnswer: B603.While performing a regular check on your recovery catalog you realized that the catalog database isrunning out of space and you do not have options to increase the space. However, you have anotherdatabase where more space is available and you want to move your existing recovery catalog to thisdatabase.The options that can be considered while moving the recovery catalog are as follows:1. Using one of the Oracle expdp utilities to export the catalog data2. Creating a recovery catalog user and granting the necessary privileges in the other database3. Creating the recovery catalog using the CREATE CATALOG command4. Using the corresponding impdp utility to import the catalog data into the other database5. Registering the target database in the new catalog database using the REGISTER DATABASEcommand Identify the option with the correct sequence for moving the recovery catalog.A. 2, 3, 5B. 1, 2, 4C. 1, 2, 4, 5D. 1, 2, 3, 4, 5Answer: B604.You realize that the control file is damaged in your production database. After restoring the control filefrom autobackup, what is the next step that you must do to proceed with the database recovery?A. Mount the databaseB. Open the database in NORMAL modeC. Open the database in RESTRICTED modeD. Open the database with the RESETLOGS optionAnswer: A605.What two are the prerequisites for enabling Flashback Database? (Choose two)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 definedAnswer: AB606.Identify the channel settings that can be performed using the CONFIGURE CHANNEL or ALLOCATECHANNEL commands in RMAN (choose all that apply)A. Limiting the input/output (I/O) bandwidth consumptionB. Specifying the size of backup sets and backup piecesC. Specifying vendor-specific information for a media managerD. Specifying the parallelism for backup and restore operationsAnswer: AC607.Examine the following scenario:-Database is running in ARCHIVELOG mode.-Complete consistent backup is taken every Sunday.-On Tuesday the instance terminates abnormally because the disk on which control files are located getscorruptedThe disk having active online redo log files is also corrupted.The hardware is repaired and the paths for online redo log files and control files are still valid. Whichoption would you use to perform the recovery of database till the point of failure?A. Restore the latest whole backup, perform complete recovery, and open the database normallyB. Restore the latest whole backup, perform incomplete recovery, and open the database with theRESETLOGS option.C. Restore the latest backups control file, perform complete recovery, and open the database with theRESETLOGS option.D. Restore the latest backup control file, perform incomplete recovery using backup control file, and openthe database with the RESETLOG option.Answer: D608.You are managing a 24*7 database. The backup strategy for the database is to performuser-managed backups.Identify two prerequisites to perform the backups. (Choose two.)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 backupAnswer: BC609.Examine the following commands and their output:SQL& SELECT ename, sal FROM emp WHERE ename='JAMES';ENAME SAL JAMES 1050SQL& UPDATE emp SET sal=sal+sal*1.2 WHERE ename='JAMES';1 row updated.SQL& SELECT ename, sal FROM emp WHERE ename='JAMES';ENAME SAL JAMES 2310View the exhibit and examine the Flashback Version Query that was executed after the precedingcommands.What could be the possible cause for the query not displaying any row?A. Flashback logging is not enabled for the database.B. The changes made to the table are not committed.C. Supplemental logging is not enabled for the database.D. The database is not configured in ARCHIVELOG mode.Answer: B610.Which of the following advisors is run in every maintenance window by the auto-task system?A.The Memory AdvisorB.The SQL Tuning AdvisorC.The Undo AdvisorD.The SQL Access AdvisorAnswer: B611.To accomplish user-managed backup for the USERS tablespace, you issued the following commandto put the database in backup mode:SQL& ALTER TABLESPACE users BEGIN BACKUP;While copying the file to the backup destination a power outage caused the instance to te minateabnormally.Which statement is true about the next database startup and the USERS tablespace?A. The database will open, and the tablespace automatically comes out of the backup mode.B. The database will be mounted, and recovery must be performed on the USERS tablespace.C. The database will be mounted, and data files in the USERS tablespace must be taken out of thebackup mode.D. The database will not be mounted, and you must restore all the data files for the USERS tablespacefrom the backup, and perform recovery.Answer: C612.Examine the following command used to perform incremental level 0 backup:RMAN& BACKUP INCREMENTAL LEVEL 0 DATABASE;To enable the block change tracking, after the incremental level 0 backup you issued the followingcommand:SQL& ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/mydir/rman_change_track.f';To perform incremental level 1 cumulative backup, you issued the following command:RMAN& BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;Which two statements are true in the above situation? (Choose two.)A. The block change tracking data will be used only from the next incremental 0 backup.B. The incremental backup will use change tracking data for accomplishing the backup.C. The incremental backup will not use change tracking data for accomplishing the backup.D. The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0backup.Answer: AC613.You want to use the automatic management of backup and recovery operations features for yourdatabase.Which configuration must you set?A. Enable the flash recovery area and specify it as the archived redo log destination.B. Disable the flash recovery area and start the database instance in ARCHIVELOG mode.C. Enable the flash recovery area but do not specify it as the archived redo log destination.D. Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.Answer: A614.Which three types of files can be automatically placed in the flash recovery area (fast recovery areain 11g Release 2)?(Choose three.)A. Alert log fileB. Archived redo log filesC. Control file autobackupsD. Server Parameter file (SPFILE)E. Recovery Manager (RMAN) backup pieceAnswer: BCE615.Before a Flashback Table operation, you execute the following command:ALTER TABLE employees ENABLE ROW MOVEMENT;Why would you need this to be executed?A. Because row IDs may change during the flashback operationB. Because the object number changes after the flashback operationC. Because the rows are retrieved from the recycle bin during the flashback operationD. Because the table is moved forward and back to a temporary during the flashback opertionAnswer: A616.The EMP table has some discrepancy in data entry with a particular employee ID. You execute thequery as shown in the Exhibit to retrieve all versions of the row that exist between two SCNs.View theExhibit.Which two statements about the results of the query shown in the Exhibit are correct? (Choose two.)Exhibit:A. The LAST_SCN value in the first row is NULL, which means that the versions of the row still exist atSCN 6636300.B. The LAST_SCN value in the second row in NULL, which means that the version of the row still exists atSCN 6636300.C. The LAST_SCN value in the third row is 6636280, which means that the version of row exists aboveSCN 6636280.D. The LAST_SCN value in the second row is NULL, which means that the version of the row no longerexists because it was deleted.Answer: AD617.A database instance is using an Automatic Storage Management (ASM) instance, which has a diskgroup, DGROUP1, created as follows:SQL& CREATE DISKGROUP dgroup1 NORMAL REDUNDANCYFAILGROUP 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 andimplicit rebalancing is triggered.D. The ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in theCONTROLLER2 failure group.Answer: C618.You want to set the following initialization parameters for your database instance:LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 ='LOCATION=/disk2/arch' LOG_ARCHIVE_DEST_3 = 'LOACTION=/disk3/arch'LOG_ARCHIVE_DEST_4 = 'LOCATION=/disk4/archMANDATORY'Identify the statement that correctly describes this setting.A. The MANDATORY location must be a flash recovery area.B. The optional destinations may not use the flash recovery area.C. This setting is not allowed because the first destination is not set as MANDATORY.D. The online redo log file is not allowed to be overwritten if the archived log cannot be created in thefourth destination.Answer: D619.View the Exhibit and note the contents of V$DIAG_INFO.Which statement is true about the ADR?A. The text alert log file will be available in Diag TraceB. A copy alert log file will be kept in Diag Incident for every incident.C. The XML version of the alert log file will be available in Diag Trace.D. An Automatic Database Diagnostic Management (ADDM) report is generated and stored in the HealthMonitor whenever an incident occurs.Answer: A620.You are using the control file to maintain information about the database backups that are beingperformed by Recovery Manager (RMAN).Identify two scenarios is which you must have a recovery catalog. (Choose two.)A. To store the backup information of multiple databaseB. To restrict the amount of space that is used by the backupsC. To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIMEparameter.D. To list the data files that were in a target database at a given time by using the AT option of REPORTSCHEMA command.Answer: AD621.You have enabled backup optimization for the RMAN environment. Identify two criteria on whichRMAN will skip the file, if it has already been backed up. (Choose two.)A. The data file backup is done with multiple channelsB. The data files is in the read-write mode after being backed up in the read only modeC. The backup was taken after the data files was taken offline-normal or is in the read only modeD. The data file backup complies with the back retention policy and the backup duplexing fe tureAnswer: CD622.You need to maintain a record of all transactions on some tables for at least three years.Automatic undo management is enabled for the database.What must you do accomplish this task?A. Enable supplemental logging for the database.B. Specify undo retention guarantee for the databaseC. Create Flashback Data Archive in the tablespace where the tables are stored.D. Create Flashback Data Archive and enable Flashback Data Archive for specific tablesAnswer: D623.You issued the following commands to configure setting in RMAN;RMAN& CONFIGURE DEVICE TYPE sbt PARALLELISM 1;RMAN& CONFIGURE DEFAULT DEVICE TYPE TORMAN& CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2;RMAN& CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2;RMAN& CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;Then you issued the following command to take the backup:RMAN& BACKUP DATABASE PLUS ARCHIVELOG;Which statement is true about the execution of the above command?A. The backup will terminate because the FORMAT clause was not configured for the channelB. It backs up two copies of data files to tape and disk, and two copies of archived log file on tapeC. It backs up the data files and archived log files to disk, making two copies of each data file andarchived log fileD. It backs up the data files and archived log files to tape, making two copies of each data file andarchived log fileAnswer: D624.You work with a newly created database. Presently, there is no application load on the databaseinstance. You want to create a baseline for tuning the application, so you decide to collectrecommendations that can be implemented to improve application performance.What action must you take to achieve this?A. Run Segment AdvisorB. Run the SQL Tuning Advisor (STA)C. Run the Automatic Workload Repository (AWR) reportD. Run the SQL Access Advisor with a hypothetical workloadAnswer: D625.Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in theUSERS tablespace is damaged and you need to recover the file until the point of failure. The backup forthe datafile is available.Which three files would be used in the user-managed recovery process performed by the databaseadministrator (DBA)? (Choose Three)A. Redo logsB. Control fileC. The latest backup of only the damaged data fileD. The latest backup of all the data file in the USERS tablespaceE. Temporary files of temporary tablespaceF. Archive Logs since the latest backup to point of failureAnswer: ACF626.Which options must you configure while performing an automated Tablespace Point-in-TimeRecovery (TSPITR) by using Recovery Manager (RMAN)?A. New channels for restore and recovery tasksB. New name for the data files of the tablespaceC. Auxiliary name for the data files of the tablespaceD. Auxiliary destinations for an auxiliary set of data filesAnswer: D627.In Recovery Manager (RMAN), you are taking image copies of the data files of your productiondatabase and rolling them forward at regular intervals. You attempt to restart your database. After aregular maintenance task, you realize that one of the data files that belongs to the USERS tablespace isdamaged and you need to recover the data file by using the image copy. Because a media failure causedthe 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 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 operationAnswer: C628.The database is running in the ARCHIVELOG mode. It has three redo log groups with one membereach. One of the redo log groups has become corrupted. You have issued the following command duringthe 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 recoveryAnswer: B629.Which option is best practice for creating a recovery catalog owner in the catalog database?A. Granting UNLIMITED QUOTA on the SYSTEM tablespace to the ownerB. Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to theuserC. Creating a new tablespace, allocating this as the default, and granting UNLIMITED QUOTA on thistablespace to the userD. Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on thistablespace to the userAnswer: C630.Which two statements are true about encrypting RMAN backup? (Choose two.)A. The transparent encryption of backups uses the encryption walletB. The database uses the same encryption key for every encrypted backupC. The password encryption of backups only uses the password while creating and restoring backupD. If transparent encryption is configured, you cannot use the SET ENCRYPTION BY PASSWORDcommand to make password-protected backups.Answer: AC631.View the Exhibit and examine the output of the query in different times when the following commandruns in anRMAN sessions:RMAN& BACKUP DATABASE FILESPERSET 2;The database has seven data files. Why is the %_COMPLETE refreshed to 13.59 in the third output afterreaching 88.77?Exhibit:A. Because the progress is reported for each data fileB. Because the progress is reported for each backup setC. Because other RMAN sessions have issued the same BACKUP commandD. Because new data files have been added to the database while the RMAN backup is in progressAnswer: B632.Note the following parameter settings: Which setting is NOT allowed?A. ALTER SYSTEM SET DB_CACHE_SIZE=50M;B. ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;C. ALTER SYSTEM SET DB_4K_CACHE_SIZE=10M;D. ALTER SYSTEM SET DB_16K_CACHE_SIZE=10M;Answer: B633.Which three statements must be true before transporting a tablespace from a database on oneplatform to a database on another platform? (Choose three.)A. Both source and target database must be the same character setB. Both source and target database must have the same endian formatC. The COMPATIBLE parameter must be the same in the source and target databases.D. The minimum compatibility level for both the source and target database must be 10.0.0.E. All read-only and offline data files that belong to the tablespace to be transported must be platformaware.Answer: ABD634.Your database instance is running. You are not able to access Oracle Enterprise Manager DatabaseControl because the listener is not started.Which tool or utility would you use to start the listener?A. Oracle Net ManagerB. Listener Control utilityC. Database Configuration AssistantD. Oracle Net Configuration AssistantAnswer: B635.While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed thatthe flash recovery area does not have enough free space to accommodate any more files and you do nothave necessary permissions to add more space to it.Identify the two events that can occur in the event of a log switch? (Choose two.)A. An entry is created in the alert log file and the database instance continues to function normallyB. The log switch hangs occur for transactions until free space is available in the flash recovery areaC. The Oracle database server deletes a file that is on the obsolete file list to make free space in the flashrecovery areaD. The database instance status is implicitly changed to RESTRICTED mode and file creations to theflash recovery area are preventedAnswer: BC636.Identify the persistent configuration setting for the target database that can be set for the backup byusing RMAN. (Choose all that apply.)A. Backup retention policyB. Default backup device typeC. Default destinations for backupsD. Multiple backup device types for single backupE. Default section size for backupsAnswer: ABC637.Which three statements are true about windows? (Choose three.)A. Only one window can be open at any given timeB. Consumer groups are associated with windowsC. Windows work with job classes to control resource allocationD. The database service name must be provided during windows creationE. Windows can automatically start job or change resource allocation among jobs for various timeperiods.Answer: ACE638.Which three statements are true about persistent configuration? (Choose three.)A. A user cannot set privileges on the persistent lightweight jobsB. Persistent lightweight jobs generate a large amount of metadataC. It is possible to create fully self-contained persistent lightweight jobsD. The use of a template is mandatory to create persistent lightweight jobsE. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short timeAnswer: ADE639.You want to enable automatic PGA memory management in your database. Which setting is requiredto achieve this?A. Set MEMORY_TARGET to zeroB. Set the STATISTICS_LEVEL parameter to BASICC. Set the WORKAREA_SIZE_POLICY parameter to MANUALD. Set the PGA_AGGREGATE_TARGET parameter to nonzero valueAnswer: D640.Examine the parameter setting in your database:Which statement is correct about the database?A. Automatic memory management is disabled because PGA_AGGREGATE_TARGET andSGA_TARGET are not setB. The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET andSGA_TARGET are setC. The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGETand SGA_TARGET are setD. Automatic memory management is enabled and, as per policy, 60% of the memory for System GlobalArea (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startupAnswer: D641.Which three functions are performed by the SQL Tuning Advisor? (Choose three.)A. Building the SQL profileB. Recommending optimization of materialized viewsC. Checking query objects for missing and stale statisticsD. Recommending bitmap, function-based, and B-tree indexesE. Recommending restructuring SQL queries that are using bad plansAnswer: ACE642.In your production database, users report that they are unable to generate reports on an importanttable because it does not contain any data. While investigating the reason, you realize that another userexecuted the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you wantto recover the lost data of the table without affecting objects in other schemas.Which method must you use to recover the lost data?A. Complete Recovery with online redo logB. Complete Recovery with archived redo logC. Tablespace Point-in-Time Recovery (TSPITR)D. Incomplete Recovery with system change number (SCN)Answer: C643.View the Exhibit.You are creating a database by using Database Configuration Assistant (DBCA). You have chosen theFile System option as the storage mechanism.What would be the result of choosing this option?Exhibit:A. Disk mirroring and striping would be done automaticallyB. The database files would be managed by the operating system's file systemC. DBCA would not save the database files by using Optimal File Architecture (OFA)D. The data files are automatically spread across all available storage devices to optimize performanceand resource utilizationAnswer: B644.View the Exhibit and examine the disk groups created at the time of migrating the database storageto Automatic Storage Management (ASM).Why does the FRA disk group initially have more free space even though both DATA and FRA disk groupsare provided with the same size?A. Because the FRA disk group will not support dynamic rebalancingB. Because the FRA disk group is not configured to support mirroringC. Because disks in the FRA disk group are not formatted at this stageD. Because the FRA disk group will support only a single size of allocation unitAnswer: B645.Which two statements are true about a job chain? (Choose two.)A. A job chain can contain a nested chain of jobs.B. The jobs in a job chain cannot have more than one dependency.C. A job of the CHAIN type can be run using event-based or time-based schedules.D. The jobs in a job chain can be executed only by using the events generated by the SchedulerAnswer: AC646.View the exhibit and examine the TRANS table's storage information. After a massive deleteoperation, you executed the following statement to shrink the TRANS table: SQL& ALTER TABLE transSHRINK SPACE CASCADE;Which statement describes the outcome of the command?A. An error is produced.B. The table and all related objects are compacted and the position of the high-water mark (HWM) for thetable is adjustedC. The table and related indexes are compacted but the position of the high-water mark (HWM) for thetable remains unchangedD. The unused space in the table is reclaimed and returned to the tablespace and the data manipulationlanguage (DML) triggers on the table are fired during the shrinking processAnswer: B647.You executed the following commands in a database session:What could have caused the recycle bin to clean up?A. There is demand for space from the new tableB. The undo tablespace does not have sufficient free spaceC. The new table name is the same as the table name in the recycle binD. The temporary tablespace that is assigned to you does not have sufficient free spaceAnswer: A648.Note the following statements that use flashback technology:1. FLASHBACK TABLE &table& TO SCN &scn&;2. SELECT * FROM &table& AS OF SCN 123456;3. FLASHBACK TABLE &table& TO BEFORE DROP;4. FLASHBACK DATABASE TO TIMESTAMP &timestamp&;5. SELECT * FROM &table& VERSIONS AS OF SCN 123456 AND 123999;Which of these statements will be dependent on the availability of relevant undo data in the undosegment?A. 1, 2, and 5B. 1, 3, and 4C. 2, 3, 4, and 5D. 1, 2, 3, 4, and 5Answer: A649.Examine the CREATE DISKGROUP command used to create a disk group:SQL& CREATE DISKGROUP misc EXTERNAL REDUNDANCYDISK '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) disksAnswer: C650.Which three tasks can be performed using a duplicate database? (Choose three.)A. Testing the backup and recovery proceduresB. Testing the upgrade of an Oracle database to a new releaseC. Testing the effect of an application changes on database performanceD. Continuously updating archive log files from the target database to support failoverAnswer: ABC651.The user SYS creates a job by using the following command:Which two statements are true about the job that was created by the preceding command? (Choose two.)A. The job is enabled by default after creationB. The job is automatically dropped after the end dateC. The job executes with the privileges of the user SYSD. The globalization environment that exists at the time of the job creation prevails at the job runsAnswer: BC652.Tape streaming is not happening while performing RMAN tape backup. On investigation, you find thatit is not because of the incremental backup or the empty file backup and that RMAN is sending datablocks to the tape drive fast enough.What could be a solution to make tape streaming happen during the backup?A. Configure backup optimizationB. Configure the channel to increase MAXOPENFILESC. Configure the channel to increase the capacity with the RATE parameterD. Configure the channel to adjust the tape buffer size with the BLKSIZE optionAnswer: C652.View the Exhibits: Exhibit 1 and Exhibit 2Both processes use an existing job template PROG_1. The time taken by the jobs are recorded in theTEST_LOG table. It was observed that the job creation process in exhibit 1 takes less time than in exhibit2.What is the reason for this?Exhibit:A.It creates less metadata for jobsB.It creates jobs temporarily in memory onlyC.It writes the jobs metadata to disk in compressed formatD.It updates tables in SYSTEM tablespace instead of creating new tablesAnswer: A654.You are using Recovery Manager (RMAN) with a recovery catalog to back up your productiondatabase. The backups and the archived redo log files are copied to a tape drive on a daily basis.Because of media failure, you lost your production database completely along with the recovery catalogdatabase. You want to recover the target database and make it functional. You consider performing thefollowing steps to accomplish the task:1) Restore an autobackup of the server parameter file.2) Restore the control file3) Start the target database instance4) Mount the database5) Restore the data files6) Open the database with RESETLOGS option7) Recover the data files8) Set DBID for the target databaseWhich option illustrates the correct sequence that you must use?A. 8, 1, 3, 2, 4, 5, 7, 6B. 1, 8, 3, 4, 2, 5, 7, 6C. 1, 3, 4, 2, 8, 5, 6, 7D. 1, 3, 2, 4, 6, 5, 7, 8Answer: A655.Examine the following ALTER command:SQL& ALTER DISKGROUP dgroup1 UNDROP DISKS;What is the purpose of the command?A. It cancels all pending disk drops within the disk group.B. It restores disks that are being dropped as the result of a DROP DISKGROUP operationC. It mounts disks in the disk group for which the drop-disk operation has already been co pletedD. It restores all the dropped disks in the disk group for which the drop-disk operation has already beencompletedE. It adds previously dropped disks back into the disk groupAnswer: A656.The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Whichstatement is true while performing a tape backup in an RMAN session?A. The tape I/O performed is asynchronousB. The tape buffer is allocated from the System Global Area (SGA)C. The tape buffer is allocated from the Program Global Area (PGA)D. Oracle I/O uses an interrupt mechanism to determine when each I/O completesAnswer: C657.The database is currently open and the temp03.dbf tempfile belonging to the default temporarytablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in anefficient manner?A. Allow the database to continue running, drop the TEMP tablespace, and then re-create it with newtempfilesB. Shut down the database, restore and recover the tempfile from backup, and then open the databasewith RESETLOGSC. Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile,and then create a new tempfileD. Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, anddrop the tempfile that has been corrupted.Answer: D658.Indentify two advantages of using recovery catalog instead of the control file of the database inRecovery Manager (RMAN). (Choose two.)A. You can use RMAN stored scriptsB. Recovery is faster if data is stored in catalog in addition to the control file First Test,C. You can store backup information of all registered databases in one placeD. Database backups are automatically deleted when they are older than the specified time periodAnswer: AC659.Which two commands never trigger an implicit rebalancing within the disk group?. (Choose two.)A. ALTER DISKGROUP misc MOUNT;B. ALTER DISKGROUP misc DROP DISK misc2;C. ALTER DISKGROUP misc CHECK ALL NOREPAIR;D. ALTER DISKGROUP misc RESIZE ALL SIZE 1023m;E. ALTER DISKGROUP dgroupA ADD DISK '/devices/A*';Answer: AC660.You want to configure the Flashback Database feature and retain flashback logs for three days.Presently the database is open and configured in ARCHIVELOG mode.The following steps must be performed in the correct sequence to do this:1. Set the retention target:SQL& ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320;2. Enable Flashback Database:SQL& ALTER DATABASE FLASHBACK ON;3. Mount the database:SQL& STARTUP MOUNT EXCLUSIVE4. Shutdown the instance:SQL& SHUTDOWN IMMEDIATE5. Open the database:SQL& ALTER DATABASE OPEN;Choose the correct sequence.A. 4, 1, 3, 2, 5B. 4, 3, 1, 2, 5C. 2, 4, 3, 5, 1D. 4, 2, 5, 3, 1Answer: B661.View the Exhibit and examine the output. You execute the following RMAN command to perform thebackup operation:RMAN& RUN { ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8;BACKUP DATABASE FILESPERSET 4; }What is the multiplexing level in the preceding backup process?A. 4B. 8C. 7D. 0Answer: A662.To enable faster incremental backups, you enabled block change tracking for the database. Whichtwo statements are true about the block change tracking file? (Choose two.)A. Multiple change tracking files can be created for a database.B. The change tracking file must be created after the first level 0 backup.C. RMAN does not support backup and recovery of the change tracking file.D. The database clears the change tracking file and starts tracking changes again, after whole databaserestore and recovery operations.Answer: CD663.Which options would you consider while configuring a flash recovery area (fast recovery area in 11gRelease 2) for your production database that is running in ARCHIVELOG mode? (Choose all that apply.)A. Setting the FAST_START_MTTR_TARGET to set the mean time to recoverB. Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUsC. Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery areaD. Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for therecovery files created in the flash recovery areaAnswer: CD664.You want to take a complete database backup using RMAN. The backup should consist only the usedblocks from your database.Which two statements are true about this backup operation? (Choose two.)A. Backup compression should be enabledB. Parallelism for the channel should be set to 2C. All the files must be backed up as backup setsD. The backup may be stored either on disk or on media with media managerAnswer: CD665.Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)A. The ADR base keeps all diagnostic information in binary formatB. SQL*Plus provides the ADRI script, which can be used to work with ADRC. The ADR can be used for problem diagnosis only when the database is openD. The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to nullE. The ADR can be used for problem diagnosis even when the database instance is downF. The ADR base is shared across multiple instancesAnswer: EF666.You are working in an online transaction processing (OLTP) environment. You use theFLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACKTABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERStable, you realize that the table is not in the correct state. Now, you need to reverse the effects of theFLASHBACK TABLE command. Which is the fastest and the most efficient option to reverse the effects ofthe FLASHBACK TABLE command?A. Restore the backup control file and open the database with RESETLOGS option.B. Perform point-in-time recovery because flashback cannot be performed again on this tableC. Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN663571D. Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN663571Answer: D667.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 redologsB. An upper limit on how far you can flash back the database, depending on the information in the undotablespaceC. The amount of time for which the flashback data is to be kept in the flash recovery area, provided thatthere is enough spaceD. The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace,provided that there is enough spaceAnswer: C668.Examine the following RMAN script:RMAN& run {allocate channel c1backup datafile 5;}Which statement describes the purpose of the script?A. The data file is checked for physical corruption and backed up if found clean.B. The backup of data file 5 is performed and the interactive messages during the backup aresuppressed.C. The existing backup for the data file is checked and the backup is performed if there are changes in thedata file after the last backup.D. The backup of data file 5 is performed and all SQL statements that are executed during RMANcompilation and their results are displayedAnswer: D669.User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA,which commands must you execute to enable SCOTT to flash back the transactions? (Choose four.)A. ALTER DATABASE FLASHBACK ON;B. GRANT SELECT any transaction TOC. GRANT EXECUTE ON dbms_flashback TOD. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;E. ALTER TABLESPACE undots1 RETENTION GUARANTEE;F. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;Answer: BCDF670.After you have restored and recovered a database to a new host by using a previously performedRecovery Manager (RMAN) backup, which is the best option you would consider for the new database?A. Opening the database in RESTRICTED modeB. Opening the database with the RESETLOGS optionC. Setting a new DBID for the newly restored databaseD. Restoring the server parameter file (SPFILE) to the new hostAnswer: B671.Examine the following RMAN command:RMAN& CONFIGURE ENCRYPTION FOR DATABASE ON;RMAN& BACKUP DATABASE PLUS ARCHIVELOG;Which prerequisite must be met before accomplishing the backup?A. Provide a password for the encryptionB. Set up an Oracle wallet for the encryptionC. No setup is required as it is a default encryption methodD. Both Oracle wallet and password must be set up for the encryptionAnswer: B672.You are in the process of creating a Virtual Private Catalog (VPC) in your Oracle Database 11gdatabase. The Prod1, Prod2 and Prod3 Oracle Database 10g databases are registered in the recoverycatalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executesthe following command to grant privileges to a new user VPC1 using Oracle Database 11g RMANexecutables:RMAN& GRANT CATALOG FOR DATABASE prod 1 prod 2 TO vpc1;Then you issue thRMAN & CONNECT CATALOG vpc1/oracle@RMAN& SQL XEC catowner.dbms_rcvcat.create virtual_?What is the outcome of the above commands?A. They execute and a create a virtual private catalog for pre-Oracle 11g clientsB. They produce an error because PROD1 and PROD 2 databases belong to the older versionC. They produce an error because you must connect as CATOWNER to execute this packaged procedureD. They produce an error because you must connect to the target database to execute this packagedprocedureAnswer: A673.In Recovery Manager (RMAN), you are taking image copies of the datafiles of your productiondatabase and rolling them forward as regular intervals. You attempt to restart your database instance aftera regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace isdamaged and you need to recover the datafile by using the image copy. You could perform the followingsteps to accomplish this:1) Mount the database2) Take the data file offline3) Bring the data file online4) Use the RMAN SWITCH TO command to switch the image copy5) Apply the archived redo logs6) Open the database7) Use the RMAN RESTORE TO command to switch to the image copyWhich two options illustrate the correct sequence of steps that you could follow? (Choose two.)A. 2, 6, 4, 5, 3B. 1, 2, 4, 5, 3, 6C. 1, 2, 4, 6, 3D. 1, 2, 7, 5, 3, 6Answer: BD674.View the Exhibit to observe the error.You receive this error regularly and have to shutdown the database instance to overcome the error.Automatic Shared Memory Management is configured for the instance. What can you do to reduce thechance of this error in the future?A. Increase the value of SGA_MAX_SIZEB. Enable automatic memory managementC. Set the PRE_PAGE_SGA parameter to trueD. Lock the System Global Area (SGA) in memoryAnswer: B675.Which two client requests are captured during database replay Capture? (Choose two)A. Flashback queriesB. Shared server requestsC. Login and logoff activities of sessionsD. Direct path load of data from external files by using utilities such as SQL *loaderE. Data definition language (DDL) and data manipulation language (DML) operationsAnswer: CE676.Which command creates an image copy?A. backup as copyB. backup copyC. copy as backupD. copy backAnswer: A677.What are the prerequisites for performing flashback transactions? (Choose all that apply)A.Supplemental log must be enabledB.Supplemental log must be enabled for the primary keyC.Undo retention guarantee for the database must be configuredD. EXECUTE permission on the DBMS_FLASHBACK package must be granted to the userAnswer: ABD678.Which are the two prerequisites before setting up Flashback Data Archive? (Choose two.)A.Flash recovery area must be definedB.Undo retention guarantee must be enabled.C.Database must be running in archivelog mode.D.Automatic undo management must be enabled.E.The tablespace in which the Flashback Data Archive is created must have automatic segment spaceManagement (ASSM).Answer: DE679.Which mode of database shutdown requires an instance recovery at the time of the next databasestartup?A.ABORTB.NORMALC.IMMEDIATED.TRANSACTIONALAnswer: A680.Which two operations are NOT performed by the DUPLICATE command in Recovery Manager(RMAN) while duplicating a running database? (Choose Two)A.Creating the control file for the duplicate databaseB.Restoring the target data files to the duplicate databaseC.Performing complete recovery using all available backupsD.Generating a new, unique DBID for the duplicate databaseE.Copying the online redo log files from the target database to the duplicate databaseAnswer: CE
阅读(...) 评论()