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. Both A and B

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

C. Neither

D. CREATE TABLE table_name AS SELECT ...;

Answer: Option A

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

What is the purpose of a Foreign Key?

A. To link two tables and enforce referential integrity

B. To uniquely identify records

C. To create indexes

D. To sort data

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A foreign key establishes a relationship between tables and maintains referential integrity.

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

Question #2

What does ACID stand for in database transactions?

A. All Correct Information Display

B. Accuracy, Control, Integrity, Data

C. Access, Create, Insert, Delete

D. Atomicity, Consistency, Isolation, Durability

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
ACID properties ensure reliable transaction processing in DBMS.

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

Question #3

Which normal form eliminates all transitive dependencies?

A. 2NF

B. 1NF

C. 3NF

D. BCNF

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Third Normal Form (3NF) eliminates transitive dependencies, where non-key attributes depend on other non-key attributes.

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

Explore All Database Management System (DBMS) MCQs