单选题Which kind of non-sourced UDF can be created so that it only returns a single value?（）A RowB TableC ScalarD Column

第1题：

第2题：

Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?（）

• A、Unique
• B、Check
• C、Referential
• D、Informational

第3题：

第4题：

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.

第5题：

Which of the following resources can be referenced in the LOCK statement?（）

• A、Row
• B、Table
• C、Column
• D、Table space

第6题：

第7题：

A trigger can be created on which of the following objects?（）

• A、View
• B、Catalog Table
• C、Stored Procedure
• D、Global Temporary Table

第8题：

第9题：

Which of the following resources can be explicitly locked?（）

• A、Row
• B、Page
• C、Table
• D、Column

第10题：

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.