NEW
Font size
WorksheetsDatabase Management System
Total questions: 25
Worksheet time: 13mins
Which statement best describes a database?
a A collection of tables.
Tables that are in sequence.
Tables of related information.
A collection of related tables.
What does the acronym DBMS stands for?
Data Bypass Management System
Database Management System
Digital Base Management System
All of the above
All of the following are data type except?
Name
Memo
Short text
Number
Which of the following is a database object?
Record
Field
Report
Query wizard
_____________is a type of database that stores data physically.
Object database
Electronic Database
Manual Database
Hybrid Database
In what view is the table being displayed?
Design view
Datasheet view
Normal view
Print Preview
What is the program that enables you to create, access and manage electronic database called?
Database
Data Structure
Operating system
Database Management System.
What is another name for the Secondary key field?
Foreign key
Primary key
Alternate key
Candidate key.
Which field in a database table is an automatic field?
ID
Name
Address
Date of Birth
All of the following are examples of Database Management System software except?
Microsoft Access
MySQL
Oracle
FaxBass
______________ is a collection of related fields.
Table
Record
Field
Form
Which key ensure that data in a field must only appear once in the whole table.
Candidate key field
Foreign key
Primary key field
Alternate key field
____________ is where information is stored in a database.
Query
Report
Tables
Microsoft Access
____________allow you to enter, store, analyze, and compile your data however you want.
DBMS
Forms
DBMS Objects
Tables
A table is a collection of records, made of a set of columns called records and a set of rows called fields.
True
False
The linking of tables and files to share records is known as a______________.
Form
Relationship
Foreign key
None of the above
____________are used for entering, modifying, and viewing records.
Tables
Forms
Database objects
View
The image above is an example of generating which database object?
Form
Report
Query
Table
______________offer you the ability to present your data in print.
Report
MS Word
Form
MS Access
Each of these objects interacts with the records stored in your database's ___________________.
Table, Form, Query, Report
Table, Query, Form
Form, Report, Query
Report, Query, Table
__________is the individual properties of an entity. An __________ is represented by a field in a database.
Tuple
Field
Record
Attributes
A ___________ describes what is in the field. This description is displayed in the status bar when you select this field on the form.
Field type
Field size
Field Description
All of the above
The details about a particular entity are called a _________ . A ____________ is represented by a record in a database.
Field Description
Tuple
Field type
Attribute
An ____________is an item in the real world that is represented in a database.
Manual Database
Field name
Entity
Records
The image above is a representation of which database object?
Query
Report
Form
Table in design view
