ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-061 All Questions

View all questions & answers for the 1z0-061 exam
Go to Exam

Exam 1z0-061 topic 3 question 58 discussion

Actual exam question from Oracle's 1z0-061
Question #: 58
Topic #: 3
[All 1z0-061 Questions]

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

  • A. Constraint names must start with SYS_C.
  • B. 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.
Show Suggested Answer Hide Answer
Suggested Answer: CD 🗳️
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.
OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 227-232
Chapter 5: Creating Oracle Database Objects
by [deleted] at April 4, 2025, 9:17 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Currently there are no comments in this discussion, be the first to comment!
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel