违法和不良信息举报 联系客服
免费注册 登录

Identify the two direct sources from where SQL plans can be 

题目
多选题
Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.（）
A

Cursor cache

B

Stored outline

C

SQL Tuning Set

D

Automatic Workload Repository （AWR） snapshots

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Which two client requests are captured during database replay Capture?() (Choose two)

A. Flashback queries

B. Shared server requests

C. Login and logoff activities of sessions

D. Direct path load of data from external files by using utilities such as SQL *loader

E. Data definition language (DDL) and data manipulation language (DML) operations


参考答案：C, E

第2题：

有SQL语句 SELECT * FROM 教师 WHERE NOT(工资＞30000R工资＜2000) 与如上语句等价的SQL语句是

A．SELECT * FROM 教师 WHERE 工资 BETWEEN 2000 AND 3000

B．SELECT * FROM 教师 WHERE 工资＞2000 AND工资＜3000

C．SELECT * FROM 教师 WHERE 工资＞2000 OR工资＜3000

D．SELECT * FROM 教师 WHERE 工资＜=2000 AND工资＞=3000


正确答案：A
解析：本题中SQL语句查询的是工资小于等于3000且大于等于2000的职工记录，与SQL中特殊运算符BETWEEN．．． EDN．．．等价，意思是在“…和…之间”。

第3题：

标准SQL基本查询模块的结构是A）SELECT…FROM…ORDER BYB）SELECT…WHERE…GROUP BYC）SELECT…WHERE…HAVINGD）SELECT…FROM…WHERE


正确答案：D
使用SQL进行查询的基本查询模块结构是：
SELECT<字段名> FROM<数据表名> WHERE<查询条件>，
故选项D为正确答案。

第4题：

While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences?（）

  • A、The plan baselines can be evolved over time to produce better performance.
  • B、The newly generated plans are directly placed into the SQL plan baseline without being verified.
  • C、The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.
  • D、The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.

正确答案:A,C

第5题：

Which two statements about subqueries are true? （）

  • A、A single row subquery can retrieve data from only one table.
  • B、A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.
  • C、A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.
  • D、A single row subquery can retrieve data from more than one table.
  • E、A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.
  • F、A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.

正确答案:B,D

第6题：

有SQL语句：SELECT * FROM 教师 WHERE NOT(工资>3000 OR 工资<2000)与如下语句等价的SQL语句是A）SELECT*FROM 教师 WHERE 工资 BETWEEN 2000 AND 3000B) SELECT*FROM 教师 WHERE 工资>2000 AND 工资<3000C）SELECT*FROM 教师 WHERE 工资>2000 OR 工资<3000D) SELECT*FROM 教师 WHERE 工资<=2000 AND 工资>3000


正确答案：A
BETWEEN…AND…是SQL中比较特殊的函数，经常与SQL联合使用用来设定查询条件，这个函数所设定的查询条件是值在某个范围内，并且包含边界取值，题目中WHERER所设定的条件是NOT(工资>3000 AND工资<2000),其含义不是在小于2000或大于3000的范围内，这恰好是在2000到3000之间，选项A使用BETWEEN ... AND...设定查询条件，与此条件实现的功能一致。故选项A为正确答案。选项B表示工资大于2000并且小于3000，选项C表示工资大于2000或者工资小于3000,选项D表示工资小于等于2000并且大于等于3000。

第7题：

Which two statements about configuration an unconnected Catalyst Express 500 switch from setup mode using a PC are true？（）

  • A、You may use Cisco Network Assistant to set up the initial configuration
  • B、You must use CLI for initial configuration
  • C、You may use either CLI or CAN for configuration
  • D、You may make a direct connection to the PC from any point on the switch
  • E、You may only make a direct connection from the port with the flashing green LED to the PC

正确答案:A,E

第8题：

Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.()

A. Cursor cache

B. Stored outline

C. SQL Tuning Set

D. Automatic Workload Repository (AWR) snapshots


参考答案：A, C

第9题：

Which three are the valid statements in relation to SQL plan baselines?（）

  • 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 plans generated for every SQL statement are stored in the SQL plan baseline by default.
  • D、The plan baselines are stored temporarily in the memory as long as the database instance is running.
  • E、  For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online.

正确答案:A,B,E

第10题：

Which two are true regarding direct-path exports？（）

  • A、Direct-path export is typically faster.
  • B、Direct-path export can be invoked interactively.
  • C、Direct-path export is character set independent.
  • D、Direct-path export bypasses the SQL-command processing layer.
  • E、Direct-path export can be used to export rows containing LOBs and BFILEs.

正确答案:A,D

更多相关问题
相关内容