Which command is used to retrieve data from a database? MCQ with Answer and Explanation

Which command is used to retrieve data from a database?
A. UPDATE
B. INSERT
C. DELETE
D. SELECT
Answer: Option D
Solution (By JKSSB Mock Tests)
The SELECT statement is used in SQL to query and retrieve data from tables.

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 database concepts deals with grouping a set of SQL statements into a single logical unit of execution?
A. View definition
B. Normalization
C. Indexing
D. Transaction

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)
Question #2
Candidate keys that are not selected or designated as the primary key of a table are known as what?
A. Super Keys
B. Alternate Keys
C. Foreign Keys
D. Composite Keys

Correct Answer: Option B


Explanation:
Out of all available candidate keys, the one selected to identify rows uniquely is the primary key, and the remaining unselected candidate keys are called alternate keys.

This question belongs to: Computer Database Management System (DBMS)
Question #3
What is a self join?
A. Joining more than two tables
B. Joining tables without a common column
C. Joining a table with itself
D. Joining two different tables

Correct Answer: Option C


Explanation:
A self join is a join where a table is joined with itself, often used to compare rows within the same table.

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