单选题Which constraint can be defines only at the column level? （）A UNIQUEB NOT NULLC CHECKD PRIMARY KEYE FOREIGN KEY

题目
单选题
Which constraint can be defines only at the column level? （）
A

UNIQUE

B

NOT NULL

C

CHECK

D

PRIMARY KEY

E

FOREIGN KEY

相似考题

1.Which constraint can be defined only at the column level? ()A. UNIQUEB. NOT NULLC. CHECKD. PRIMARY KEYE. FOREIGN KEY

2.Which constraint can be defines only at the column level? ()A. UNIQUEB. NOT NULLC. CHECKD. PRIMARY KEYE. FOREIGN KEY

3.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.

4.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? （）”相关问题

  • 第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


    参考答案：B

  • 第2题：

    Which kind of non－sourced UDF can be created so that it only returns a single value?()

    A.Row

    B.Table

    C.Scalar

    D.Column


    参考答案：C

  • 第3题：

    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

    正确答案:B,C,D,E

  • 第4题：

    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

    正确答案:A,D,E

  • 第5题：

    Which two statements about creating constraints are true?（）

    • A、Constraint names must start with SYS_C
    • B、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

    正确答案:C,D

  • 第6题：

    单选题
    Which constraint can be defined only at the column level?（）
    A

    UNIQUE

    B

    NOT NULL

    C

    CHECK

    D

    PRIMARY KEY

    E

    FOREIGN KEY


    正确答案： E
    解析： 暂无解析

  • 第7题：

    多选题
    Which two statements about creating constraints are true?（）
    A

    Constraint names must start with SYS_C

    B

    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


    正确答案： E,D
    解析： 暂无解析

  • 第8题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    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?（）
    A

    Check

    B

    Range

    C

    Referential

    D

    Informational


    正确答案： D
    解析： 暂无解析

  • 第10题：

    单选题
    Which constraint can be defines only at the column level? （）
    A

    UNIQUE

    B

    NOT NULL

    C

    CHECK

    D

    PRIMARY KEY

    E

    FOREIGN KEY


    正确答案： E
    解析： 暂无解析

  • 第11题：

    多选题
    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


    正确答案： F,E
    解析： 暂无解析

  • 第12题：

    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.


    参考答案：C

  • 第13题：

    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?()

    A.Check

    B.Range

    C.Referential

    D.Informational


    参考答案：A

  • 第14题：

    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.

    正确答案:D,E

  • 第15题：

    Which two statements about creating constraints are true?（）

    • A、Constraint names must start with SYS_C
    • B、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.

    正确答案:C,D

  • 第16题：

    单选题
    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


    正确答案： B
    解析： 暂无解析

  • 第17题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第18题：

    多选题
    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.


    正确答案： D,C
    解析： 暂无解析

  • 第19题：

    多选题
    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


    正确答案： A,B
    解析： 暂无解析

  • 第20题：

    多选题
    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.


    正确答案： D,B
    解析： 暂无解析

  • 第21题：

    多选题
    Which two statements about creating constraints are true?（）
    A

    Constraint names must start with SYS_C

    B

    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.


    正确答案： B,D
    解析： 暂无解析

相关内容