NEW
Font size
WorksheetsDatabase quiz part 1 - D2T4
Total questions: 20
Worksheet time: 10mins
1. Which of the following best describes a database?
A collection of unrelated data
A collection of related data
A spreadsheet with numbers
An application for emails
The main purpose of a DBMS is to:
Manage hardware devices
Store, retrieve, and manage data efficiently
Create websites
Compile programming code
Which is an example of a DBMS?
Microsoft Excel
MySQL
Google Chrome
Notepad
In a database, data is organized into:
Pages
Files only
Rows and columns
Webpages
Which of the following is NOT a database model?
Hierarchical model
Network model
Relational model
Browser model
The smallest unit of data in a database is called:
Record
Field
Bit
Byte
What is a primary key?
A field that can have duplicate values
A unique identifier for each record
A password for database login
A foreign field in a table
What does SQL stand for?
Structured Query Language
Simple Question Language
Sequential Query Language
Structured Quick Logic
In relational databases, a table is also called a:
Relation
Graph
Index
View
In a relational database, columns are also called:
Attributes
Tuples
Records
Files
Which of the following ensures data accuracy and consistency?
Data Redundancy
Data Integrity
Data Duplication
Data Corruption
Which of these is NOT an advantage of a database system?
Data security
Data duplication
Data sharing
Improved data access
In ER diagrams, a rectangle represents:
Attribute
Entity
Relationship
Key
Which of these is a disadvantage of file-based systems over DBMS?
Easier backup
Higher redundancy
Centralized control
Improved security
Which of these is NOT part of a database environment?
Hardware
Software
Users
Printers
What is the main purpose of a database?
to store and manage data
To play music
To design graphics
To browse the internet
Data in a relational database is stored in:
Files
Tables
Images
Charts
In database terminology, a record refers to:
A row in a table
A column in a table
The table name
The database file
A field in a database is also called:
Row
Attribute
Tuple
Index
What does ERD stand for?
Entity Record Diagram
Entity Relationship Diagram
Entity Relational Data
Entity Relationship Data
