ITE 119 Qz 11 Module 11

Question 1

In Access, the Quick Access pane lists all database objects, such as tables, queries, forms, and reports.
True
False

Answer 1

False

Question 2

All of the following objects are found in a database EXCEPT ____.

A.) queries

B.) forms

C.)reports

D.) cells

Answer 2

D.) cells

Question 3

In Access, each type of object has an identifying icon. For ____, the icon is a grid.

A.) forms

B.) reports

C.) tables

D.) queries

Answer 3

C.) tables

Question 4

Each record contains data relating to a single entity.
True
False

Answer 4

True

Question 5

A report is a formatted printout that can summarize specified data in a database.
True
False

Answer 5

True

Question 6

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

Answer 6

C.) database

Question 7

When you perform an online search to determine available classes to take at your college, you are searching a database.
True
False

Answer 7

True

Question 8

A ____ is a request to retrieve information stored from a database.

A.) field

B.) search

C.) query

D.) filter

Answer 8

C.) query

Question 9

In Access, queries are templates generally used to enter records into a database.
True
False

Answer 9

False

Question 10

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

Answer 10

D.) query

Question 11

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

Answer 11

False

Question 12

In a database record, a unique username can also be identified as the ____.

A.) object key

B.) key

C.) primary key

C.) table key

Answer 12

C.) primary key

Question 13

Access requires you to create and name a new table before you start any work.
True
False

Answer 13

False

Question 14

Access allows you to use the Undo key to reverse almost any action you perform.
True
False

Answer 14

False

Question 15

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.

Answer 15

C.) Name the database and save it to the hard disk for storage ???

Question 16

A newly-created database in Access opens to the Form window, ready to start setting up the contents.
True
False

Answer 16

False

Question 17

The columns in a table are called ____.

A.) fields

B.) records

C.) forms

D.) spreadsheets

Answer 17

A.) fields

Question 18

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

Answer 18

C.) Query by Example (QBE)

Question 19

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

Answer 19

C.) normalization

Question 20

Database tools include software and techniques for analyzing, maintaining, and manipulating data in a database.
True
False

Answer 20

True

Question 21

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

Answer 21

C.) tables and fields

Question 22

A data dictionary provides a detailed description of each field and table in a database.
True
False

Answer 22

True

Question 23

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

Answer 23

False

Question 24

SQL is one example of a data manipulation language.
True
False

Answer 24

True

Question 25

A data definition language is used to define the ____ of a database. A.) QBE B.) data and relationships C.) size D.) model

Answer 25

B.) data and relationships

Question 26

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

Answer 26

D.) SQL

Question 27

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

Answer 27

B.) GIGO

Question 28

Data integrity refers to the quality of data: the degree to which it is accurate and up to date. True False

Answer 28

True

Question 29

A database ____ is a graphical representation of the structure of a database. A.) schema B.) index C.) data type D.) DDL

Answer 29

A.) schema

Question 30

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

Answer 30

C.) MS Access

Question 31

The data manipulation language ____ is a popular tool when querying a relational database. A.) SQL B.) C++ C.) HTML D.) CSS

Answer 31

A.) SQL

Question 32

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

Answer 32

A.) the names of data items

Question 33

In a database, a collection of related records is referred to as a table or a ____. A.) field B.) record C.) file D.) unit

Answer 33

C.) file

Question 34

To avoid data ____, a database stores data in one place. A.) redundancy B.) verification C.) integrity D.) validation

Answer 34

A.) redundancy

Question 35

Big data is a term used to refer to data sets that are too large to process through traditional means. True False

Answer 35

False

Question 36

A primary key is always made up of only one field. True False

Answer 36

False

Question 37

The most popular format for flat file databases is comma-separated values (CSV). True False

Answer 37

True

Question 38

Online services such as Google and Amazon rely on data organized by databases. True False

Answer 38

True

Question 39

Data ____ refers to the quality and accuracy of the data. A.) warehousing B.) redundancy C.) modification D.) integrity

Answer 39

D.) integrity

Question 40

A primary key is a ____ within a database table that uniquely identifies each record. A.) field B.) record C.) file D.) unit

Answer 40

A.) field

Question 41

The iTunes library is based on database technology. True False

Answer 41

True

Question 42

____ 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

Answer 42

C.) Privacy

Question 43

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

Answer 43

B.) duplicate records are not stored in the database

Question 44

Useful ________ is data organized in some meaningful way. A.) structure B.) hierarchy C.) inventory D.) information

Answer 44

D.) information

Question 45

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

Answer 45

C.) database management system

Question 46

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

Answer 46

C.) primary key

Question 47

Relationships between tables can be illustrated through a(n) ____ relationship diagram. A.) field B.) file C.)record D.) entity

Answer 47

D.) entity

Question 48

Increased data redundancy is one of the primary advantages of using a database. True False

Answer 48

False

Question 49

In a database, first name would be an example of a ____. A.) field B.) record C.) file D.) unit

Answer 49

A.) field

Question 50

Data integrity refers to the quality and accuracy of the data. True False

Answer 50

True

Question 51

The ability to connect data in different tables through a common field is sometimes referred to as a relationship. True False

Answer 51

True

Question 52

Ethical issues around the subject of big data generally center on the issue of ________. A.) piracy B.) pornography C.) privacy D.) storage requirements

Answer 52

C.) privacy

Question 53

____ involves combining two or more tables. A.) Joining B.) Relating C.) Querying D.) Normalizing

Answer 53

A.) Joining

Question 54

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

Answer 54

A.) special-purpose

Question 55

A(n) ____ database organizes data into multiple tables that are related by common fields. A.) hierarchical B.) object-oriented C.) flat file D.) relational

Answer 55

D.) relational

Question 56

A ____ is a collection of data that has been organized to meet users’ needs. A.) file B.) database C.) relationship D.) snippet

Answer 56

B.) database

Question 57

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

Answer 57

B.) record