UNIQUE
NOT NULL
CHECK
PRIMARY KEY
FOREIGN KEY
Which kind of non-sourced UDF can be created so that it only returns a single value?()A.RowB.TableC.ScalarD.Column
点击查看答案
Which four are attributes of single row functions? ()A、cannot be nestedB、manipulate data itemsC、act on each row returnedD、return one result per rowE、accept only one argument and return only one valueF、accept arguments which can be a column or an expression
In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table()A、if a table is not in a clusterB、if a table has an active triggerC、if a table has an encryptedD、if a table has a column of data type LONG defined on itE、if a table has a referential integrity constraint defined on it
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.
Which two conditions, when met, allow an IS-IS Level 2 router to be considered attached?()A、You can reach other Level 2 routers.B、It can reach at least one other defined area.C、The router is reachable by at least two ES-IS nodes.D、It has at least one enabled reachable prefix with a valid metric defined.
Which two statements are true about the primary key constraint in a table? ()A、It is not possible to disable the primary key constraint.B、It is possible to have more than one primary key constraint in a single table.C、The primary key constraint can be referred by only one foreign key constraint.D、The primary key constraint can be imposed by combining more than one column.E、The non-deferrable primary key constraint creates an unique index on the primary key column if it is not already indexed.
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