Database Basics MCQs with Answers

In a database table, what do the columns represent?

• A.Records
• B.Fields
• C.Tuples
• D.Entities

What term is used to describe the duplication of data across multiple files?

• A.Data Consistency
• B.Data Integrity
• C.Data Redundancy
• D.Data Independence

Past Paper MCQ

What is the smallest meaningful unit of data in a database called?

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

What is a collection of related data known as in computer terminology?

• A.Information
• B.Database
• C.File
• D.Record

What is the correct ascending order of data hierarchy in computing systems?

• A.bit-field-byte-record-file-database
• B.bit-byte-record-field-file-database
• C.byte-bit-field-record-database-file
• D.bit-byte-field-record-file-database

Which of the following can be managed by a DBMS?

• A.Only hardware resources
• B.Only data values
• C.Only user permissions
• D.Field names and record structures

In a database management system, where are the metadata such as table names and field attributes stored?

• A.Data warehouse
• B.Data dictionary
• C.Data mart
• D.Data repository

What is the primary purpose of a Database Management Software (DBMS)?

• A.Storing, manipulating, and managing data
• B.Creating graphical user interfaces
• C.Managing network connections
• D.Compiling programming code

What is Meta-Data?

• A.Data stored in RAM
• B.Information about data
• C.Encrypted data
• D.Data transmitted over a network

What is the term used for a complete set of information stored in a database?

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