Which of the following is a valid SQL statement to create a table? MCQ with Answer and Explanation

Question

Share Report Error

Which of the following is a valid SQL statement to create a table?

A. Neither

B. Both A and B

C. CREATE TABLE table_name AS SELECT ...;

D. CREATE TABLE table_name (column1 datatype, column2 datatype);

Answer: Option B

Solution (By JKSSB Mock Tests)

Both syntaxes are valid: direct CREATE TABLE with columns, and CREATE TABLE ... AS SELECT to create a table from a query result.

This question belongs to: Computer Database Management System (DBMS)

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1

Which SQL function is used to find the maximum value in a column?

A. SUM()

B. AVG()

C. MAX()

D. MIN()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
MAX() returns the highest value in a selected column.

This question belongs to: Computer Database Management System (DBMS)

Question #2

Which normal form requires that every determinant is a candidate key?

A. 2NF

B. BCNF

C. 1NF

D. 3NF

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Boyce-Codd Normal Form (BCNF) is a stricter version of 3NF where every determinant must be a candidate key.

This question belongs to: Computer Database Management System (DBMS)

Question #3

In the relational model, what is the term used to describe the header or definition of a table specifying its name and attributes?

A. Relation Instance

B. Relation Schema

C. Relation Card

D. Relation Domain

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A Relation Schema defines the structure of a relation, specifying its name and the list of attributes along with their data types.

This question belongs to: Computer Database Management System (DBMS)

Explore All Database Management System (DBMS) MCQs