exam questions

Exam 1z0-051 All Questions

View all questions & answers for the 1z0-051 exam

Exam 1z0-051 topic 1 question 20 discussion

Actual exam question from Oracle's 1z0-051
Question #: 20
Topic #: 1
[All 1z0-051 Questions]

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

  • A. A constraint can be disabled even if the constraint column contains data
  • B. A constraint is enforced only for the INSERT operation on a table
  • C. A foreign key cannot contain NULL values
  • D. All constraints can be defined at the column level as well as the table level
  • E. A column with the UNIQUE constraint can contain NULL values
Show Suggested Answer Hide Answer
Suggested Answer: AE 🗳️
Including Constraints -
Constraints enforce rules at the table level.
Constraints prevent the deletion of a table if there are dependencies.
The following constraint types are valid:
NOT NULL
UNIQUE
PRIMARY KEY
FOREIGN KEY
CHECK

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
algerianphoenix
3 years, 4 months ago
ADE, should be the correct answer. We can define constraint at the table level, and of course we have to create it at the column level through the table as well. https://docs.oracle.com/javadb/10.8.3.0/ref/rrefsqlj13590.html#:~:text=Table-level%20constraints%20refer%20to,more%20columns%20in%20the%20table.
upvoted 2 times
ogi33
9 months, 2 weeks ago
NOT NULL
upvoted 1 times
...
...
alvace
4 years, 11 months ago
Is not correct the point D? Why?
upvoted 1 times
ogi33
9 months, 2 weeks ago
NOT NULL
upvoted 1 times
...
...
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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago