Which of the following is a valid SQL command to delete a database? MCQ with Answer and Explanation

Question

Share Report Error

Which of the following is a valid SQL command to delete a database?

A. TRUNCATE DATABASE

B. DELETE DATABASE

C. DROP DATABASE

D. REMOVE DATABASE

Answer: Option C

Solution (By JKSSB Mock Tests)

DROP DATABASE is the SQL command to delete an entire database.

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 a tuple in a relational database?

A. A relationship between tables

B. A single column in a table

C. The name of the table

D. A single row in a table

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
In RDBMS, a tuple represents a single row or record in a relation (table).

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

Question #2

Which rule state that 'no component of a primary key can accept a NULL value'?

A. Domain Constraint Rule

B. Referential Integrity Rule

C. Entity Integrity Rule

D. Security Integrity Rule

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The Entity Integrity Rule states that a primary key column cannot contain NULL values, ensuring each row can be explicitly identified.

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

Question #3

What does the SQL command 'INSERT INTO' do?

A. Creates a table

B. Deletes rows

C. Updates existing rows

D. Adds a new row to a table

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
INSERT INTO is used to insert new records (rows) into a table.

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

Explore All Database Management System (DBMS) MCQs