网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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
参考答案
参考解析
解析：
暂无解析
更多 “单选题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” 相关考题
考题
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.
考题
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.
考题
Which statement is true regarding Backup tasks in Cisco UCS？（）A、 They are created automatically and stored on the FIB、 They are created manually and exported to a remote serverC、 They are automatically scheduled to run every 24 hoursD、 They are manually scheduled and stored on the FI
考题
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.
考题
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 trafficC、The forwarding plane contains the Packet Forwarding Engine (PFE)D、The forwarding plane is not present on all platforms running the Junos OS
考题
Which statement is true regarding syslog on Junos devices?（）A、No logging is enabled by defaultB、By default the information is stored in all file named eventsC、Only the message severity level must be configuredD、You can configure the router to send log messages to the console
考题
Identify the true statement regarding Temporary Coherence cluster members（）A、 it should have "localstorage" set to TRUEB、 it should be configured so as to not trigger re-partitioning C、 both A and B are TRUED、 Neither A and B are TRUE
考题
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 clauseD、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
考题
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
考题
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.
考题
单选题Evaluate the following statement： Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement？（）A
They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.B
They are evaluated by the first WHEN clause. If the condition is true， then the row would be evaluated by the subsequent WHEN clauses.C
They are evaluated by the first WHEN clause. If the condition is false， then the row would be evaluated by the subsequent WHEN clauses.D
The INSERT statement would give an error because the ELSE clause is not present for support in case none of the WHEN clauses are true.
考题
单选题Which of the following statement（s）is/are TRUE regarding a twin pedestal crane set（）.A
The cranes may be operated independentlyB
The cranes may be interconnected for twin operationC
When twinned，the crane rotation on the foundation assembly is unlimitedD
All of the above
考题
单选题Which statement regarding the contents of the V$PARAMETER view is true？（）A
displays only the list of default valuesB
displays only the list of all basic parametersC
displays the currently in effect parameter valuesD
displays only the list of all advanced parametersE
displays the list of all the parameter files of a database
考题
单选题Which statement is true regarding NAT?（）A
NAT is not supported on SRX Series devices.B
NAT requires special hardware on SRX Series devices.C
NAT is processed in the control plane.D
NAT is processed in the data plane.
考题
多选题Which two statements are true regarding working with dates?（）AThe default internal storage of dates is in the numeric formatBThe default internal storage of dates is in the character formatCThe RR date format automatically calculates the century from the SYSDATE function and does not allow the user to enter the centuryDThe RR date format automatically calculates the century from the SYSDATE function but allows the user to enter the century if required
考题
单选题Regarding zone types， which statement is true？（）A
You cannot assign an interface to a functional zone.B
You can specifiy a functional zone in a security policy.C
Security zones must have a scheduler applied.D
You can use a security zone for traffic destined for the device itself.
考题
单选题Which statement is true regarding syslog on Junos devices?（）A
No logging is enabled by default.B
By default, the information is stored in a 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.
考题
单选题Which statement is true regarding syslog on Junos devices?（）A
No logging is enabled by defaultB
By default the information is stored in all file named eventsC
Only the message severity level must be configuredD
You can configure the router to send log messages to the console
考题
单选题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.
考题
单选题Which statement is true regarding synonyms?（）A
Synonyms can be created only for a table B
Synonyms are used to reference only those tables that are owned by another user C
A public synonym and a private synonym can exist with the same name for the same table D
The DROP SYNONYM statement removes the synonym, and the table on which the synonym has been created becomes invalid
考题
单选题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.
考题
单选题Evaluate the following function code： CREATE FUNCTION get_dept_avg（dept_id NUMBER） RETURN NUMBER RESULT_CACHE RELIES_ON （EMPLOYEES） IS avgsal NUMBER（6）； BEGIN SELECT AVG（SALARY）INTO avgsal FROM EMPLOYEES WHERE DEPARTMENT_ID = dept_id； RETURN avgsal； END get_dept_avg； 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.
热门标签
最新试卷
