exam questions

Exam 1z0-061 All Questions

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

Exam 1z0-061 topic 1 question 5 discussion

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

You want to create a table employees in which the values of columns EMPLOYEES_ID and LOGIN_ID must be unique and not null. Which two SQL statements would create the required table?

  • A. Option A
  • B. Option B
  • C. Option C
  • D. Option D
  • E. Option E
  • F. Option F
Show Suggested Answer Hide Answer
Suggested Answer: AF 🗳️

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
Blob44
2 years, 2 months ago
AE If you take the double D in account. NOT NULL constraints must be declared INLINE BCD don't have the not null or unique applied to the desired columns
upvoted 1 times
...
Fatthalla
4 years, 10 months ago
[email protected] correct this please
upvoted 1 times
...
rafa_vlc
5 years ago
There are 2 Ds so F is the last one.
upvoted 2 times
...
luizyto
5 years, 5 months ago
I don't see option F
upvoted 2 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