Which two statements are true regarding the execution of the correlated sub-queries?Choose two.()
A: The nested query executes after the outer query returns the row.
B: The nested query executes first and then the outer query executes
C: The outer query executes only once for the result returned by the inner query.
D: Each row returned by the outer query is evaluated for the results returned by the inner query
A: The nested query executes after the outer query returns the row.
B: The nested query executes first and then the outer query executes
C: The outer query executes only once for the result returned by the inner query.
D: Each row returned by the outer query is evaluated for the results returned by the inner query
举一反三
- The following () does not belong to the operation query. A: Parameter query B: Generate table query C: Update query D: Delete query
- In Access2016, the data source of the query can be (). A: Table B: Query C: Table, query and report D: Table and query
- Methods to query content-based video include ____________________, ____________________, ____________________, ____________________, ____________________ and Concept query (query by keyword).
- 在命令窗口输入()命令可以建立查询。 A: MODIFY QUERY B: EDIT QUERY C: CREATE QUERY D: TYPE QUERY
- SQL的含义是哪个? A: Standard query language B: structured query language C: speedy query language D: super query language