ITPub博客

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

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

287.Evaluate the following command:SQL> CREATE TABLE design_data (id NUMBER,doc CLOB) LOB(doc) STORE AS SECUREFILE(DEDUPLICATE);Which statement is true regarding the above command?A. The LOB values are automatically compressed.B. The LOB values are cached by default in the buffer cache.C....

507.Your database is running In ARCIIIVELOG mode. One of the data files, USBRDATAOI. DBF, in theusers tablespace is damaged and you need to recover the file until the point of failure. The backup for thedata file is available.Which three files would be used in the user-managed recovery process pe...

30.Which two statements are true with respect to the maintenance window? (Choose two.)A. A DBA can enable or disable an individual task in all maintenance windows.B. A DBA cannot change the duration of the maintenance window after it is created.C. In case of a long maintenance window, all Automat...

289.You are managing the APPPROD database as a DBA which is not using the Oracle-managed files.You plan to duplicate this database in the same system with the name DUPDB.You want to create thesame directory structure for duplicate database files as of the target database.You executed the followin...