ITPub博客

48.View the Exhibit to examine the error obtained during the I/O calibration process. There are no datafiles on raw devices. What is the reason for this error?A. The DISK_ASYNCH_IO parameter is set to TRUE.B. The FILESYSTEMIO_OPTIONS parameter is set to NONE.C. Another session runs the I/O cali...

223.You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a movingwindow baseline. Which action would you take before performing this task?A. Compute the baseline statistics.B. Take an immediate AWR snapshot.C. Decrease the window size for the baseline.D. Dec...

374.Which of the following statements are true regarding the Recycle Bin? (Choose all that apply.)A. The Recycle Bin is a physical storage area for dropped objects.B. The Recycle Bin is a logical container for dropped objects.C. The Recycle Bin stores the results of a Flashback Drop operation.D....

347.What does the output on this report indicate?RMAN> report need backup;RMAN retention policy will be applied to the commandRMAN retention policy is set to redundancy 1Report of files with less than 1 redundant backupsFile #bkps Name5 0 C:\ORACLE\ORADATA\ORCL\MY_DATA_01.DBFA. The my_data_01...

201.Examine the following PL/SQL block:SET SERVEROUTPUT ON SET LONG 10000 DECLARE   report clob;BEGIN report := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE();  DBMS_OUTPUT.PUT_LINE(report);END;Which statement describes the effect of the execution of the above PL/SQL block?A. ...

258.Which two statements are true regarding the SQL Repair Advisor? (Choose two.)A. The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.B. The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statementcrash.C. The SQL Repa...

633.Which three statements must be true before transporting a tablespace from a database on oneplatform to a database on another platform? (Choose three.)A. Both source and target database must be the same character setB. Both source and target database must have the same endian formatC. The COM...

454.If a job references a schedule that has been disabled, what will be the result?A. The job will be automatically disabled.B. The job will never execute.C. The job will attempt to execute but will fail.D. The job will inherit the DEFAULT_SCHEDULE schedule.E. A schedule object cannot be disabl...

520.Which of the following are not disabled by default?A. JobsB. ChainsC. WindowsD. Window groupsE. ScheduleAnswer: E

217.Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in amultiprocessor environment. At the end of the upgrade, you observe that the DBA executes the followingscript:SQL> @utlrp.sqlWhat is the significance of executing this script?A. It performs paral...

259.Which setting enables the baselines by default in Oracle Database 11g?A. setting the STATISTICS_LEVEL parameter to TYPICALB. adding filters to the Automatic Database Diagnostic Monitor (ADDM)C. enabling Automated Maintenance Task using Oracle Enterprise ManagerD. setting the OPTIMIZER_USE_PE...

384.Which of the following statements is true regarding the VERSIONS BETWEEN clause?A. The VERSIONS BETWEEN clause may be used in DML statements.B. The VERSIONS BETWEEN clause may be used in DDL statements.C. The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.D. The ...

252.Which three are the valid statements in relation to SQL plan baselines? (Choose three.)A. The plans can be manually loaded to the SQL plan baseline.B. The plans in the SQL plan baseline are verified and accepted plans.C. The plans generated for every SQL statement are stored in the SQL plan b...

566.You have lost all your SYSTEM tablespace datafiles (system_01.dbf and system_02.dbf) nd thedatabase has crashed.What would be the appropriate order of operations to correct the situation?A. Mount the database with the startup mount command.B. Take the SYSTEM datafile offline with the alter d...

445.To set the history retention period for either window logging or job logging individually, whichparameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used? (Choose all that apply.)A. LOG_HISTORYB. JOB_LOG_RETENTIONC. WINDOW_LOG_RETENTIOND. WHICH_LOGE. LOG_NAMEAnswer: AD

307.You have created a script in the recovery catalog called backup_database. Which of the followingcommands would successfully execute that script?A. run { open script backup_database; run script backup_database }B. run { engage script backup_database; }C. run { run script backup_database; }D....

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

115.What are the advantages of variable extent size support for large ASM files? (Choose two.)A. It improves resync operations when the disk comes online after being taken offline for maintenancepurposes.B. It improves performance in the extended cluster configuration by reading from a local copy...

510.You executed the following command in Recovery Manager (RMAN):RMAN> REPORT NEED BACKUP days 3;What is the output of this command?A. a list of files that require a backup within three daysB. a list of files requiring more than 3 days of archive logs to applyC. a list of files that RMAN recom...

137.Your company wants to upgrade the current production database to the RAC environment. Toperform testing before migrating to the RAC environment, you performed the workload capture on theproduction database to record the peak workload. You set up the test RAC database and want to replaythe rec...