[多选] 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.

View the Exhibit to examine the details for an incident. Which statement is true regarding the status of theincident（） The DBA is working on the incident and prefers that the incident be kept in the ADR.。 The incident is now in the Done state and the ADR can select the incident to be purged.。 The incident has been newly created and is in the process of collecting diagnostic information.。 The data collection for the incident is complete and the incident can be packaged and sent to OracleSupport。三相异步电机铭牌中注有定额一项代表（）。转子每分钟转数。电动机输出功率。电动机运行方式。施肥技术要点 Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement？（） NLS_LANG。 NLS_COMP。 NLS_SORT。 None of the above。 You have included the following parameter setting in your server parameter file： PGA_AGGREGATE_TARGET = 800M SORT_AREA_SIZE = 100M HASH_AREA_SIZE = 100M BITMAP_MERGE_AREA_SIZE = 100M CREATE_BITMAP_AREA_SIZE = 100M Which statement is true？（） All the *_AREA_SIZE parameters are ignored.。 The Automatic PGA Memory Management feature cannot be disabled.。 The total Program Global Area （PGA） memory cannot be manually increased above 800M.。 The total memory for the PGA can automatically exceed 800M using the Automatic PGA Memory Management feature.。 Which two statements about subqueries are true? （）

参考答案：

● 参考解析

本题暂无解析

当前位置：1Z0-007题库

[多选] Which two statements about subqueries are true? （）

相关题目: