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

Which statement is true regarding the COALESCE function?（）

题目
单选题
Which statement is true regarding the COALESCE function?（）
A

It can have a maximum of five expressions in a list 

B

It returns the highest NOT NULL value in the list for all rows 

C

It requires that all expressions in the list must be of the same data type 

D

It requires that at least one of the expressions in the list must have a NOT NULL value

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

第1题：

Which statement is true regarding Backup tasks in Cisco UCS？（）

  • A、 They are created automatically and stored on the FI
  • B、 They are created manually and exported to a remote server
  • C、 They are automatically scheduled to run every 24 hours
  • D、 They are manually scheduled and stored on the FI

正确答案:B

第2题：

Which statement is true regarding the forwarding plane?（）

  • A、The forwarding plane is contained within the Routing Engine (RE)
  • B、The forwarding plane processes and evaluates exception traffic
  • C、The forwarding plane contains the Packet Forwarding Engine (PFE)
  • D、The forwarding plane is not present on all platforms running the Junos OS

正确答案:C

第3题：

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

第4题：

Which statement is true regarding the COALESCE function?（）

  • A、It can have a maximum of five expressions in a list 
  • B、It returns the highest NOT NULL value in the list for all rows 
  • C、It requires that all expressions in the list must be of the same data type 
  • D、It requires that at least one of the expressions in the list must have a NOT NULL value

正确答案:C

第5题：

Identify the true statement regarding Temporary Coherence cluster members（）

  • A、 it should have "localstorage" set to TRUE
  • B、 it should be configured so as to not trigger re-partitioning 
  • C、 both A and B are TRUE
  • D、 Neither A and B are TRUE

正确答案:B

第6题：

Which statement is true of Cisco Monitor Director (CMD)?（）

  • A、CMD provides a weekly reporting facility.
  • B、CMD allows monitoring of up to 100 SMBs.
  • C、CMD provides network management at a Cisco partner location.
  • D、CMD is an SNMP alarm-based monitoring function.

正确答案:C

第7题：

Which statement is true regarding syslog on Junos devices?（）

  • A、No logging is enabled by default
  • B、By default the information is stored in all file named events
  • C、Only the message severity level must be configured
  • D、You can configure the router to send log messages to the console

正确答案:D

第8题：

Which statement is true regarding IPsec VPNs?()

A. There are five phases of IKE negotiation.

B. There are two phases of IKE negotiation.

C. IPsec VPN tunnels are not supported on SRX Series devices.

D. IPsec VPNs require a tunnel PIC in SRX Series devices.


参考答案：D

第9题：

Which two statements are true regarding the ORDER BY clause? （）

  • A、It is executed first in the query execution 
  • B、It must be the last clause in the SELECT statement 
  • C、It cannot be used in a SELECT statement containing a HAVING clause
  • D、You cannot specify a column name followed by an expression in this clause 
  • E、You can specify a combination of numeric positions and column names in this clause

正确答案:B,E

第10题：

Which statement is true regarding Flashback Version Query？ （）

  • A、 It returns versions of rows only within a transaction.
  • B、 It can be used in subqueries contained only in a SELECT statement.
  • C、 It will return an error if the undo retention time is less than the lower bound time or SCN specified.
  • D、 It retrieves all versions including the deleted as well as subsequently reinserted versions of the rows.

正确答案:D

更多相关问题
相关内容