Database Basics MCQs with Answers

Past Paper MCQ

A repository for data, usually covering a specific topic, is known as a

• A.Data Bank
• B.Data Warehouse
• C.Database
• D.Data Dictionary

Past Paper MCQ

What is the purpose of Metadata?

• A.Data processed by the CPU
• B.Data stored in memory
• C.Data transmitted over a network
• D.Data about data

Past Paper MCQ

Which file format is commonly used for storing data in Database Management Systems?

• A.JSON
• B.Binary
• C.XML
• D.Text

What is a transaction called if it only retrieves data without modifying the database?

• A.Commit Transaction
• B.Write-Only Transaction
• C.Read-Write Transaction
• D.Read-Only Transaction

What data type should be assigned to the 'address' field when designing a database?

• A.Integer
• B.Boolean
• C.Alpha-numeric
• D.Date/Time

What is the role of concurrency control in database management systems?

• A.Enables simultaneous access by multiple users
• B.Ensures data is backed up regularly
• C.Restricts database access to a single user at a time
• D.Compresses data to save storage space

What is a defining characteristic of a relational database?

• A.It stores all data in a single flat table
• B.It contains multiple tables related through key fields
• C.It stores data in hierarchical tree structures only
• D.It uses unstructured text files to store records

In database terminology, which of the following best describes a collection of related records?

• A.Field
• B.Table
• C.Byte
• D.File

What does Data Integrity ensure in a database system?

• A.Only accuracy of data
• B.Only consistency of data
• C.Both accuracy and consistency
• D.Only security of data

What is a subset of a data warehouse that is specifically designed for a particular line of business or functional area?

• A.Data mart
• B.Data lake
• C.Data dictionary
• D.Data staging area