niusouti.com

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

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

相似考题

1.Evaluate the following SQL statement used to create the PRODUCTS table:Which statement is true regarding this command?()A. It executes successfully but partition pruning cannot happen for this partition key.B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key.C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key.D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.

2.What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?（）A.A check constraint on the EMPLOYEE tableB.A unique constraint on the EMPLOYEE table WORKDEPT columnC.A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE tableD.A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table

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

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

更多“单选题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”相关问题

  • 第1题：

    Which of the following database objects can be used to raise an error if a table is updated?()

    A.Package

    B.Trigger

    C.Stored Procedure

    D.Informational Constraint


    参考答案：B

  • 第2题：

    Which of the following can be used to ensure that once a row has been inserted in table TABLEX, the column MAINID in that row cannot be updated?()

    A.Define the column MAINID as NOT UPDATABLE

    B.Define the column MAINID as a PRIMARY KEY

    C.Define the column MAINID as a FOREIGN KEY

    D.Define an UPDATE trigger on table TABLEX


    参考答案：D

  • 第3题：

    Given the following ALTER SEQUENCE statement: ALTER SEQUENCE myseq RESTART WITH 0 INCREMENT BY 1 NO MAXVALUE CACHE 5 ORDER Assuming that the sequence had reached a value of 100 prior to the RESTART, which of the following is true?（）

    • A、The next value will be 0 and the sequence will never use the values 101 to 105.
    • B、The next value will be 101 to ensure uniqueness between existing and newly generated sequence values.
    • C、Previously cached values are retained by DB2, and after the restart, will be used for values 101 to 105.
    • D、The next value will be 0 and DB2 will not ensure uniqueness between existing and newly generated values.

    正确答案:D

  • 第4题：

    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

  • 第5题：

    What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?（）

    • A、A check constraint on the EMPLOYEE table
    • B、A unique constraint on the EMPLOYEE table WORKDEPT column
    • C、A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE table
    • D、A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table

    正确答案:D

  • 第6题：

    Which of the following can be used to ensure that once a row has been inserted in table TABLEX, the column MAINID in that row cannot be updated?（）

    • A、Define the column MAINID as NOT UPDATABLE
    • B、Define the column MAINID as a PRIMARY KEY
    • C、Define the column MAINID as a FOREIGN KEY
    • D、Define an UPDATE trigger on table TABLEX

    正确答案:D

  • 第7题：

    Which constraint can be defines only at the column level?（）

    • A、UNIQUE
    • B、NOT NULL
    • C、CHECK
    • D、PRIMARY KEY
    • E、FOREIGN KEY

    正确答案:B

  • 第8题：

    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

    正确答案:D,E

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


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

  • 第11题：

    单选题
    Given the following ALTER SEQUENCE statement: ALTER SEQUENCE myseq RESTART WITH 0 INCREMENT BY 1 NO MAXVALUE CACHE 5 ORDER Assuming that the sequence had reached a value of 100 prior to the RESTART, which of the following is true?（）
    A

    The next value will be 0 and the sequence will never use the values 101 to 105.

    B

    The next value will be 101 to ensure uniqueness between existing and newly generated sequence values.

    C

    Previously cached values are retained by DB2, and after the restart, will be used for values 101 to 105.

    D

    The next value will be 0 and DB2 will not ensure uniqueness between existing and newly generated values.


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

  • 第12题：

    单选题
    What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?（）
    A

    A check constraint on the EMPLOYEE table

    B

    A unique constraint on the EMPLOYEE table WORKDEPT column

    C

    A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE table

    D

    A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table


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

  • 第13题：

    Which of the following scenarios will ensure that the value of the NEXT_STEPNO column in a given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the same table?()

    A.Define a UNIQUE constraint on the columns NEXT_STEPNO and STEPNO.

    B.Define a CHECK constraint on the NEXT_STEPNO column (NEXT_STEPNO = STEPNO).

    C.Define column STEPNO as the primary key of TABLEX and column NEXT_STEPNO as a foreign key referencing column STEPNO of the same table.

    D.Define column NEXT_STEPNO as the primary key of TABLEX and column STEPNO as a foreign key referencing column NEXT_STEPNO in the same table.


    参考答案：C

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    Which of the following scenarios will ensure that the value of the NEXT_STEPNO column in a given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the same table?（）

    • A、Define a UNIQUE constraint on the columns NEXT_STEPNO and STEPNO.
    • B、Define a CHECK constraint on the NEXT_STEPNO column (NEXT_STEPNO = STEPNO).
    • C、Define column STEPNO as the primary key of TABLEX and column NEXT_STEPNO as a foreign key referencing column STEPNO of the same table.
    • D、Define column NEXT_STEPNO as the primary key of TABLEX and column STEPNO as a foreign key referencing column NEXT_STEPNO in the same table.

    正确答案:C

  • 第17题：

    Which of the following database objects can be used to raise an error if a table is updated?（）

    • A、Package
    • B、Trigger
    • C、Stored Procedure
    • D、Informational Constraint

    正确答案:B

  • 第18题：

    Which two statements are true about constraints? （）

    • A、The UNIQUE constraint does not permit a null value for the column.
    • B、A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.
    • C、The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.
    • D、The NOT NULL constraint ensures that null values are not permitted for the column.

    正确答案:B,D

  • 第19题：

    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

  • 第20题：

    单选题
    Which of the following scenarios will ensure that the value of the NEXT_STEPNO column in a given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the same table?（）
    A

    Define a UNIQUE constraint on the columns NEXT_STEPNO and STEPNO.

    B

    Define a CHECK constraint on the NEXT_STEPNO column (NEXT_STEPNO = STEPNO).

    C

    Define column STEPNO as the primary key of TABLEX and column NEXT_STEPNO as a foreign key referencing column STEPNO of the same table.

    D

    Define column NEXT_STEPNO as the primary key of TABLEX and column STEPNO as a foreign key referencing column NEXT_STEPNO in the same table.


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

  • 第21题：

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


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

  • 第22题：

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


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

  • 第23题：

    单选题
    Which of the following can be used to ensure that once a row has been inserted in table TABLEX, the column MAINID in that row cannot be updated?（）
    A

    Define the column MAINID as NOT UPDATABLE

    B

    Define the column MAINID as a PRIMARY KEY

    C

    Define the column MAINID as a FOREIGN KEY

    D

    Define an UPDATE trigger on table TABLEX


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

  • 第24题：

    单选题
    Which of the following database objects can be used to raise an error if a table is updated?（）
    A

    Package

    B

    Trigger

    C

    Stored Procedure

    D

    Informational Constraint


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

相关内容