[多项选择]Which two statements about subqueries are true?（）
A. A single row subquery can retrieve data from only one table.
B. A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.
C. A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.
D. A single row subquery can retrieve data from more than one table.
E. A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.
F. A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.

更多"Which two statements about subqueri"的相关试题:

[多项选择]Which two statements about subqueries are true? （）
A. A subquery should retrieve only one row.
B. A subquery can retrieve zero or more rows.
C. A subquery can be used only in SQL query statements.
D. Subqueries CANNOT be nested by more than two levels.
E. A subquery CANNOT be used in an SQL query statement that uses group functions.
F. When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.

查看答案

[多项选择]Which three statements about subqueries are true? （）
A. A main query can have more than one subquery.
B. A subquery can have more than one main query.
C. The subquery and main query must retrieve data from the same table.
D. The subquery and main query can retrieve data from different tables.
E. Only one column or expression can be compared between the subquery and main query.
F. Multiple columns or expression can be compared between the subquery and main query.

查看答案

[多项选择]Which two statements are true about precedence values in policy?（） (Choose two.)
A. 1 is the default precedence.
B. A lower number is preferred.
C. A higher number is preferred.
D. 100 is the default precedence.

查看答案

[多项选择]Which two statements are true about the duplexing of the backups taken by RMAN? （）(Choose two.)
A. It's only supported for the backups performed on the tape
B. It is not supported for backup operations that produce image copies
C. Duplex backups need a parallelism for the device to be equal to number of copies
D. Duplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously

查看答案

[多项选择]Which two statements are true about static routes in the Junos OS?（）
A. Static routes are defined at the [edit routing-instances] hierarchy.
B. Static routes must have a next hop defined.
C. Static routes remain in the routing table until you remove them or until they become inactive.
D. Static routes are learned by neighboring devices and added to their routing tables.

查看答案

[多项选择]Which two statements are true about the forwarding table?（）
A. The forwarding table lists each source protocol and preference for each destination.
B. The forwarding table contains only active routes.
C. The forwarding table is used to process transit packets.
D. The forwarding table is stored in compact flash

查看答案

我来回答:

提交