Q. Which two statements about creating constraints are true? [Choose two]
A. Constraint names must start with SYS_C.
B. All constraints must be defined 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
Answer: CD
Which of the following statements about creating constraints is incorrect?
A] If you do not provide a name for a constraint, the Oracle11g server will issue an error message.
B] There are two approaches for creating constraints: at the column level or the table level.
C] One industry convention is to use the format tablename_columnname_constraint type for the constraint name.
D] none of the above
Which of the following statements about creating constraints is incorrect?
A] If a constraint applies to more than one column,the constraint must be created at the table level.
B] Using the column level approach,the definition of the constraint is included as part of the column definition.
C] When you create constraints at the column level,the constraint being created applies to the column specified.
D] The NOT NULL constraint can be created at either the column level or the table level.