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 syntax turns an existing constraint on? ()A. ALTER TABLE table_name ENABLE constraint_name;B. ALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint _ name;C. ALTER TABLE table_name ENABLE CONSTRAINT constraint _ name;D. ALTER TABLE table_name TURN ON CONSTRAINT constraint _ name;

3.Referring to the exhibit, what is the purpose of the targets section of the configuration?()A. It defines which devices will be sending traps.B. It specifies where to send traps.C. It defines the IP addresses of management systems that can access the device.D. It specifies which devices can be polled for SNMP data.

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

更多“Which constraint can be defines ”相关问题

  • 第1题：

    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

  • 第2题：

    Given the security constraint in a DD:// 101. 102. 103.Foo 104./Bar/Baz/* 105.POST 106. 107. 108.DEVELOPER 109. 110. And given that "MANAGER" is a valid role-name，which four are true for this security constraint？（）

    • A、MANAGER can do a GET on resources in the /Bar/Baz directory.
    • B、MANAGER can do a POST on any resource in the /Bar/Baz directory.
    • C、MANAGER can do a TRACE on any resource in the /Bar/Baz directory.
    • D、DEVELOPER can do a GET on resources in the /Bar/Baz directory.
    • E、DEVELOPER can do only a POST on resources in the /Bar/Baz directory.
    • F、DEVELOPER can do a TRACE on any resource in the /Bar/Baz directory.

    正确答案:A,C,D,F

  • 第3题：

    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

  • 第4题：

    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

  • 第5题：

    单选题
    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
    解析： 暂无解析

  • 第6题：

    单选题
    Public address system: loudspeakers in the vessel’s cabins, mess rooms, ETC., and on deck via which important information can bebroadcast from a central point, mostly from the navigation bridge defines（）.
    A

    PP-system

    B

    PA-system

    C

    AP-system

    D

    AA-system


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

  • 第7题：

    单选题
    Which SQL statement defines a FOREIGN KEY constraint on the DEPTNO column of the EMP table?（）
    A

    CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);

    B

    CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));

    C

    CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));

    D

    CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));


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

  • 第8题：

    单选题
    Referring to the exhibit, what is the purpose of the targets section of the configuration?（）
    A

    It defines which devices will be sending traps.

    B

    It specifies where to send traps.

    C

    It defines the IP addresses of management systems that can access the device.

    D

    It specifies which devices can be polled for SNMP data.


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

  • 第9题：

    多选题
    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
    解析： 暂无解析

  • 第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 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
    解析： 暂无解析

  • 第12题：

    Which syntax turns an existing constraint on?（）

    • A、ALTER TABLE table_name   ENABLE constraint_name;
    • B、ALTER TABLE table_name   STATUS = ENABLE CONSTRAINT constraint_name;
    • C、ALTER TABLE table_name   ENABLE CONSTRAINT constraint_name;
    • D、ALTER TABLE table_name   STATUS ENABLE CONSTRAINT constraint_name;
    • E、ALTER TABLE table_name   TURN ON CONSTRAINT constraint_name;

    正确答案:C

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    单选题
    Which syntax turns an existing constraint on? （）
    A

    ALTER TABLE table_name ENABLE constraint_name;

    B

    ALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint _ name;

    C

    ALTER TABLE table_name ENABLE CONSTRAINT constraint _ name;

    D

    ALTER TABLE table_name TURN ON CONSTRAINT constraint _ name;


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

  • 第16题：

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

    UNIQUE

    B

    NOT NULL

    C

    CHECK

    D

    PRIMARY KEY

    E

    FOREIGN KEY


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

  • 第17题：

    多选题
    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
    解析： 暂无解析

  • 第18题：

    多选题
    Given the security constraint in a DD:// 101. 102. 103.Foo 104./Bar/Baz/* 105.POST 106. 107. 108.DEVELOPER 109. 110. And given that "MANAGER" is a valid role-name，which four are true for this security constraint？（）
    A

    MANAGER can do a GET on resources in the /Bar/Baz directory.

    B

    MANAGER can do a POST on any resource in the /Bar/Baz directory.

    C

    MANAGER can do a TRACE on any resource in the /Bar/Baz directory.

    D

    DEVELOPER can do a GET on resources in the /Bar/Baz directory.

    E

    DEVELOPER can do only a POST on resources in the /Bar/Baz directory.

    F

    DEVELOPER can do a TRACE on any resource in the /Bar/Baz directory.


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

  • 第19题：

    单选题
    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
    解析： 暂无解析

  • 第20题：

    单选题
    Which of the following defines access for a network?（）
    A

    ACL

    B

    RDF

    C

    RAS

    D

    ARP


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

  • 第21题：

    单选题
    Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table?（）
    A

    CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) NOT NULL CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);

    B

    CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));

    C

    CREATE TABLE EMP (empno NUMBER(4) ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));

    D

    CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp deptno fk REFERENCES dept (deptno));


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

  • 第22题：

    单选题
    Which syntax turns an existing constraint on?（）
    A

    ALTER TABLE table_name   ENABLE constraint_name;

    B

    ALTER TABLE table_name   STATUS = ENABLE CONSTRAINT constraint_name;

    C

    ALTER TABLE table_name   ENABLE CONSTRAINT constraint_name;

    D

    ALTER TABLE table_name   STATUS ENABLE CONSTRAINT constraint_name;

    E

    ALTER TABLE table_name   TURN ON CONSTRAINT constraint_name;


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

相关内容