多选题Which two statements about the SQL Management Base (SMB) are true? （）(Choose two.)AIt contains only SQL profiles generated by SQL Tuning Advisor.BIt stores plans generated by the optimizer using a stored outline.CIt is part of the data dictionary and s

Traffic is clear text

Traffic is encrypted 

They are initiated by the LNS

They are initiated by the LAC

OEM can do management and monitoring across multiple WLS Domains

OE is a unified solution for management and monitoring across entire architecture - Web Tier， App Tier & DB Tier

OEM is focused solely on Oracle solutions， cannot manage 3rd party products

OEM includes tools to configure the operating system

Only 20% of decision makers understand UC solutions.

They are generally well-educated on what UC solutions offer.

Many are yet to be convinced of the need for UC.

They have a tendency to support current telephony vendors.

The ADR base keeps all diagnostic information in binary format

SQL*Plus provides the ADRI script, which can be used to work with ADR

The ADR can be used for problem diagnosis only when the database is open

The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null

The ADR can be used for problem diagnosis even when the database instance is down

The ADR base is shared across multiple instances

Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.

Capture the plans from the previous version using STS and then load them into the stored outline.

Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB).

Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.

The bigfile tablespace have only one data file.

The segment space management is automatic.

The extent management is dictionary managed.

The database can have only one bigfile tablespace.

The bigfile tablespace can be converted to a smallfile tablespace.

 Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.

 Capture the plans from the previous version using STS and then load them into the stored outline.

 Capture the plans from the previous version using STS and then load them into SQL Management Base （SMB）

 Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.

It contains only SQL profiles generated by SQL Tuning Advisor.

It stores plans generated by the optimizer using a stored outline.

It is part of the data dictionary and stored in the SYSAUX tablespace.

It is part of the data dictionary and stored in the SYSTEM tablespace.

It contains the statement log, the plan history, plan baselines, and SQL profiles.

the WCS Base version includes all the features of the WCS Location version as well as additional enhancements

the WCS Base version provides on-demand location of rogue access points and clients to within 33 feet （10 meters）

WCS adds a graphical view of multiple Cisco Wireless LAN controllers and managed access points

WCS includes a network management tool which is similar to a site survey tool

WCS uses the CDP protocol to communicate with the controllers

it provides enhanced visibility across the entire application infrastructure

it provides a set of management tools that enable automation of configuraion

it significantly increases the performance of Web-based applications with no code change

it dramatically reduces costs associated with diagnostics， configuration， and deployment on production servers

Shared SQL Area will be allocated in the shared pool.

Shared SQL Area will be allocated when a session starts.

Shared SQL Area will be allocated in the large pool always.

Private SQL Area will be allocated in the Program Global Area （PGA） always.

Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool.

The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.

The ADR base keeps all diagnostic information in binary format

SQL*Plus provides the ADRI script, which can be used to work with ADR

The ADR can be used for problem diagnosis only when the database is open

The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null

The ADR can be used for problem diagnosis even when the database instance is down

The ADR base is shared across multiple instances

A subquery should retrieve only one row.

A subquery can retrieve zero or more rows.

A subquery can be used only in SQL query statements.

Subqueries CANNOT be nested by more than two levels.

A subquery CANNOT be used in an SQL query statement that uses group functions.

When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.

The two statements produce identical results.

The second statement returns a syntax error.

There is no need to specify DESC because the results are sorted in descending order by default.

The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.