nerdexam
Oracle

1Z0-061 · Question #213

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).

Using DDL Statements to Create and Manage Tables

Question

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

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

(51 responses)
  • A
    4% (2)
  • B
    10% (5)
  • C
    73% (37)
  • E
    14% (7)

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).

Topics

#constraints#column-level constraints#table-level constraints#ALTER TABLE

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice