NEW
Font size
WorksheetsEDPM Form 4 – Databases Theory Quiz
Total questions: 25
Worksheet time: 19mins
Choose the correct answer. A database is best defined as:
A word processing file
A collection of related data stored electronically
A spreadsheet only
A hardware device
Choose the correct answer. Which software is an example of a Database Management System (DBMS)?
Microsoft Word
Microsoft Excel
Microsoft Access
Microsoft PowerPoint
Choose the correct answer. Data in a database is stored in:
Forms
Queries
Tables
Reports
Choose the correct answer. A record in a database table refers to:
A column of data
A row of data
The database name
A field type
Choose the correct answer. A field is best described as:
One row of data
One column of data
A table
A database
Choose the correct answer. Which key uniquely identifies each record in a table?
Foreign key
Primary key
Secondary key
Candidate key
Choose the correct answer. A foreign key is used to:
Uniquely identify records
Link two tables together
Delete records
Sort data
Choose the correct answer. Which database object is mainly used to retrieve specific data?
Table
Form
Query
Report
Choose the correct answer. Which type of query displays data without changing it?
Update query
Delete query
Select query
Action query
A student wants to change a field data type from Text to Number. Which view should be used?
Datasheet View
Design View
Form View
Report View
Choose the correct answer. A one-to-many relationship means:
One record relates to one record
Many records relate to many records
One record relates to many records
Records are unrelated
Choose the correct answer. Which relationship type requires a junction table?
One-to-one
One-to-many
Many-to-many
No relationship
Which view allows you to see the actual data stored in the table?
Design View
Design Preview
Datasheet View
Layout View
Choose the correct answer. Which field type is best for storing dates?
Text
Number
Date/Time
Yes/No
Which statement is TRUE?
Design View allows you to define field properties e.g.. Field size
Datasheet View is used to create table structure
Datasheet View cannot edit data
Design View displays records only
Choose the correct answer. Datasheet View is mainly used to:
Define table structure
Enter and edit records
Set primary keys
Change data types
Choose the correct answer. Design View is mainly used to:
View records
Print tables
Create and modify table structure
Enter data
Choose the correct answer. Which task is BEST done in Design View?
Typing records
Sorting data
Setting a primary key
Viewing data
Choose the correct answer. Which view displays data in rows and columns similar to a spreadsheet?
Design View
Datasheet View
Print Preview
Layout View
Choose the correct answer. In which view would you change a field’s data type?
Datasheet View
Design View
Form View
Report View
Choose the correct answer. Which view allows you to see the actual data stored in a table?
Design View
Datasheet View
Layout View
Print View
Choose the correct answer. A query can be based on:
Tables only
Reports only
One or more tables
Forms only
Choose the correct answer. A view of selected data without storing it permanently is created using a:
Table
Query
Form
Report
Which data type is used to store text or letters?
Date/Time
Number
Yes/ No
Short Text
Which of the following is TRUE about field data types?
A. Text fields can store numbers for calculations
B. Number fields can store words like names
C. Choosing the correct data type ensures correct storage and operations
D. Yes/No fields can store any text
Choosing the correct data type ensures correct storage and operations
Yes/No fields can store any text
Number fields can store words like names
Short/ Long Text fields can store numbers for calculations
