ITPub博客

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

430.Which of the following is a prerequisite for running DBMS_TDB.CHECK_DB to a successfulcompletion?A. The database must be in read-write mode.B. The database must have no external files.C. The database must open in read-only mode.D. The database must be mounted but not opened.Answer: C这个...

138.You are working on the APPDB database as a DBA. The database has a default Flashback DataArchive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1:DROP FLASHBACK ARCHIVE fla1;What is the effect of this command?A. The Flashback Archive FLA1 is dropped on...

344.In what view are you likely to see the following output?SID SERIAL# EVENT SECONDS_IN_WAIT121 269 RMAN backup & recovery I/O 2129 415 SQL*Net message from client 63 130 270 SQL*Net message from clientA. V$SESSION_EVENTB. V$SESSIONC. V$WAITSD. V$WAITSTATE. V$SYSSTATAnswer: BSQL> select...

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

447.Which of the following calendaring syntax expressions would evaluate to the last day of every month?A. FREQ = MONTHLY; BYMONTHDAY = 31B. FREQ = MONTHLY; BYMONTHDAY = -1C. FREQ = DAILY; BYDAY = -1D. FREQ = MONTHLY; BYDAY = 31E. FREQ = DAILY; BYMONTHDAY = LAST_DAYAnswer: B记住last day of e...

78.You enable block change tracking. You issue the following command:BACKUP INCREMENTAL LEVEL 0 DATABASE;The next day, you issue the following command:BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;Which statement about the use of the change tracking file is true?A. RMAN reads the block change ...

84.View the Exhibit and examine the Data Pump architecture.Identify the numbered components.A. 1 - Oracle Loader, 2 - Oracle Data Pump, 3 - Direct Path APIB. 1 - Oracle Data Pump, 2 - Direct Path API, 3 - Oracle LoaderC. 1 - Direct Path API, 2 - Oracle Loader, 3 - Oracle Data PumpD. 1 - Oracl...

462.Which view shows all valid values for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY, andNLS_CHARACTERSET parameters?A. V$VALID_NLS_VALUESB. NLS_VALID_VALUESC. NLS_VALUE_OPTIONSD. V$NLS_VALUE_OPTIONSE. V$NLS_VALID_VALUESAnswer: ESELECT *　FROM v$nls_valid_values

83.Which three actions are required to configure the Flashback Database? (Choose three.)A. set Flash Recovery AreaB. enable Flashback loggingC. create FLASHBACK tablespaceD. start the database in the ARCHIVELOG modeE. start the database in the NOARCHIVELOG modeAnswer: ABDC选项， 是FLASHBACK ...

435.Every resource plan must contain an allocation to which consumer group?A. LOW_GROUPB. SYS_GROUPC. DEFAULT_GROUPD. BASE_GROUPE. OTHER_GROUPSAnswer: E参考：http://docs.oracle.com/cd/E11882_01/server.112/e25494/dbrm.htm#ADMIN11842       http://blog.csdn.net/rlhua/articl...

43.View the following SQL statements:Transaction T1 INSERT INTO hr.regions VALUES (5,'Pole');COMMIT;Transaction T2 UPDATE hr.regions SET region_name='Poles' WHERE region_id = 5; COMMIT;Transaction T3 UPDATE hr.regions SET region_name='North and South Poles' WHERE region_id = 5;You want to back o...