ITPub博客

650.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 ...

387.Which method could be utilized to identify both DML operations and the SQL statements needed toundo those operations for a specific schema owner? (Choose all that apply.)A. Query DBA_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL. Limit rowsby START_SCN and TABLE_OWNER.B. Query FL...

402.While querying the EMPLOYEES table, you receive an ORA-01578 message indicating blockcorruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified. WhichRMAN command do you use to perform BMR and repair the corrupt block?A. RECOVER FILE=1201 BLOCK=1968;B. REC...

298.While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statementthat has stale statistics available.What would the optimizer do in this situation?A. It updates the existing SQL profiles with current statistics.B. It makes the statistics information availab...

182.Which of the following files cannot be backed up by RMAN? (Choose all that apply.)A. Database datafilesB. Control filesC. Online redo logsD. Database pfilesE. Archived redo logsAnswer: CDpfile是个文本文件，不需要通过RMAN备份

427.When exporting metadata for the transportable tablespaces, what is the correct next step afterconfirming endian format?A. Export the tablespaces using data pump.B. Determine if the transportable set is self-contained.C. Convert the datafiles using RMAN.D. Copy the datafiles from source to d...

444.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. NULLAnswer: Bjob创建时，默认是disabled

541.If you use ALTER DISKGROUP ... ADD DISK and specify a wildcard for the discovery string, whathappens to disks that are already a part of the same or another disk group?A. The command fails unless you specify the FORCE option.B. The command fails unless you specify the REUSE option.C. The com...

342.How long will this backup be allowed to run?Backup as compressed backupset duration 2:00 minimize load database ;A. 2 minutesB. 2 hoursC. 2 daysD. The command will generate an error.E. This backup is not constrained by any time limitation.Answer: B格式是HH:MM，而不是MM:SS...

613.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 AR...

134.You are managing an Oracle Database 11g database. You want to take a backup on tape drives ofthe USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. Toaccomplish the backup, you issued the following RMAN command:RMAN>BACKUPSECTION SIZE 300MTABLESPACE...

33.You want to perform the following operations for the DATA ASM disk group:-Verify the consistency of the disk.-Cross-check all the file extent maps and allocation tables for consistency. heck whether the aliasmetadata directory and file directory are linked correctly.-Check that ASM metadata d...

587.Compressed backups work with which of the following commands?A. copy as backupB. backup as copyC. backupD. copyAnswer: Cimage copy不能压缩。Full database backups should usually be either image copies or compressed backup sets. Image copies are more flexible than backup sets for some pu...

219.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, 1...

684. Your database is running in ARCHIVELOG mode. You have been taking backups of all the data filesand control files regularly.You are informed that some important tables in the BILLING tablespace have been dropped on February28, 2007 at 10.30 AM and must be recovered.You decide to perform an i...

108.You are managing an Oracle Database 11g instance with ASM storage. You lost an ASM disk groupDATA. You have RMAN backup of data as well as ASM metadata backup. You want to re-create themissing disk group by using the ASMCMD md_restore command. Which of these methods would you useto achieve th...

558.Which view provides information on the backup status of the datafiles in the database?A. V$BACKUPB. V$BACKUP_STATUSC. V$BACKUP_DATAFILED. V$DATAFILE_BACKUPE. V$TABLESPCE_BACKUPAnswer: A注意输出：SQL> select * from v$backup  2  /     FILE# STATUS   &nbs...

559.Another DBA issues a shutdown abort command on a database on which you were running an onlinebackup. What will happen when you try to restart the database?A. Oracle will automatically take the datafile out of hot backup mode, generate a warning message, andthen open the database.B. Oracle wi...

79.You executed the following command:RMAN> RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf';Which statement regarding the above command is correct?A. The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copy.B. The '/u01/app/oracle/oradata/orcl...

554.Which is not a valid way of backing up a control file?A. Backing up the control file to traceB. Copying the existing control file of the database to the backup location during a hot backupC. Copying the existing control file of the database to the backup location during a cold backupD. Creat...