What is a data mart? MCQ with Answer and Explanation

Question Report Error

What is a data mart?

A. A type of database

B. A subset of a data warehouse focused on a specific business unit or function

C. A backup technique

D. A query language

Answer: Option B

Solution (By JKExamLibrary)

A data mart is a specialized data warehouse for a specific department, team, or subject area.

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

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1 Report Error

Which constraint ensures that a column cannot accept or store an unassigned or missing value?

A. UNIQUE

B. CHECK

C. NOT NULL

D. DEFAULT

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
The NOT NULL constraint explicitly forces a column to always contain a value, preventing blank or NULL entries.

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

Question #2 Report Error

Which operator in SQL is used to exclude specific data records from a search based on a collection of negative criteria?

A. MINUS

B. REMOVE

C. EXCEPT

D. NOT IN

View Answer & Solution Discuss

Correct Answer: Option D

Explanation:
The NOT IN operator filters the query results to exclude records whose values match any element within the provided list or subquery.

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

Question #3 Report Error

Which of the following is a DCL (Data Control Language) command?

A. GRANT

B. COMMIT

C. SELECT

D. CREATE

View Answer & Solution Discuss

Correct Answer: Option A

Explanation:
GRANT and REVOKE are DCL commands. COMMIT is TCL, SELECT is DML, CREATE is DDL.

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

Explore All Database Management System (DBMS) MCQs