Which two statements about creating constraints are true? (Choose two)

The correct answer is C. Constraints can be created after the table is created. D. Constraints can be created at the same time the table is created. Constraints can be created after the table is created. Use ALTER TABLE command for that. Constraints can be created at the same time the table is created (CREATE TABLE command). Incorrect Answers A: There is no requirements in Oracle that constraint names must start with SYS_C…

Creating and Managing Schema Objects

Question

Options

AConstraint names must start with SYS_C.
BAll 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.

How the community answered

(21 responses)

A
5% (1)
B
14% (3)
C
71% (15)
E
10% (2)

Explanation

Constraints can be created after the table is created. Use ALTER TABLE command for that. Constraints can be created at the same time the table is created (CREATE TABLE command). Incorrect Answers A: There is no requirements in Oracle that constraint names must start with SYS_C. Oracle can use prefix "SYS" to build indexes for UNIQUE and NOT NULL constraints, but it is not required for user to follow this naming rule. B: Not all constraints must be defines at the column level. Only NOT NULL constraint must be. E: There is no VIEW_CONSTRAINTS dictionary view in Oracle.

Topics

#constraints#table creation#ALTER TABLE#constraint syntax

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice