CSS - PMS - CCE - PCS - Basic Computing
Database Basics
A relational database stores data mainly in:
A. Tables
B. Audio files
C. Web browsers
D. Flowcharts
Correct Answer: A
Relational databases organize data into tables made of rows and columns.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Who introduced the relational database model?
A. Charles Babbage
B. E. F. Codd
C. Tim Berners-Lee
D. Bill Gates
Correct Answer: B
Edgar F. Codd proposed the relational model while working at IBM.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
The process of returning a database to a usable state after failure is called:
A. Recovery
B. Sorting
C. Filtering
D. Indexing
Correct Answer: A
Database recovery restores data and consistency after hardware, software, or user failure.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
A copy of database data kept for protection against loss is called a:
A. Backup
B. Join
C. View
D. Constraint
Correct Answer: A
A backup is a separate copy of database data used to restore information after loss or damage.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
In applications such as Microsoft Access, a form is mainly used to:
A. Enter and view data through a user-friendly interface
B. Replace the operating system
C. Compress the database
D. Create network cables
Correct Answer: A
A form provides a convenient interface for users to enter, edit, and view records.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
A formatted presentation of database information is usually called a:
A. Report
B. Key
C. Index
D. Constraint
Correct Answer: A
A report presents database information in a readable, printable, or summarized format.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
A request used to retrieve or manipulate database data is called a:
A. Query
B. Driver
C. Pixel
D. Folder
Correct Answer: A
A query is an instruction or set of instructions used to retrieve or modify data in a database.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which is an important advantage of using a DBMS?
A. Increased uncontrolled duplication
B. Improved data sharing and security
C. Removal of all hardware requirements
D. Elimination of every possible error
Correct Answer: B
A DBMS improves controlled data sharing, security, integrity, backup, and concurrent access.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
When duplicated copies of the same data do not match, the problem is called:
A. Data consistency
B. Data inconsistency
C. Data security
D. Data validation
Correct Answer: B
Data inconsistency occurs when different copies of the same data contain conflicting values.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Unnecessary duplication of data is known as:
A. Normalization
B. Redundancy
C. Encryption
D. Validation
Correct Answer: B
Data redundancy means storing the same fact in multiple places without a valid need.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database component stores information about tables, fields, and constraints?
A. Data dictionary
B. Recycle bin
C. Clipboard
D. Print queue
Correct Answer: A
A data dictionary stores metadata describing database objects and their properties.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Data that describes other data is called:
A. Metadata
B. Redundant data
C. Binary data
D. Temporary data
Correct Answer: A
Metadata is data about data, such as column names, data types, table definitions, and constraints.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
The actual data stored in a database at a particular moment is called the database:
A. Schema
B. Instance
C. Model
D. Dictionary
Correct Answer: B
A database instance is the current collection of data stored in the database at a specific time.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
The overall logical design of a database is called its:
A. Instance
B. Schema
C. Backup
D. Query
Correct Answer: B
A schema defines the structure of the database, including tables, fields, relationships, and constraints.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
A database table is also known as a:
A. Relation
B. Loop
C. Module
D. Procedure
Correct Answer: A
In the relational model, a table is called a relation.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
In a database table, a column is commonly called a:
A. Record
B. Field
C. Transaction
D. Report
Correct Answer: B
A column is a field or attribute that stores one type of data, such as Name or DateOfBirth.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
In a database table, a row is commonly called a:
A. Field
B. Record
C. Query
D. Schema
Correct Answer: B
A row represents one complete record or tuple, such as the details of one student.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Processed data that is meaningful to a user is called:
A. Noise
B. Information
C. Metadata
D. Redundancy
Correct Answer: B
Information is processed, organized, or interpreted data that is meaningful and useful.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Raw facts and figures are called:
A. Information
B. Data
C. Knowledge
D. Reports
Correct Answer: B
Data consists of raw facts and figures. When data is processed and given meaning, it becomes information.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which of the following is the main purpose of a DBMS?
A. To design computer hardware
B. To manage and retrieve stored data
C. To create internet connections
D. To scan computer viruses
Correct Answer: B
A DBMS manages stored data and provides controlled methods for inserting, retrieving, updating, and deleting it.