The LIKE operator cannot be used with single-row subqueries
The NOT IN operator is equivalent to IS NULL with single-row subqueries
=ANY and =ALL operators have the same functionality in multiple-row subqueries
The NOT operator can be used with IN, ANY, and ALL operators in multiple-row subqueries
第1题:
Which statement is true regarding syslog on Junos devices?()
第2题:
Which two statements are true regarding the ORDER BY clause? ()
第3题:
Which two statements about subqueries are true? ()
第4题:
They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.
They are evaluated by the first WHEN clause. If the condition is true, then the row would be evaluated by the subsequent WHEN clauses.
They are evaluated by the first WHEN clause. If the condition is false, then the row would be evaluated by the subsequent WHEN clauses.
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.
第5题:
displays only the list of default values
displays only the list of all basic parameters
displays the currently in effect parameter values
displays only the list of all advanced parameters
displays the list of all the parameter files of a database
第6题:
You cannot assign an interface to a functional zone.
You can specifiy a functional zone in a security policy.
Security zones must have a scheduler applied.
You can use a security zone for traffic destined for the device itself.
第7题:
No logging is enabled by default
By default the information is stored in all file named events
Only the message severity level must be configured
You can configure the router to send log messages to the console
第8题:
Synonyms can be created only for a table
Synonyms are used to reference only those tables that are owned by another user
A public synonym and a private synonym can exist with the same name for the same table
The DROP SYNONYM statement removes the synonym, and the table on which the synonym has been created becomes invalid
第9题:
It returns versions of rows only within a transaction.
It can be used in subqueries contained only in a SELECT statement.
It will return an error if the undo retention time is less than the lower bound time or SCN specified.
It retrieves all versions including the deleted as well as subsequently reinserted versions of the rows.
第10题:
A subquery can retrieve zero or more rows
Only two subqueries can be placed atone level
A subquery can be used only in SQL query statements
A subquery can appear on either side of a comparison operator
There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement
第11题:
Identify the true statement regarding Temporary Coherence cluster members()
第12题:
Which statement is true regarding Flashback Version Query? ()
第13题:
Which statement is true regarding subqueries?()
第14题:
The cranes may be operated independently
The cranes may be interconnected for twin operation
When twinned,the crane rotation on the foundation assembly is unlimited
All of the above
第15题:
NAT is not supported on SRX Series devices.
NAT requires special hardware on SRX Series devices.
NAT is processed in the control plane.
NAT is processed in the data plane.
第16题:
No logging is enabled by default.
By default, the information is stored in a file named events.
Only the message severity level must be configured.
You can configure the router to send log messages to the console.
第17题:
There are five phases of IKE negotiation.
There are two phases of IKE negotiation.
IPsec VPN tunnels are not supported on SRX Series devices.
IPsec VPNs require a tunnel PIC in SRX Series devices.
第18题:
Asinglerowsubquerycanretrieveonlyonecolumnandonerow.
Asinglerowsubquerycanretrieveonlyonerowbutmanycolumns.
Amultiplerowsubquerycanretrievemultiplerowsandmultiplecolumns.
Amultiplerowsubquerycanbecomparedusingthe;>;;operator.
AsinglerowsubquerycanusetheINoperator.
Amultiplerowsubquerycanusethe;=;operator.
第19题:
Subqueries can contain GROUP BY and ORDER BY clauses
Main query and subquery can get data from different tables
Main query and subquery must get data from the same tables
Subqueries can contain ORDER BY but not the GROUP BY clause
Only one column or expression can be compared between the main query and subquery
Multiple columns or expressions can be compared between the main query and subquery