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

Exam 1z0-071 All Questions

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

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
by holdfaststrongly at Sept. 21, 2022, 7:38 p.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
ArslanAltaf
8 months, 2 weeks ago
for Book.seq currval- is there a logical error despite the statement does execute?
upvoted 1 times
...
hmatinnn
10 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
2 years ago
Can any one explain A,D are the correct answers
upvoted 1 times
anzac
1 year, 12 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 6 times
...
...
holdfaststrongly
2 years, 3 months ago
CURRVAL might have a null value so option C may not work.
upvoted 1 times
karols32
2 years, 1 month ago
so what not an option E?
upvoted 1 times
karols32
2 years, 1 month ago
nvm, column cannot be a default value in next column.
upvoted 3 times
...
...
Orxan_H
1 year, 8 months ago
in which situations currval may be 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