ITPub博客

251.You are working on a CATDB database that contains an Oracle Database version 11.1 catalogschema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1catalog schema owned by the user RCAT10.You want the RMAN to import metadata for database IDs 1423241 and 1423242...

327.You have a database with the following tablespaces: SYSTEM, SYSAUX, UNDO, USERS, TEMP.You want to"roll back" the data in the USERS tablespace to the way it looked yesterday. Whichtablespaces do you need to perform a point-in-time restore operation on in order to complete this task?(Choose all...

448.Which of the following tasks is not performed by the job coordinator?A. Update job log when a job completesB. Spawn and remove job slavesC. Write/read job info to/from memory cacheD. Query job tableE. Pass job information to job slavesAnswer: Ahttp://docs.oracle.com/cd/E18283_01/server.1...

598.The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter should be set to what value?(Choose all that apply.)A. The initialization parameter should be set to 0 when the RMAN repository is being used.B. The initialization parameter should be set to greater than 0 with the RMAN repository uti...

282.You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLEinitialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for thedisk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1.Which two statements are true in th...

471.Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR?A. All objects in the databaseB. Tables owned by SYS and SYSTEMC. Data dictionary tablesD. NCHAR columnsE. CHAR columnsAnswer: Ehttp://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams127.htm#REFRN1012...

232.What recommendations does the SQL Access Advisor provide for optimizing SQL queries? (Chooseall that apply.)A. selection of SQL plan baselinesB. partitioning of tables and indexesC. creation of index-organized tablesD. creation of bitmap, function-based, and B-tree indexesE. optimization o...

24.Which of the following information will be gathered by the SQL Test Case Builder for the problemspertaining to SQL-related problems? (Choose all that apply.)A. ADR diagnostic filesB. all the optimizer statisticsC. initialization parameter settingsD. PL/SQL functions, procedures, and packages...

682. Identify the scenarios in which the RMAN CROSSCHECR command is useful. (Choose all thatapply.)A.To check that the obsolete backups are deleted from the repository records and from the disk.B.To update the RMAN repository if you delete archived redo logs with operating system commands.C.To u...

2.You plan to have a larger moving window size for the default system-defined moving window baselinebecause you want to use the adaptive threshold.Which statement factors in this consideration while increasing the size of the moving window.?A. The collection level for the AWR should be set to BAS...

502.A database is running In ARCHIVBXXMS mode. It has two online redo log groups and each grouphas one member.A LGWR Input/output (I/O) fells due to permanent media failure that has resulted In the loss of redo logfile and the LWGR terminates causing the instance to crash. The steps to recover fr...

620.You are using the control file to maintain information about the database backups that are beingperformed by Recovery Manager (RMAN).Identify two scenarios is which you must have a recovery catalog. (Choose two.)A. To store the backup information of multiple databaseB. To restrict the amount...

368.When issuing the duplicate database command, you use the parameterDB_FILE_NAME_CONVERT. For what purpose do you use this parameter?A. To indicate the location of the auxiliary-instance online redo logs.B. To indicate the location of the target database datafiles.C. To indicate the location o...

240.You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks.One of the disks in the disk group becomes unavailable because of power failure. You issued thefollowing command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours:ALTER DISKGROUP dg...

14.Which two statements are true regarding hot patching? (Choose two.)A. It requires relinking of the Oracle binary.B. It does not require database instance shutdown.C. It can detect conflicts between two online patches.D. It is available for installing all patches on all platforms.E. It works ...

543.As the DBA, you run the following query on your ASM instance.What is the implication of the results of the query? (Choose two.)SQL> select group_number, name, state from v$ASM_DISKGROUP;GROUP_NUMBER NAME STATE0 DGROUP1 DISMOUNTED2 DGROUP2 MOUNTED3 DGROUP3 MOUNTEDA. The DGROUP1 disk group ...

530.When an ASM instance receives a SHUTDOWN NORMAL command, what command does it passon to all database instances that rely on the ASM instances disk groups?A. TRANSACTIONALB. IMMEDIATEC. ABORTD. NORMALAnswer: NONEhttp://blog.csdn.net/rlhua/article/details/13008005注：有连接的RDBMS 实例...

660.You want to configure the Flashback Database feature and retain flashback logs for three days.Presently the database is open and configured in ARCHIVELOG mode.The following steps must be performed in the correct sequence to do this:1. Set the retention target:SQL> ALTER SYSTEM SET DB_FLASHBA...

477.Which of the following is not a valid linguistic sort element?A. Accent expansionB. Canonical equivalenceC. Reverse secondary sortingD. Ignorable charactersE. Character rearrangementAnswer: Ahttp://docs.oracle.com/cd/E11882_01/server.112/e10729/ch5lingsort.htm#NLSPG276Linguistic Sort...

477.Which of the following is not a valid linguistic sort element?A. Accent expansionB. Canonical equivalenceC. Reverse secondary sortingD. Ignorable charactersE. Character rearrangementAnswer: Ahttp://docs.oracle.com/cd/E11882_01/server.112/e10729/ch5lingsort.htm#NLSPG276Linguistic Sort...