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

Which statements are true regarding the Query Result Cache？（

题目
多选题
Which statements are true regarding the Query Result Cache？（）
A

It can be set at the system， session， or table level.

B

It is used only across statements in the same session.

C

It can store the results from normal as well as flashback queries.

D

It can store the results of queries based on normal，temporary，and dictionary tables.

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

第1题：

Which statements are true regarding the Query Result Cache? ()

A. It can be set at the system, session, or table level.

B. It is used only across statements in the same session.

C. It can store the results from normal as well as flashback queries.

D. It can store the results of queries based on normal, temporary, and dictionary tables.


参考答案：A, C

第2题：

Which of the following statements is true regarding the VERSIONS BETWEEN clause？（）  

  • A、 The VERSIONS BETWEEN clause may be used in DML statements.
  • B、 The VERSIONS BETWEEN clause may be used in DDL statements.
  • C、 The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.
  • D、 The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.

正确答案:C

第3题：

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

第4题：

Which of the following statements is true about L3 cache？（）

  • A、L3 cache operates faster than the system processor.
  • B、L3 cache runs at the speed of the processor.
  • C、L3 cache can deliver data in as little as 15ns.
  • D、L3 cache runs at the speed of the system bus.

正确答案:D

第5题：

Which three statements are true regarding subqueries?（）

  • A、Subqueries can contain GROUP BY and ORDER BY clauses 
  • B、Main query and subquery can get data from different tables 
  • C、Main query and subquery must get data from the same tables 
  • D、Subqueries can contain ORDER BY but not the GROUP BY clause 
  • E、Only one column or expression can be compared between the main query and subquery
  • F、 Multiple columns or expressions can be compared between the main query and subquery

正确答案:A,B,E

第6题：

Which of the following statements is true about L3 cache?（）

  • A、L3 cache operates faster than the system processor
  • B、L3 cache runs at the speed of the processor.
  • C、L3 cache can deliver data in as little as 15ns.
  • D、L3 cache runs at the speed of the system bus.

正确答案:B

第7题：

Which statement is true regarding the INTERSECT operator?（）

  • A、It ignores NULL values 
  • B、Reversing the order of the intersected tables alters the result 
  • C、The names of columns in all SELECT statements must be identical 
  • D、The number of columns and data types must be identical for all SELECT statements in the query 

正确答案:D

第8题：

Evaluate the following function code:Which statement is true regarding the above function? ()

A. The cached result becomes invalid when any structural change is done to the EMPLOYEES table.

B. If the function execution results in an unhandled exception, the exception result is also stored in the cache.

C. Each time the function is invoked in a different session, the current result in the result cache gets overwritten.

D. If the function is invoked with a different parameter value, the existing result in the result cache gets overwritten by the latest value.


参考答案：A

第9题：

Which of the following statements is true about L1 cache？（）

  • A、 L1 cache operates faster than the processor.
  • B、 L1 cache is directly connected to the processor.
  • C、 L1 cache can deliver data in 5ns.
  • D、 L1 cache is located on the system board.

正确答案:B

第10题：

Which two statements are true regarding L2TP? （）(Choose two.)

  • A、Tunnels are initiated by the LAC
  • B、Tunnels are initiated by the LNS
  • C、By default, subscriber authentication occurs on the LNS
  • D、By default, subscriber authentication occurs on the LAC

正确答案:A,C

更多相关问题
相关内容