OCP 11G認(rèn)證考試章節(jié)練習(xí)(2019.05.02)

來源：考試資料網(wǎng)

1 Which statement about Automatic Memory Management with Oracle 11g is true?（）

2 You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process?（）

點(diǎn)擊查看答案

3 You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level?（）

點(diǎn)擊查看答案

4 In which cases is reference partitioning effective in enhancing performance?（）

點(diǎn)擊查看答案

5 Which DBMS_SCHEDULER procedure(s) can be used to alter an existing job? （）

點(diǎn)擊查看答案

6 View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) tasks.

Which statement describes the consequence?（）

點(diǎn)擊查看答案

7 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?（）

點(diǎn)擊查看答案

8 Which of the following datatypes store time-zone information in the database?（）

點(diǎn)擊查看答案

9 Which two client requests are captured during database replay Capture?（）

點(diǎn)擊查看答案

10 You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.
Which statement about the result is true?（）

點(diǎn)擊查看答案

<del id="gy22m"></del>