ITE 119 Qz 11 Module 11 Flashcards
In Access, the Quick Access pane lists all database objects, such as tables, queries, forms, and reports.
True
False
False
All of the following objects are found in a database EXCEPT ____.
A.) queries
B.) forms
C.)reports
D.) cells
D.) cells
In Access, each type of object has an identifying icon. For ____, the icon is a grid.
A.) forms
B.) reports
C.) tables
D.) queries
C.) tables
Each record contains data relating to a single entity.
True
False
True
A report is a formatted printout that can summarize specified data in a database.
True
False
True
The best software tool to use for monitoring daily business operations and quickly comparing expected activity to actual performance is a ____.
A.) word processor
B.) spreadsheet
C.) database
D.) file manager
C.) database
When you perform an online search to determine available classes to take at your college, you are searching a database.
True
False
True
A ____ is a request to retrieve information stored from a database.
A.) field
B.) search
C.) query
D.) filter
C.) query
In Access, queries are templates generally used to enter records into a database.
True
False
False
If you wanted to determine which of the people in your database live in Oregon, you would construct a(n) ____ to obtain the answer.
A.) form
B.) object
C.) unique identifier
D.) query
D.) query
Microsoft Access is the perfect tool to use to analyze your grades for the semester and calculate your current grade point average in class.
True
False
False
In a database record, a unique username can also be identified as the ____.
A.) object key
B.) key
C.) primary key
C.) table key
C.) primary key
Access requires you to create and name a new table before you start any work.
True
False
False
Access allows you to use the Undo key to reverse almost any action you perform.
True
False
False
You open Access and click to select a new blank database. What should you do next?
A.) Create and name a new table.
B.) Create fields in the database to facilitate record entry.
C.) Name the database and save it to the hard disk for storage.
D.) Determine whether a template would better suit your needs.
C.) Name the database and save it to the hard disk for storage ???
A newly-created database in Access opens to the Form window, ready to start setting up the contents.
True
False
False
The columns in a table are called ____.
A.) fields
B.) records
C.) forms
D.) spreadsheets
A.) fields
Query wizards and ____ automate the process of writing SQL commands in a relational database.
A.) DDL
B.) PHP
C.) Query by Example (QBE)
D.) DML
C.) Query by Example (QBE)
When a database problem occurs, its tables may be split up during the ____ process to correct a data problem.
A.) GIGO
B.) visualization
C.) normalization
D.) data integrity
C.) normalization
Database tools include software and techniques for analyzing, maintaining, and manipulating data in a database.
True
False
True
A schema illustrates the ____ and ____ in a database and the relationships among them.
A.) records and fields
B.) bits and bytes
C.) tables and fields
D.) rows and columns
C.) tables and fields
A data dictionary provides a detailed description of each field and table in a database.
True
False
True
One of the first steps in creating a database is to build queries and reports that can pull information from the data that is stored.
True
False
False
SQL is one example of a data manipulation language.
True
False
True
A data definition language is used to define the ____ of a database.
A.) QBE
B.) data and relationships
C.) size
D.) model
B.) data and relationships
In 1986, the American National Standards Institute (ANSI) adopted ____ as the standard query language for relational databases.
A.) QBE
B.) DDL
C.) Schema
D.) SQL
D.) SQL
Inaccurate input entered into a database resulting in incorrect output is also known as ____.
A.) data failure
B.) GIGO
C.) data redundancy
D.) normalized data
B.) GIGO
Data integrity refers to the quality of data: the degree to which it is accurate and up to date.
True
False
True
A database ____ is a graphical representation of the structure of a database.
A.) schema
B.) index
C.) data type
D.) DDL
A.) schema
A popular database software program called ____ offers a wizard and QBE tool to help build and generate SQL queries.
A.) MS Excel
B.) MS Data Manager
C.) MS Access
D.) ANSI
C.) MS Access
The data manipulation language ____ is a popular tool when querying a relational database.
A.) SQL
B.) C++
C.) HTML
D.) CSS
A.) SQL
A data dictionary typically includes which of the following?
A.) the names of data items
B.) a copy of the actual data
C.) an alphabetical listing of records
D.) the digital certificate
A.) the names of data items
In a database, a collection of related records is referred to as a table or a ____.
A.) field
B.) record
C.) file
D.) unit
C.) file
To avoid data ____, a database stores data in one place.
A.) redundancy
B.) verification
C.) integrity
D.) validation
A.) redundancy
Big data is a term used to refer to data sets that are too large to process through traditional means.
True
False
False
A primary key is always made up of only one field.
True
False
False
The most popular format for flat file databases is comma-separated values (CSV).
True
False
True
Online services such as Google and Amazon rely on data organized by databases.
True
False
True
Data ____ refers to the quality and accuracy of the data.
A.) warehousing
B.) redundancy
C.) modification
D.) integrity
D.) integrity
A primary key is a ____ within a database table that uniquely identifies each record.
A.) field
B.) record
C.) file
D.) unit
A.) field
The iTunes library is based on database technology.
True
False
True
____ is a concern for some organizations and individuals when data is collected in databases without their permission.
A.) Data redundancy
B.) Data collection
C.) Privacy
D.) Integrity
C.) Privacy
Primary keys ensure that ____.
A.) all of the data is 100 percent accurate
B.) duplicate records are not stored in the database
C.) the data can be normalized
D.) records are not accidentally deleted
B.) duplicate records are not stored in the database
Useful ________ is data organized in some meaningful way.
A.) structure
B.) hierarchy
C.) inventory
D.) information
D.) information
A ________ is a set of programs that manipulate the data within a database.
A.) data definition language
B.) data manipulation language
C.) database management system
D.) query by example
C.) database management system
In a relational database, a ____ would ensure that two customers with the same name don’t get confused with each other.
A.) flat file
B.) query
C.) primary key
D.) relationship
C.) primary key
Relationships between tables can be illustrated through a(n) ____ relationship diagram.
A.) field
B.) file
C.)record
D.) entity
D.) entity
Increased data redundancy is one of the primary advantages of using a database.
True
False
False
In a database, first name would be an example of a ____.
A.) field
B.) record
C.) file
D.) unit
A.) field
Data integrity refers to the quality and accuracy of the data.
True
False
True
The ability to connect data in different tables through a common field is sometimes referred to as a relationship.
True
False
True
Ethical issues around the subject of big data generally center on the issue of ________.
A.) piracy
B.) pornography
C.) privacy
D.) storage requirements
C.) privacy
____ involves combining two or more tables.
A.) Joining
B.) Relating
C.) Querying
D.) Normalizing
A.) Joining
Microsoft Outlook and Quicken are examples of ____ DBMSs that are used to store and manipulate personal data.
A.) special-purpose
B.) flat
C.) multi-user
D.) single-user
A.) special-purpose
A(n) ____ database organizes data into multiple tables that are related by common fields.
A.) hierarchical
B.) object-oriented
C.) flat file
D.) relational
D.) relational
A ____ is a collection of data that has been organized to meet users’ needs.
A.) file
B.) database
C.) relationship
D.) snippet
B.) database
In a database, a collection of related fields that describes some object or activity is referred to as a ____.
A.) field
B.) record
C.) file
D.) unit
B.) record
