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
相关考题：
Which constraint can be defined 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. UNIQUEB. NOT NULLC. CHECKD. PRIMARY KEYE. FOREIGN KEY
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;
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.
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 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;
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.
Which of the following database objects can be used to raise an error if a table is updated?（）A、PackageB、TriggerC、Stored ProcedureD、Informational Constraint
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 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 two statements about creating constraints are true?（）A、Constraint names must start with SYS_CB、All constraints must be defines at the column levelC、Constraints can be created after the table is createdD、Constraints can be created at the same time the table is createdE、Information about constraints is found in the VIEW_CONSTRAINTS dictionary view
单选题Which syntax turns an existing constraint on? （）AALTER TABLE table_name ENABLE constraint_name;BALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint _ name;CALTER TABLE table_name ENABLE CONSTRAINT constraint _ name;DALTER TABLE table_name TURN ON CONSTRAINT constraint _ name;
单选题Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?（）AUniqueBCheckCReferentialDInformational
单选题Which constraint can be defined only at the column level?（）AUNIQUEBNOT NULLCCHECKDPRIMARY KEYEFOREIGN KEY
单选题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（）.APP-systemBPA-systemCAP-systemDAA-system
多选题Which two statements about creating constraints are true?（）AConstraint names must start with SYS_CBAll constraints must be defines at the column levelCConstraints can be created after the table is createdDConstraints can be created at the same time the table is createdEInformation about constraints is found in the VIEW_CONSTRAINTS dictionary view
单选题Which SQL statement defines a FOREIGN KEY constraint on the DEPTNO column of the EMP table?（）ACREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);BCREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));CCREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));DCREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));
多选题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？（）AMANAGER can do a GET on resources in the /Bar/Baz directory.BMANAGER can do a POST on any resource in the /Bar/Baz directory.CMANAGER can do a TRACE on any resource in the /Bar/Baz directory.DDEVELOPER can do a GET on resources in the /Bar/Baz directory.EDEVELOPER can do only a POST on resources in the /Bar/Baz directory.FDEVELOPER can do a TRACE on any resource in the /Bar/Baz directory.
单选题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.
单选题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 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 SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table?（）ACREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) NOT NULL CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);BCREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));CCREATE TABLE EMP (empno NUMBER(4) ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));DCREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp deptno fk REFERENCES dept (deptno));
多选题Which two statements about creating constraints are true?（）AConstraint names must start with SYS_CBAll constraints must be defines at the column level.CConstraints can be created after the table is created.DConstraints can be created at the same time the table is created.EInformation about constraints is found in the VIEW_CONSTRAINTS dictionary view.
单选题Which syntax turns an existing constraint on?（）AALTER TABLE table_name ENABLE constraint_name;BALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint_name;CALTER TABLE table_name ENABLE CONSTRAINT constraint_name;DALTER TABLE table_name STATUS ENABLE CONSTRAINT constraint_name;EALTER TABLE table_name TURN ON CONSTRAINT constraint_name;