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

Which of the following cannot be used as input to the SQL Tu

题目
多选题
Which of the following cannot be used as input to the SQL Tuning Advisor?（） (Choose all that apply.)
A

A single SQL statement provided by a user

B

An existing SQL Tuning Set (STS)

C

A preprocessed Database Replay workload

D

A schema name

E

SQL statement identified in EM as using excessive resources

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

第1题：

Which two are attributes of ／SQL*Plus? ()

A. /SQL*Plus commands cannot be abbreviated.

B. /SQL*Plus commands are accesses from a browser.

C. /SQL*Plus commands are used to manipulate data in tables.

D. /SQL*Plus commands manipulate table definitions in the database.

E. /SQL*Plus is the Oracle proprietary interface for executing SQL statements.


参考答案：C, D

第2题：

Which of the following is the proper pronunciation of"have to" as a result of assimilation?

A．/hef tu/
B．/hey tu/
C．/hаef tu/
D．/hаev tu/

答案：C
解析：
考查读音的同化。have to在发音过程中出现了同化现象，即have和to作为相邻词使用时。／v／受后面清辅音/t/的影响变成与自己对应的清辅音/f/，于是读音变为／haef tu／。

第3题：

Evaluate the following SQL statement used to create the PRODUCTS table:Which statement is true regarding this command?()

A. It executes successfully but partition pruning cannot happen for this partition key.

B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key.

C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key.

D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.


参考答案：D

第4题：

Which of the following cannot be used as input to the SQL Tuning Advisor?（） (Choose all that apply.)

  • A、A single SQL statement provided by a user
  • B、An existing SQL Tuning Set (STS)
  • C、A preprocessed Database Replay workload
  • D、A schema name
  • E、SQL statement identified in EM as using excessive resources

正确答案:C,D

第5题：

A system administrator is attempting to unmount filesystem /dev/data and receives the following message：   umount： 0506-349 Cannot unmount /dev/data： The requested resource is busy.   Which of the following commands can be used to determine which process has open references within the filesystem？（）

  • A、lsfs
  • B、topas
  • C、fuser
  • D、mount

正确答案:C

第6题：

When a teacher intends to introduce a new grammar item, which of the following strategies can be used to get students to notice it?

A．Transformation
B．Input enhancement
C．Expansion
D．Substitution

答案：B
解析：
考查语法教学。B项表示输入强化，有利于引导学生加强对语法点的注意。其余三项适用于语法练习与巩固环节。

第7题：

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

第8题：

Which of the following cannot be used as input to the SQL Tuning Advisor?() (Choose all that apply.)

A. A single SQL statement provided by a user

B. An existing SQL Tuning Set (STS)

C. A preprocessed Database Replay workload

D. A schema name

E. SQL statement identified in EM as using excessive resources


参考答案：C, D

第9题：

Which two statements regarding a SQL profile are true？（）

  • A、 It is built by Automatic Tuning Optimizer.
  • B、 It cannot be stored persistently in the data dictionary.
  • C、 It can be used by the query optimizer automatically.
  • D、 It can be created manually by using the CREATE PROFILE command.

正确答案:A,C

第10题：

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 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 an INSERT statement to insert multiple rows at a time.

正确答案:D,F

更多相关问题
相关内容