ITPub博客

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

143.Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)A. Database must be running in archivelog mode.B. Automatic undo management must be enabled.C. Undo retention guarantee must be enabled.D. The tablespace on which the Flashback Data Archive is created must be mana...

9.Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedurefor LOB space usage?A. It returns space usage of only BasicFile LOB chunks.B. It returns space usage of only SecureFile LOB chunks.C. It returns both BasicFile and SecureFile LOB space usage for only nonp...

121.Which three statements are true regarding the functioning of the Autotask Background Process(ABP)? (Choose three.)A. It creates jobs without considering the priorities associated with them.B. It translates tasks into jobs for execution by the scheduler.C. It determines the list of jobs that ...

610.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: B参考：http://blog.itpub.net/17013648/viewspace-1326757/三种自动任务：SQL> select operation_name fro...