Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.

Exam 1z0-071 topic 1 question 55 discussion

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

BOOK_SEQ is an existing sequence in your schema.
Which two CREATE TABLE commands are valid? (Choose two.)
A.

B.

C. C.

D.

E.

Show Suggested Answer Hide Answer
Suggested Answer: AD

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
ArslanAltaf
2 weeks ago
for Book.seq currval- is there a logical error despite the statement does execute?
upvoted 1 times
...
hmatinnn
2 months, 3 weeks ago
How not null and primary key can be set on the same column as primary key = not null + unique key ? I checked it is possible but technically it should not work in that way
upvoted 1 times
...
boddoju
1 year, 5 months ago
Can any one explain A,D are the correct answers
upvoted 1 times
anzac
1 year, 3 months ago
A is correct because it have valid order of statements: DEFAULT ____ NOT NULL From this reason C is not valid because it have NOT NULL DEFAULT _____ which is wrong order. B and E are not valid because the are mentioning other columns in default statement.
upvoted 2 times
...
...
holdfaststrongly
1 year, 7 months ago
CURRVAL might have a null value so option C may not work.
upvoted 1 times
Orxan_H
1 year ago
in which situations currval may be Null?
upvoted 1 times
...
karols32
1 year, 5 months ago
so what not an option E?
upvoted 1 times
karols32
1 year, 5 months ago
nvm, column cannot be a default value in next column.
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 ...