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

第1题：

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

第2题：

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

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

第3题：

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.

第4题：

Which two statements about views are true?（）

• A、A view can be created as read only.
• B、A view can be created as a join on two or more tables.
• C、A view cannot have an ORDER BY clause in the SELECT statement.
• D、A view cannot be created with a GROUP BY clause in the SELECT statement.
• E、A view must have aliases defined for the column names in the SELECT statement.

第5题：

You are using Oracle Enterprise Manager to estimate the size of a table to be created. You have typed data regarding the column names， data types， sizes of the columns， and the projected number of rows in the table. Which additional information does the Oracle Enterprise Manager return？（）

• A、 space allocated in the tablespace
• B、 space required for the bitmap index on a column of the table
• C、 space remaining in the tablespace after creating the table
• D、 estimated value of the PCTFREE storage parameter

第6题：

Which two statements are true regarding single row functions?（）

• A、They accept only a single argument 
• B、They can be nested only to two levels 
• C、Arguments can only be column values or constants 
• D、They always return a single result row for every row of a queried table 
• E、They can return a data type value different from the one that is referenced

第7题：

第8题：

第9题：

第10题：

第11题：

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

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

第12题：

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

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

第13题：

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.

第14题：

Which three statements are true regarding the data types in Oracle Database 10g/11g?（）

• A、Only one LONG column can be used per table 
• B、A TIMESTAMP data type column stores only time values with fractional seconds 
• C、The BLOB data type column is used to store binary data in an operating system file 
• D、The minimum column width that can be specified for a VARCHAR2 data type column is one 
• E、The value for a CHAR data type column is blank-padded to the maximum defined column width

第15题：

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

第16题：

第17题：

第18题：

第19题：