When creating a table,which of the following statements is correct?
A) The schema of the table must be explicitly stated.
B) A user can have two tables with the same name,as long as the column names are different.
C) The column list must be enclosed in parentheses ( ).
D) Default values cannot be assigned to all columns in a table.

Question

When creating a table,which of the following statements is correct?​
A) ​The schema of the table must be explicitly stated.
B) ​A user can have two tables with the same name,as long as the column names are different.
C) ​The column list must be enclosed in parentheses ( ).
D) ​Default values cannot be assigned to all columns in a table.

Quizplus · Accepted Answer

The column list must be enclosed in parentheses ( ), otherwise the table creation will not work. The schema can be explicitly stated or it can be created implicitly based on the data types and constraints defined for the columns. A user cannot have two tables with the same name, even if the column names are different. Default values can be assigned to all columns in a table.

When Creating a Table,which of the Following Statements Is Correct?​

When Creating a Table,which of the Following Statements Is Correct?