Which SQL command is used to create a new table? MCQ with Answer and Explanation

Question

Share Report Error

Which SQL command is used to create a new table?

A. SELECT

B. CREATE TABLE

C. UPDATE

D. INSERT

Answer: Option B

Solution (By JKSSB Mock Tests)

The CREATE TABLE command in DDL is used to define a new table structure in SQL.

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 of the following ensures data integrity in RDBMS?

A. Random data entry

B. No validation rules

C. User input without checks

D. Constraints like primary key, foreign key

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Integrity constraints such as keys enforce rules for valid data.

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

Question #2

What is an alternate key?

A. A foreign key

B. A candidate key that is not chosen as the primary key

C. A super key with extra attributes

D. The primary key

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
An alternate key is any candidate key that is not the primary key.

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

Question #3

Which of the following database concepts deals with grouping a set of SQL statements into a single logical unit of execution?

A. Normalization

B. Indexing

C. View definition

D. Transaction

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A Transaction is a sequence of one or more SQL operations treated as a single, indivisible unit of work that must either succeed completely or fail completely.

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

Explore All Database Management System (DBMS) MCQs