What is the result of the SQL query: SELECT * FROM employees;? MCQ with Answer and Explanation

Question

Share Report Error

What is the result of the SQL query: SELECT * FROM employees;?

A. Only the primary key column

B. Only the first row

C. An empty result

D. All rows and all columns from the employees table

Answer: Option D

Solution (By JKSSB Mock Tests)

SELECT * retrieves all columns and rows from the specified table.

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

The total number of attributes (columns) present in a relation determines its what?

A. Degree

B. Domain

C. Cardinality

D. Schema

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The number of attributes or columns in a relation is defined as the degree of that relation.

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

Question #2

Which of the following is a property of a transaction that ensures that the database remains in a valid state before and after the transaction?

A. Isolation

B. Durability

C. Consistency

D. Atomicity

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Consistency ensures that a transaction brings the database from one valid state to another, maintaining all defined rules and constraints.

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

Question #3

What does the ROLLBACK statement do?

A. Saves the changes

B. Creates a savepoint

C. Undoes all changes made in the current transaction

D. Starts a new transaction

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
ROLLBACK reverts the database to the state it was in at the beginning of the transaction, undoing all changes.

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

Explore All Database Management System (DBMS) MCQs