Database Basics MCQs with Answers

What is the purpose of metadata in data management?

• A.A backup and recovery technique
• B.A method of encrypting data
• C.A type of database schema
• D.Data about data

What is the term used to describe a collection of logically related data sets or files?

• A.Database
• B.Data Warehouse
• C.File System
• D.Data Repository

MS Access is primarily used for which of the following purposes?

• A.Word Processing
• B.Database Management
• C.Presentation Design
• D.Spreadsheet Analysis

Which of the following is NOT a primary objective of using a database system?

• A.Data redundancy control
• B.Data integrity enforcement
• C.Data acquisition
• D.Data sharing among multiple users

Past Paper MCQ

Which of the following is an example of database design software?

• A.MS PowerPoint
• B.MS Word
• C.MS Excel
• D.MS Access

What does the abbreviation DBMS stand for in computer science?

• A.Database Management System
• B.Data Backup Management Software
• C.Digital Binary Management System
• D.Distributed Business Management Server

How is communication typically established with a MySQL database?

• A.Direct hardware interrupts
• B.File system access
• C.Shared memory segments
• D.Network calls

What is the term for a database that is fully copied and distributed to multiple locations?

• A.Fragmented database
• B.Centralized database
• C.Partitioned database
• D.Replicated database

In MS Access, what is a row in a database table commonly referred to as?

• A.Field
• B.Record
• C.Attribute
• D.Entity

Which database model organizes its data in a hierarchical tree-like structure with parent and child relationships?

• A.Relational
• B.Hierarchical
• C.Network
• D.Object-Oriented