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. REMOVE DATABASE

B. TRUNCATE DATABASE

C. DROP DATABASE

D. DELETE 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

Who proposed the relational database model based on mathematical relation theory in 1970?

A. Dennis Ritchie

B. Charles Bachman

C. James Gosling

D. E.F. Codd

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Dr. Edgar Frank Codd (E.F. Codd) invented the relational model for database management while working for IBM in 1970.

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

Question #2

What is the difference between a clustered index and a non-clustered index?

A. Non-clustered index determines physical order; clustered does not

B. Clustered index is faster for inserts

C. They are the same

D. Clustered index determines the physical order of data; non-clustered does not

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A clustered index sorts and stores the data rows in the table based on key values, while a non-clustered index is a separate structure that points to the data rows.

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

Question #3

Which normal form requires that all attributes in a table contain only atomic, indivisible values, and prohibits multi-valued attributes?

A. Third Normal Form (3NF)

B. Second Normal Form (2NF)

C. Boyce-Codd Normal Form (BCNF)

D. First Normal Form (1NF)

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A relation is in First Normal Form (1NF) if and only if the domain of every attribute contains only atomic (indivisible) values, and no repeating groups exist.

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

Explore All Database Management System (DBMS) MCQs