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

Question

Share Report Error

Which SQL statement is used to retrieve data from a database?

A. UPDATE

B. DELETE

C. SELECT

D. INSERT

Answer: Option C

Solution (By JKSSB Mock Tests)

SELECT is the SQL command used to query and retrieve data from one or more tables.

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

Share Report

Which clause is used in SQL queries to filter rows and retrieve only those records that satisfy a specific condition?

A. GROUP BY

B. HAVING

C. WHERE

D. ORDER BY

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The WHERE clause is used to filter records based on a specified condition before any grouping takes place.

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

Question #2

Share Report

What does the SQL command 'INSERT INTO' do?

A. Adds a new row to a table

B. Creates a table

C. Deletes rows

D. Updates existing rows

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

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

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

Question #3

Share Report

When the same data is updated in one location but remains unchanged in another location, it creates a state of what?

A. Data Security

B. Data Inconsistency

C. Data Independence

D. Data Integrity

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Data Inconsistency occurs when different versions of the same data appear in different places due to uncontrolled data redundancy.

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

Explore All Database Management System (DBMS) MCQs