NEW
Font size
WorksheetsChapter 7 Database
Total questions: 36
Worksheet time: 18mins
Which of the following best defines a "Database"?
A software used only for writing documents.
Processed data that is meaningful and useful.
A collection of data organized in a manner that allows access, retrieval, and use of that data.
A physical device used to store paper files.
What is the key difference between "Data" and "Information"?
Data is processed; Information is unprocessed.
Data is a collection of unprocessed items; Information is processed data that is meaningful.
Data includes video and audio; Information only includes text.
There is no difference; they are the same.
What does an "Entity Relationship" represent?
The cost of the database software.
An abstract and conceptual representation of data.
The hierarchy of characters and bits.
A list of authorized users.
In the hierarchy of data, what is a "Character" defined as?
A group of related fields.
One byte (consisting of numbers, letters, space, or symbols).
A collection of databases.
The name of a table.
A "Field" is best described as:
One byte (number, letter, or symbol).
A collection of related records.
A combination of one or more related characters.
The entire database file.
A "Record" is defined as a group of related:
Files
Tables
Fields
Databases
What do we call a collection of related records?
A Data File (or Table)
A Character
A Field
A Query
What is a "Primary Key"?
A field that allows duplicate values in every row.
A field that uniquely identifies each record in a file.
A collection of unrelated characters.
The first field listed in every table.
Which property in the Primary Key settings ensures there are no duplicate entries?
Required: No
Field Size: 5
Indexed: Yes (No Duplicates)
Format: Text
Which of the following is a function of a Database Management System (DBMS)?
To edit video files.
To browse the internet.
To add, modify, delete, sort, and retrieve data.
To create operating systems.
Which role is responsible for creating and maintaining the data dictionary, managing security, and checking backup and recovery procedures?
Database Analyst (DA)
System Programmer
Database Administrator (DBA)
Network Administrator
Who is responsible for deciding on proper field placement, defining data relationships, and identifying users' access privileges?
The End User
The Database Analyst (DA)
The Database Administrator (DBA)
The Programmer
Which of the following is listed as an ADVANTAGE of using a database?
Increased data redundancy.
Improved data integrity.
Low hardware start-up costs.
Isolated data that cannot be shared.
What does "Improved Data Integrity" mean in the context of database advantages?
Data is scattered across multiple files.
When users modify data, they make changes to one file instead of multiple files.
Anyone can access the data without a password.
The database is cheaper to buy.
Which of the following is a DISADVANTAGE of a Database Management System (DBMS)?
Reduced development time.
Controlling data redundancy.
Improved security.
Complexity and requirement of specific programming skills.
Which of the following is another disadvantage of databases mentioned in the slides?
Shared Data.
Easier Access.
Substantial hardware and software start-up cost.
User-friendly interface.
Which of the following are the four main Database Objects mentioned in the slides?
Input, Output, Process, Storage.
Table, Query, Form, Report.
Field, Record, File, Database.
Text, Number, Date, Memo.
In a Table, data is arranged in:
Paragraphs and sentences.
Rows and Columns.
Slides and Transitions.
Circles and Squares.
Which database object is considered the "heart" of the database because it contains the actual data?
Report
Form
Query
Table
What is the primary function of a "Form"?
To print data in an easy-to-read format.
To enter data accurately and consistently.
To design the database structure.
To export data to other software.
Why might a user prefer entering data into a Form rather than a Table?
Forms are faster to print.
Forms let the user see entire records one at a time.
Forms can store more data than tables.
Forms do not require a primary key.
"Running a _______ is like asking a detailed question of your database."
Table
Form
Query
Report
Queries allow you to pull information from one or more tables based on:
A random selection.
The file size.
A set of search conditions you define.
The alphabetical order of field names.
Which database object gives the user the ability to present components in an easy-to-read, printable format?
Report
Query
Form
Macro
Which of the following is NOT a common Data Type listed in Microsoft Access?
Currency
Yes/No
Alphabetical
AutoNumber
Which data type would be most appropriate for storing monetary values (money)?
Text
AutoNumber
Currency
Memo
Which data type is used to store long text or comments?
Yes/No
Date/Time
Memo
Object
Which data type automatically generates a unique number for every new record added?
Number
AutoNumber
Hyperlink
Attachment
If you want to store a "True/False" or "On/Off" value, which data type should you use?
Text
Object
Yes/No
Hyperlink
When creating a query in Design View, what dialog box appears to let you choose tables?
Save As
Show Table
Print Preview
Property Sheet
In the Query Design View, which row is used to specify the conditions that data must meet to be displayed (e.g., City = "Nilai")?
Sort
Show
Criteria
Field
In the example given for a "One-Table Query," what specific action must be clicked to perform the actions specified in the query and see the results?
Save
View
Run
Delete
Which row in the Query Design grid allows you to arrange the results in Ascending or Descending order?
Sort
Show
Criteria
Table
To add a field to the Query Building Pane, you can:
Right-click the table.
Double-click the field name in the table box.
Press the F1 key.
Select "Print Preview".
A "One-Table Query" means:
The query creates a new table.
The query pulls data from only one table.
The query can only have one field.
The query has only one record.
Which database object allows you to "add, modify, and delete data" most effectively while maintaining data integrity?
A Report
A Query (Select only)
A DBMS (Software) via a Form or Table
A Primary Key
