ITPub博客

Oracle RAC 概览

（410）Which of these recommendations should be followed before capturing a workload?(Choose all that apply.)A. Make sure your replay database has the same structure as the capture database,except without data.B. Make sure the replay and capture databases are similar in data content.C. Pe...

（409）Which of the following represents the correct sequence of events for Database Replay?A. Capture,analyze,preprocess,replayB. Capture,preprocess,analyze,replayC. Capture,preprocess,replay,analyzeD. Analyze,capture,preprocess,replayE. None of the above答案：（C）解析：...

（408）Which statement most accurately describes the implementation of a SQL Access Advisor recommendation?A. SQL Access Advisor recommendations are automatically implemented.B. Individual SQL Access Advisor recommendations can be scheduled for implementation.C. All SQL Access Advisor rec...

（407）Which of the following is a potential performance tuning recommendation from the SQL Access Advisor?A. Create new indexes.B. Modify existing indexes.C. Implement partitioning on a nonpartitioned table.D. Create materialized views.E.All of the above答案：（E）解析：...

（406）Which of these appropriately describes the results of a manual SQL Tuning Advisor task?A. A list of SQL statements and recommendations for tuningB. A list of SQL statements that have been tuned by the Advisor,with before and after metricsC. Graphs showing the actual performance imp...

（405）To view the results of a manual SQL Tuning Advisor task,which steps should the DBA take?A. From the Advisor Central home page,select the tuning task from the Advisor Tasks section.B. From Advisor Central,choose SQL Advisors,SQL Tuning Advisors,Manual Tuning Task Results.C. From Adv...

（404）When creating a SQL tuning set,which of the following steps allows the DBA to reduce the size of the SQL set by selecting specific operators and values?A. Filter versionsB. Filter loadsC. Filter tasksD. Filter options答案：（D）

（402）While querying the EMPLOYEES table,you receive an ORA-01578 message indicating block corruption in File#1201 and Block#1968.You analyze the table and the corruption is verified.Which RMAN command do you use to perform BMR and repair the corrupt block?（choose two)A. RECOVER FILE=12...

(401)Which of the following are correct about block media recovery?(Choose all that apply.)A. Physical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_CORRUPTION.B. Logical corruptions are repairable by BMR.C. Physical corruptions are repairable by BMR.D. RM...

（400）Which of the following methods can be used to detect block corruption?A. ANALYZE operationsB. dbvC. SQL queries that access the potentially corrupt blockD. RMANE. All of the above答案：（E）解析：《Backup and recovery user’s guid》 16.1.2.4...

（399）Which of the following is not an advantage of block media recovery(BMR)?A. Reduced MTTR.B. Datafiles remain offline while corrupt blocks are repaired.C. Datafiles remain online while corrupt blocks are repaired.D. A and C答案：（B）解析：《Backup and recovery user...

（398）Choose the correct order to package and upload data for an incident to Oracle Support.A. Schedule,create new package,view manifest,view contentsB. Create new package,view manifest,view contents,scheduleC. Schedule,create new package,view contents,view manifestD. Create new pack...

（397）Which of the following tasks does the tool Incident Packaging Service(IPS) perform?A. Cleans up the ADR by deleting files not associated with an incident uploaded to Oracle Support.B. Identifies all files associated with a critical error and adds them to a zip file to be sent to Oracle...

（396）Which of the following are not fundamental tasks of the Support Workbench?(Choose all that apply.)A. View long-running SQL workloadsB. View problem detailsC. Gather additional diagnostic informationD. Create a Service RequestE. Clean up incident data after upload to Oracle ...

（395）Which of these formats represents the correct hierarchy for the ADR?A. <diagnostic_dest>/rdbms/diag/<dbname>/<instname>B. <diagnostic_dest>/diag/rdbms/<instname>/<dbname>C. <diagnostic_dest>/diag/rdbms/<dbname>/<instname>D. None of the above答案：（C）解析： ...

（394）Which of the following statements is true regarding the initialization parameter DIAGNOSTIC_DEST?A. The default value is the value of the environment variable$ORACLE_HOME;if$ORACLE_HOME isn't set,then the default is set to$ORACLE_BASE.B. The default value is the value of the environmen...

（393）Which of the following initialization parameters have been deprecated in Oracle 11g because of the introduction of the Automatic Workload Repository?(Choose all that apply.)A. BACKGROUND_DUMP_DESTB. FOREGROUND_DUMP_DESTC. CORE_DUMP_DESTD. USER_DUMP_DESTE. DIAGNOSTIC_DEST...

（392）To clean up old records that are in a Flashback Data Archive and are past the retention period,what must the DBA do?A. TRUNCATE the archive table.B. DROP the Flashback Data Archive.C. Nothing;expired rows are automatically removed.D. Nothing;expired rows are moved to an archive...