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 11 discussion

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

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

  • A. The UNIQUE constraint does not permit a null value for the column.
  • B. A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.
  • C. The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.
  • D. The NOT NULL constraint ensures that null values are not permitted for the column.
Show Suggested Answer Hide Answer
Suggested Answer: BD 🗳️
B: A unique constraint can contain null values because null values cannot be compared to anything.
D: The NOT NULL constraint ensure that null value are not permitted for the column
Incorrect answer:

A. statement is not true -

C. statement is not true -
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 10-9
by thuthuysphn58 at April 4, 2025, 9:14 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