35 questions
Which of the following tasks is a type of data maintenance that should be performed on a database?
Adding Records
Modifying Records
Deleting Records
All of the Above
Databases that require immediate updating of data use this type of processing to keep records up to date.
Transnational Processing
Transitional Processing
Translational Processing
Transversal Processing
This type of processing is typically performed when the computer is idle.
Bunch Processing
Batch Processing
Base Processing
Balanced Processing
This is a form of data processing that is commonly used with Internet credit card purchases.
Online Transactional Processing
Online Transitional Processing
Online Traditional Processing
Online Transversal Processing
When a new student enrolls at a school, what must be added to the school's database to store information about that student?
A New Field
A New Table
A New Record
A New Process
This database feature lets you view one record at a time.
Table
Object
Field
Form
This is a question you ask a database.
Query
Form
Filter
Option
This tool enables you to create queries that a database can understand.
Query Engine
Query Form
Query Language
Query Syntax
Queries in this language usually start with a "select" command.
QBE
SQL
SBE
SSD
This query language lets you provide an example of the data you are seeking.
QBE
SQL
SBE
SSD
This database tool hides some records from view, reducing the amount of data you must review.
Form
Filter
Query
Language
Within a database's data structure, the data type determines the order in which the fields will appear in each record.
True
False
Many database programs have predesigned data structures that you can customize.
True
False
Generally, a database is used only by the person who created it and not by anyone else.
True
False
A prompt caption is a message that appears on-screen to help the person entering data understand the content of a field.
True
False
Because databases can become very large and complex, you cannot change the data structure once it has been saved.
True
False
In a database, if a number cannot be used in a calculation, it is considered text.
True
False
A database can automatically assign a number to each record, which might be used as an identification number.
True
False
Because databases are computerized, they do not need to be maintained.
True
False
Batch processing and transactional processing are methods for updating the data in a database.
True
False
In transactional processing, the database is updated as events take place.
True
False
Once data has been entered into a database, it cannot be changed.
True
False
Instead of deleting unneeded records from a database, it may be more logical to move them out of an active table and into an inactive table, so they remain available.
True
False
A query is a tool you can use to search for specific records in a database.
True
False
The term SQL stands for Standardized Query Language.
True
False
Many databases let you create queries that search whole fields or just parts of fields to find specific pieces of data.
True
False
This defines the fields in a database and determines what kind of information each record can hold.
Data Specification
Data Structure
Data Sequence
Data System
This uniquely identifies each field in a record.
Field Sequence
Field Width
Field Type
Field Name
This determines the kinds of information a database's fields will hold.
Data Type
Data Structure
Data Sort
Data Style
What is the first step in creating a database?
Create the Tables
Identify the Fields
Identify the Database
Save the Data Structure
This database feature ensures that the data entered in a field looks a certain way.
Default Value
Input Mask
Prompt Caption
Validation Rule
This database feature determines what data is acceptable for a given field.
Prompt Caption
Validation Rule
Input Mask
Data Structure
Which of the following common data types is used for data such as a name or an address?
Text
Number
Memo
Object
This data type is used when a field should contain only one of two possible values, such as on or off.
Autonumber
Text
Object
Logical
This data type is used when a field must contain an item such as an image or a video.
Hyperlink
Object
Memo
Logical