You work in a data warehouse environment that involves the execution of complex queries. The current content of the SQL cache holds the ideal workload for analysis. You want to analyze only few most resource-intensive statements. What would be your suggestion to receive recommendations on the efficient use of indexes and materialized views to improve query performance？（）

A、Run the SQL Access Advisor.

B、Run the SQL Tuning Advisor （STA）.

C、Run the Automatic Workload Repository （AWR） report.

D、Run the Automatic Database Diagnostic Monitor （ADDM）.

下面哪个属性肯定不是框架控件的属性（　　）。

A、Text

B、Caption

C、Left

D、Enabled

You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure， the instance has shut down before synchronizing all the database files. Which two statements are true？（）

On startup， SMON coordinates instance recovery.

On startup， CKPT coordinates instance recovery.

On startup， use RMAN to perform instance recovery.

Uncommitted changes will be rolled back after the database is opened.

On startup， perform media recovery and then instance recovery.

On startup， all the files will be synchronized and you get both committed and uncommitted data.

Which three statements are true regarding the logical structure of the Oracle database？（）

Each segment contains one or more extents.

Multiple tablespaces can share single data file.

A data block is the smallest unit of I/O for data files.

It is possible to have tablespaces of different block sizes in a database.

Each data block in the database always corresponds to one OS block.

Which of the following is STP BEST identified by under the cable sheath？（）

A、Number of twists in wires

B、Number of wires

C、Lubricant

D、Foil

Which of the following is the MOST common pin-out configuration used when crimping RJ-45 connectors？（）

A、UTP

B、T568A/B

C、STP

D、IEEE 802.5