Questions and Corresponding Answers
with Surety of 100% Pass Mark
Metadata - 🧠 ANSWER ✔✔Data about data, through which the end user data is
integrated and managed
Database Management System (DBMS) - 🧠 ANSWER ✔✔Collection of programs;
Manages the database structure; Controls access to data stored in the database
Single-user database - 🧠 ANSWER ✔✔supports one user at a time
Multiuser database - 🧠 ANSWER ✔✔supports multiple users at the same time
Workgroup databases - 🧠 ANSWER ✔✔Supports a small number of users or a
specific department
, Enterprise databases - 🧠 ANSWER ✔✔supports many users across many
departments
Centralized database - 🧠 ANSWER ✔✔Data located at a single site
Distributed database - 🧠 ANSWER ✔✔Data distributed across different sites
Cloud database - 🧠 ANSWER ✔✔Created and maintained using cloud data
services that provide defined performance measures for the database
Classification by data type: General-purpose database - 🧠 ANSWER ✔✔Contains
a wide variety of data used in multiple disciplines
Classification by data type: Discipline-specific database - 🧠 ANSWER
✔✔Contains data focused on specific subject areas
Classification by data type: Operational database - 🧠 ANSWER ✔✔Designed to
support a company's day-to-day operations
Classification by data type: Analytical database - 🧠 ANSWER ✔✔Stores historical
data and business metrics used exclusively for tactical or strategic decision making
Data warehouse - 🧠 ANSWER ✔✔Stores data in a format optimized for decision
support