Which two statements are true regarding subqueries? ()

题目
多选题
Which two statements are true regarding subqueries? ()
A

A subquery can retrieve zero or more rows

B

Only two subqueries can be placed atone level

C

A subquery can be used only in SQL query statements

D

A subquery can appear on either side of a comparison operator

E

There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement

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

第1题:

Which two statements regarding firewall user authentication client groups are true?() (Choose two.)

  • A、A client group is a list of clients associated with a group.
  • B、A client group is a list of groups associated with a client.
  • C、Client groups are referenced in security policy in the same manner in which individual clients are referenced.
  • D、Client groups are used to simplify configuration by enabling firewall user authentication without security policy.

正确答案:B,C

第2题:

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

第3题:

Which two statements regarding symmetric key encryption are true?() (Choose two.)

A. The same key is used for encryption and decryption.

B. It is commonly used to create digital certificate signatures.

C. It uses two keys: one for encryption and a different key for decryption.

D. An attacker can decrypt data if the attacker captures the key used for encryption.


参考答案:A, D

第4题:

Which two statements are TRUE regarding Coherence Indexes ? ()

  • A、 indexes are maintained by cache entry ownes
  • B、 an application should not suggest an index that another aplication had suggested
  • C、 indexes cannot be sorted
  • D、 each application using Coherence may suggest the same set of indexes when it starts

正确答案:A,D

第5题:

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

第6题:

Which two statements are true regarding the role of the Routing Engine (RE)?()

  • A、The RE controls and monitors the chassis.
  • B、The RE manages the Packet Forwarding Engine (PFE).
  • C、The RE receives a copy of the forwarding table from the forwarding plane.
  • D、The RE implements class of service (COS).

正确答案:A,B

第7题:

Which two statements are true regarding high-availability chassis clustering?()

  • A、A chassis cluster consists of two devices.
  • B、A chassis cluster consists of two or more devices.
  • C、Devices participating in a chassis cluster can be different models.
  • D、Devices participating in a chassis cluster must be the same models

正确答案:A,D

第8题:

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

第9题:

Which two statements regarding asymmetric key encryption are true?()

  • A、The same key is used for encryption and decryption.
  • B、It is commonly used to create digital certificate signatures.
  • C、It uses two keys: one for encryption and a different key for decryption.
  • D、An attacker can decrypt data if the attacker captures the key used for encryption

正确答案:A,B

第10题:

Which two statements are true regarding subqueries? ()

  • A、A subquery can retrieve zero or more rows 
  • B、Only two subqueries can be placed atone level 
  • C、A subquery can be used only in SQL query statements 
  • D、A subquery can appear on either side of a comparison operator 
  • E、There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement 

正确答案:A,D

更多相关问题