ITPub博客

324.Your database is up and running and one of your three control files is accidentally erased. You startRMAN and run the following command:RESTORE CONTROLFILE FROM AUTOBACKUP;Which of the following statements is true? (Choose all that apply.)A. The command restores only the missing control file...

299.In your database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YESand the users who need to access the database as DBAs have been granted SYSDBA enterprise role inOracle Internet Directory (OID). SSL and the password file have been configured. A user SCOTT with theSYSDB...

286.The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo logfiles are stored on three locations. The Flash Recovery Area is one of the locations. The details are givenbelow:LOG_ARCHIVE_DEST_1 = 'LOCATION = /disk1/archive' LOG_ARCHIVE_DEST_2 = 'SERVICE = stdb1'DB_...

563.How many individual archive-log destination directories are supported by Oracle Database11g?A. 7B. 1C. 10D. 11E. 21Answer: Clog_archive_dest_n, 这里是N，只能是1到10。所以，只能支持10个不同的archive-log destinationLOG_ARCHIVE_DEST_nwhere:n is an integer from 1 to 10参考：h...

413.Which of the following Oracle features is enabled by setting a nonzero value for theMEMORY_TARGET initialization parameter?A. Automatic PGA Memory ManagementB. Automatic SGA Memory ManagementC. Automatic Shared Memory ManagementD. Automatic Memory ManagementE. Manual SGA Memory Management...

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