ITE 119 Qz 11 Module 11 Flashcards

1
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A.) queries

B.) forms

C.)reports

D.) cells

A

D.) cells

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A.) forms

B.) reports

C.) tables

D.) queries

A

C.) tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

C.) database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A.) field

B.) search

C.) query

D.) filter

A

C.) query

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

D.) query

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A.) object key

B.) key

C.) primary key

C.) table key

A

C.) primary key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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.

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

The columns in a table are called ____.

A.) fields

B.) records

C.) forms

D.) spreadsheets

A

A.) fields

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

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

A

C.) Query by Example (QBE)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

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

A

C.) normalization

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

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

A

C.) tables and fields

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

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

24
Q

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

25
Q

A data definition language is used to define the ____ of a database.

A.) QBE

B.) data and relationships

C.) size

D.) model

A

B.) data and relationships

26
Q

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

27
Q

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

28
Q

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

29
Q

A database ____ is a graphical representation of the structure of a database.

A.) schema

B.) index

C.) data type

D.) DDL

A

A.) schema

30
Q

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

A

C.) MS Access

31
Q

The data manipulation language ____ is a popular tool when querying a relational database.

A.) SQL

B.) C++

C.) HTML

D.) CSS

32
Q

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

A.) the names of data items

33
Q

In a database, a collection of related records is referred to as a table or a ____.

A.) field

B.) record

C.) file

D.) unit

34
Q

To avoid data ____, a database stores data in one place.

A.) redundancy

B.) verification

C.) integrity

D.) validation

A

A.) redundancy

35
Q

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

36
Q

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

37
Q

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

38
Q

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

39
Q

Data ____ refers to the quality and accuracy of the data.

A.) warehousing

B.) redundancy

C.) modification

D.) integrity

A

D.) integrity

40
Q

A primary key is a ____ within a database table that uniquely identifies each record.

A.) field

B.) record

C.) file

D.) unit

41
Q

The iTunes library is based on database technology.
True
False

42
Q

____ 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

A

C.) Privacy

43
Q

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

A

B.) duplicate records are not stored in the database

44
Q

Useful ________ is data organized in some meaningful way.

A.) structure

B.) hierarchy

C.) inventory

D.) information

A

D.) information

45
Q

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

A

C.) database management system

46
Q

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

A

C.) primary key

47
Q

Relationships between tables can be illustrated through a(n) ____ relationship diagram.

A.) field

B.) file

C.)record

D.) entity

A

D.) entity

48
Q

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

49
Q

In a database, first name would be an example of a ____.

A.) field

B.) record

C.) file

D.) unit

50
Q

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

51
Q

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

52
Q

Ethical issues around the subject of big data generally center on the issue of ________.

A.) piracy

B.) pornography

C.) privacy

D.) storage requirements

A

C.) privacy

53
Q

____ involves combining two or more tables.

A.) Joining

B.) Relating

C.) Querying

D.) Normalizing

A

A.) Joining

54
Q

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

A.) special-purpose

55
Q

A(n) ____ database organizes data into multiple tables that are related by common fields.

A.) hierarchical

B.) object-oriented

C.) flat file

D.) relational

A

D.) relational

56
Q

A ____ is a collection of data that has been organized to meet users’ needs.

A.) file

B.) database

C.) relationship

D.) snippet

A

B.) database

57
Q

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

A

B.) record