ITPub博客

594.Which of the following most closely represents an image copy?A. Unix cp command of a fileB. Bit-by-bit copy of a fileC. Windows COPY command of a fileD. All of the aboveAnswer: D

257.Which client requests to the database can be captured as a part of the workload capture? (Choose allthat apply.)A. flashback queryB. distributed transactionsC. logging in and logging out of sessionsD. all DDL statements having bind variablesE. direct path load of data from external filesA...

695. Identify two options that Oracle recommends while configuring the backup and recovery environmentfor your recovery catalog. (Choose two.)A. configuring control file autobackup to be ONB. backing up data filed only and not the archived redo log filesC. running the recovery catalog database i...

312.Which is the correct way to connect to both the target database and the recovery catalog from theRMAN command line? Assume that the target database is called ORCL and that the recovery catalogdatabase is called RCAT. Also assume that the recovery-catalog owner is called RCAT_OWN. Assumethe en...

692. Your company wants to upgrade the production database to a Real Application Clusters (RAC)environment. You set up the best RAC database and want to replay a recorded workload captured fromthe production database on the test machine.The following steps may be used to replay the database workl...

239.Evaluate the following command:SQL>ALTER SYSTEM SET db_securefile = 'IGNORE';What is the impact of this setting on the usage of SecureFiles?A. It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOB.B. It forces SecureFiles to be created even if the BA...

241.You issued the following RMAN command to back up the database:RMAN> RUN{ALLOCATE CHANNEL c1 DEVICE TYPE sbtBACKUP DATABASETAG quarterlyKEEP FOREVERRESTORE POINT FY06Q4;}Which two statements are true regarding the backup performed? (Choose two.)A. Archived redo log files are backed up alo...

476.What is the name of the file that identifies the set of available locale definitions?A. locale.defB. lxdef.oraC. lx1boot.nlbD. lx1boot.oraE. lang.defAnswer: C

705. View Exhibit1 to examine the DATA disk group when all the disks are online.Why is the rebalancing not performed and the content of the disk group not empty in Exhibit2?A.Because the disk group is created with NORMAL redundancyB.Because the disk repair time attribute is set to a nonzero valu...

166.Exhibit:View the Exhibit and examine the output.You executed the following command to enable Flashback Data Archive on the EXCHANGE_RATE table:ALTER TABLE exchange_rate FLASHBACK ARCHIVE;What is the outcome of this command?A. The Flashback Archive is created on the same tablespace where th...

478.Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.(Choose two.)A. Cursor cacheB. Stored outlineC. SQL Tuning SetD. Automatic Workload Repository (AWR) snapshotsAnswer: AChttps://docs.oracle.com/cd/E11882_01/server.112/e41573/optplanmgmt.htm#PF...

88.In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. Youexecuted the following commands to configure the settings in RMAN:Which statement is true about the outcome?A. Only one channel is allocated and the backup is created in the flash recovery areaB...

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