What is the difference between a database and a data warehouse? MCQ with Answer and Explanation

Question

Share Report Error

What is the difference between a database and a data warehouse?

A. They are the same

B. Databases store current data; data warehouses store historical data

C. Databases are for OLTP, data warehouses for OLAP

D. Both A and B

Answer: Option D

Solution (By JKSSB Mock Tests)

Databases are optimized for transaction processing (OLTP), while data warehouses are designed for analytical reporting (OLAP) using historical data.

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 wildcard character is used with the SQL LIKE operator to represent zero, one, or multiple characters?

A. Percentage sign (%)

B. Hash (#)

C. Underscore (_)

D. Ampersand (&)

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The percentage sign (%) is used as a wildcard character to match any sequence of zero or more characters in an SQL LIKE string comparison query.

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

Question #2

Share Report

Which SQL function is used to find the maximum value in a column?

A. MAX()

B. AVG()

C. SUM()

D. MIN()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
MAX() returns the highest value in a selected column.

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

Question #3

Share Report

Which of the following is a valid SQL statement to update a record?

A. UPDATE table_name column1 = value1 WHERE condition;

B. CHANGE table_name SET column1 = value1 WHERE condition;

C. MODIFY table_name SET column1 = value1 WHERE condition;

D. UPDATE table_name SET column1 = value1 WHERE condition;

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The correct syntax for UPDATE is: UPDATE table_name SET column1 = value1 WHERE condition;

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

Explore All Database Management System (DBMS) MCQs