多选题Which two statements are true regarding single row functions?（）AThey accept only a single argumentBThey can be nested only to two levelsCArguments can only be column values or constantsDThey always return a single result row for every row of a queried 

第1题：

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.

第2题：

Which two are true about aggregate functions? （）

• A、You can use aggregate functions in any clause of a SELECT statement.
• B、You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.
• C、You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.
• D、You can pass column names, expressions, constants, or functions as parameter to an aggregate function.
• E、You can use aggregate functions on a table, only by grouping the whole table as one single group.
• F、You cannot group the rows of a table by more than one column while using aggregate functions.

第3题：

Choose the two correct statements regarding Oracle WebLogic Server（）

• A、 a server instance can be associated with multiple machines
• B、 a machine can be associated with multiple server instance 
• C、 a server instance can be associated with only a single machine 
• D、 a machine can be associated with only one server instance

第4题：

Which two statements are true regarding listeners（）

• A、Listeners use only the TCP/IP protocol.
• B、Multiple listener processes can run simultaneously on a host.
• C、Multiple database instances can be registered with a single listener.
• D、The listener-related errors can be traced only at the administrative level.
• E、Only one database instance can be registered with a single listener at any time.

第5题：

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.

第6题：

Which three statements about subqueries are true?（）

• A、A single row subquery can retrieve only one column and one row.
• B、A single row subquery can retrieve only one row but many columns.
• C、A multiple row subquery can retrieve multiple rows and multiple columns.
• D、A multiple row subquery can be compared by using the ">" operator.
• E、A single row subquery can use the IN operator.
• F、A multiple row subquery can use the "=" operator.

第7题：

Which two statements are true regarding hot patching？（）

• A、 It requires relinking of the Oracle binary.
• B、 It does not require database instance shutdown.
• C、 It can detect conflicts between two online patches.
• D、 It is available for installing all patches on all platforms. 
• E、 It works only in a single database instance environment.

第8题：

Which  statements are true regarding listeners（）

• A、Listeners use only the TCP/IP protocol.
• B、Multiple listener processes can run simultaneously on a host.
• C、Multiple database instances can be registered with a single listener.
• D、The listener-related errors can be traced only at the administrative level.
• E、Only one database instance can be registered with a single listener at any time

第9题：

Which three statements are true regarding single-row functions？（）

• A、 They can accept only one argument.
• B、 They can be nested up to only two levels.
• C、 They can return multiple values of more than one data type.
• D、 They can be used in SELECT， WHERE， and ORDER BY clauses.  
• E、 They can modify the data type of the argument that is referenced.
• F、 They can accept a column name， expression， variable name， or a user-supplied constant as arguments.

第10题：

Which four are attributes of single row functions? （）

• A、cannot be nested
• B、manipulate data items
• C、act on each row returned
• D、return one result per row
• E、accept only one argument and return only one value
• F、accept arguments which can be a column or an expression