Multiple Choice
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
Correct Answer:
Verified
Correct Answer:
Verified
Q24: Which clause will allow you to delete
Q27: A NOT NULL constraint can only be
Q31: Structure of the ORDERITEMS table<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB1929/.jpg"
Q35: A(n)<u>NOT NULL</u> constraint is a special CHECK
Q64: A referential integrity constraint is usually placed
Q86: Only one PRIMARY KEY constraint can exist
Q93: In the USER_CONSTRAINTS view,the constraint type for
Q109: The ALTER TABLE command can be used
Q112: The ALTER TABLE command can be used
Q121: A constraint is always enforced at the