Examine the structure of the sales table: Evaluate the following create table statement: Which two statements are true about the creation of the SALES1 table?
A.
The SALES1 table is created with no rows but only a structure.
B.
The SALES1 table would have primary key and unique constraints on the specified columns.
C.
The SALES1 table would not be created because of the invalid where clause.
D.
The SALES1 table would have not null and unique constraints on the specified columns.
E.
The SALES1 table would not be created because column-specified names in the select and create table clauses do not match,
Suggested Answer:AD🗳️
A: the WHERE clause 1=2 is false so no rows will be inserted into the new table. D: The NOT NULL constraints will be included in the new table. There are no UNIQUE constraints.
This section is not available anymore. Please use the main Exam Page.1z0-061 Exam Questions
Log in to ExamTopics
Sign in:
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.
Hello
5 years, 9 months ago