ITPub博客

（260）Which two activities are NOT supported by the Data Recovery Advisor? (Choose two.)A. Diagnose and repair a data file corruption offline.B. Diagnose and repair a data file corruption online.C. Diagnose and repair failures on a standby database.D. Recover from failures in the Rea...

（259）Which setting enables the baselines by default in Oracle Database 11g?  A. setting the STATISTICS_LEVEL parameter to TYPICAL  B. adding filters to the Automatic Database Diagnostic Monitor (ADDM)  C. enabling Automated Maintenance Task using Oracle Ent...

（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 statement crash.C. T...

（257）Which client requests to the database can be captured as a part of the workload capture? (Choose all that apply.)   A. flashback query                        &n...

（256）Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily.To save disk space, you issued the following command:ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS;What would be the outcome of this command?A. It pr...

（255）Which two statements about the SQL Management Base (SMB) are true? (Choose two.)A. It contains only SQL profiles generated by SQL Tuning Advisor.B. It stores plans generated by the optimizer using a stored outline.C. It is part of the data dictionary and stored in the SYSAUX tables...

（254）Which three statements correctly describe the features of the I/O calibration process? (Choose three.)  A. Only one I/O calibration process can run at a time.B. It automates the resource allocation for the Automated Maintenance Tasks.C. It improves the performa...

（253）You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline.The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile.Which statement is true when you accept the suggested SQL profile?A. The tuned ...

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

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

（250）You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation.The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system.How would you create these jobs?A...

（249）Evaluate the following command and its output:SQL>SELECT * FROM dba_temp_free_space;TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACELMTEMP                       &...

（248）（题目不完整）You want the ability to recovery any time within the last seven days and therefore you configured the recovery window retention policy using the command:RMAN> CONFIGURE RETENTION POLICY TO RECOVFRY WINDOW OF 7 DAYS;After configuring the recovery window, you performed the ...

（247）Which two statements about Oracle Direct Network File System (NFS) are true? (Choose two.)A. It bypasses the OS file system cache.B. A separate NFS interface is required for use across Linux, UNIX, and Windows platforms.C. It uses the operating system kernel NFS layer for user task...

（246）The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE.The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline.Which two operations are performed by the optimizer in this scenario? (Choose two.)A. The optimizer adds the new p...

（245）Which statements are true regarding system-partitioned tables? (Choose all that apply.)A. Only a single partitioning key column can be specified.B. All DML statements must use partition-extended syntax.C. The same physical attributes must be specified for each partition.D. Uniq...

（244）Which two statements are true regarding the starting of the database instance using the following command? (Choose two.)SQL>STARTUP UPGRADEA. It enables all system triggers.B. It allows only SYSDBA connections.C. It ensures that all job queues remain active during the upgrade p...

（243）Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)A. failures because a data file is renamed by errorB. failures when no standby database is configuredC. failures that require no archive logs to be applied for recoveryD. ...