单选题Which constraint can be defined only at the column level?（）AUNIQUEBNOT NULLCCHECKDPRIMARY KEYEFOREIGN KEY
单选题
Which constraint can be defined only at the column level?（）
A
UNIQUE
B
NOT NULL
C
CHECK
D
PRIMARY KEY
E
FOREIGN KEY
参考解析
解析：
暂无解析
相关考题：
Which constraint can be defined only at the column level? () A. UNIQUEB. NOT NULLC. CHECKD. PRIMARY KEYE. FOREIGN KEY
Which statement about the enabling of table compression in Oracle Database 11g is true?() A. Compression can be enabled at the table, tablespace, or partition level for direct loads only.B. Compression can be enabled only at the table level for both direct loads and conventional DML.C. Compression can be enabled at the table, tablespace, or partition level for conventional DML only.D. Compression can be enabled at the table, tablespace, or partition level for both direct loads and conventional DML.
Which constraint can be defines only at the column level? () A. UNIQUEB. NOT NULLC. CHECKD. PRIMARY KEYE. FOREIGN KEY
Examine the following command:CREATE TABLE (prod_id number(4),Prod_name varchar2 (20),Category_id number(30),Quantity_on_hand number (3) INVISIBLE);Which three statements are true about using an invisible column in the PRODUCTS table?（）A. The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.B. The DESCRIBE commands in SQL *Plus will not display the invisible column in the output.C. Referential integrity constraint cannot be set on the invisible column.D. The invisible column cannot be made visible and can only be marked as unused.E. A primary key constraint can be added on the invisible column.
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 of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?() A.UniqueB.CheckC.ReferentialD.Informational
When defining a referential constraint between the parent table T2 and the dependent table T1, which of the following is true?() A.The list of column names in the FOREIGN KEY clause can be a subset of the list of column names in the primary key of T2 or a UNIQUE constraint that exists on T2.B.The list of column names in the FOREIGN KEY clause can be a subset of the list of column names in the primary key of T1 or a UNIQUE constraint that exists on T1.C.The list of column names in the FOREIGN KEY clause must be identical to the list of column names in the primary key of T2 or a UNIQUE constraint that exists on T2.D.The list of column names in the FOREIGN KEY clause must be identical to the list of column names in the primary key of T1 or a UNIQUE constraint that exists on T1.
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
Which two statements about creating constraints are true?（）A、Constraint names must start with SYS_CB、All constraints must be defines at the column level.C、Constraints can be created after the table is created.D、Constraints can be created at the same time the table is created.E、Information about constraints is found in the VIEW_CONSTRAINTS dictionary view.
单选题Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?（）AUniqueBCheckCReferentialDInformational
单选题Which statement about the enabling of table compression in Oracle Database 11g is true？（）A Compression can be enabled at the table， tablespace， or partition level for direct loads only.B Compression can be enabled only at the table level for both direct loads and conventional DML.C Compression can be enabled at the table， tablespace， or partition level for conventional DML only.D Compression can be enabled at the table， tablespace， or partition level for both direct loads and conventional DML.
多选题Which three statements are true regarding the data types in Oracle Database 10g/11g?（）AOnly one LONG column can be used per tableBA TIMESTAMP data type column stores only time values with fractional secondsCThe BLOB data type column is used to store binary data in an operating system fileDThe minimum column width that can be specified for a VARCHAR2 data type column is oneEThe value for a CHAR data type column is blank-padded to the maximum defined column width
多选题In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table（）Aif a table is not in a clusterBif a table has an active triggerCif a table has an encryptedDif a table has a column of data type LONG defined on itEif a table has a referential integrity constraint defined on it
多选题Which two statements about views are true?（）AA view can be created as read only.BA view can be created as a join on two or more tables.CA view cannot have an ORDER BY clause in the SELECT statement.DA view cannot be created with a GROUP BY clause in the SELECT statement.EA 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?（）AYou can reach other Level 2 routers.BIt can reach at least one other defined area.CThe router is reachable by at least two ES-IS nodes.DIt has at least one enabled reachable prefix with a valid metric defined.
单选题When defining a referential constraint between the parent table T2 and the dependent table T1, which of the following is true?（）AThe list of column names in the FOREIGN KEY clause can be a subset of the list of column names in the primary key of T2 or a UNIQUE constraint that exists on T2.BThe list of column names in the FOREIGN KEY clause can be a subset of the list of column names in the primary key of T1 or a UNIQUE constraint that exists on T1.CThe list of column names in the FOREIGN KEY clause must be identical to the list of column names in the primary key of T2 or a UNIQUE constraint that exists on T2.DThe list of column names in the FOREIGN KEY clause must be identical to the list of column names in the primary key of T1 or a UNIQUE constraint that exists on T1.
多选题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 tableEThey can return a data type value different from the one that is referenced
单选题What type of constraint can be used to ensure that, in any given row in a table, the value of one column never exceeds the value of another column?（）ACheckBRangeCReferentialDInformational
多选题Which two statements are true about the primary key constraint in a table？ （）AIt is not possible to disable the primary key constraint.BIt is possible to have more than one primary key constraint in a single table.CThe primary key constraint can be referred by only one foreign key constraint.DThe primary key constraint can be imposed by combining more than one column.EThe non-deferrable primary key constraint creates an unique index on the primary key column if it is not already indexed.
单选题Which constraint can be defines only at the column level? （）AUNIQUEBNOT NULLCCHECKDPRIMARY KEYEFOREIGN KEY
多选题Which four are attributes of single row functions? （）Acannot be nestedBmanipulate data itemsCact on each row returnedDreturn one result per rowEaccept only one argument and return only one valueFaccept arguments which can be a column or an expression