Deck 11: Information and Data Management: Organizing, Verifying, Maintaining, and Accessing

Question 1

In the database pictured in the accompanying figure, which of the following is a combination of one or more related characters or bytes and is the smallest unit of data a user accesses?

A) field
B) member
C) record
D) identifier

Answer 1

A

Question 2

Many database programs perform which of the following in order to analyze entered data to help ensure that it is correct?

A) information confirmation
B) integration
C) validity check
D) integrity valuation

Answer 2

C

Question 3

Which of the following is a program with which users interact that generally has a more user-friendly interface than a DBMS?

A) back end
B) RDBMS
C) SQL
D) front end

Answer 3

D

Question 4

Which of the following is a collection of data organized in a manner that allows access, retrieval, and use of that data?

A) database
B) server
C) spreadsheet
D) webbase

Question 5

Which of the following languages consists of simple, English-like statements that allow users to specify the data to display, print, or store?

A) report
B) query
C) specification
D) inquiry

Question 6

Which of the following is a collection of related records, as shown in the accompanying figure, stored on storage media such as a hard drive or optical disc?

A) validator
B) rubric
C) set
D) file

Question 7

Which of the following is a number(s) or character(s) that is appended to or inserted into a primary key field?

A) check digit
B) index
C) insertion ordinal
D) integer

Question 8

Which of the following identifies the quality of data in a database?

A) file resolution
B) authenticated access
C) information dimensionality
D) data integrity

Question 9

Which of the following kinds of programs interacts with a DBMS, which in turn interacts with the database?

A) before image
B) front end
C) after image
D) back end

Question 10

Most DBMSs include a feature, as shown in the middle image within the accompanying figure, which has a graphical user interface to assist users with retrieving data. What is this feature called?

A) QBA
B) SQL
C) QBE
D) schema

Question 11

Which of the following refers to the procedures that keep data current?

A) file maintenance
B) authentication integrity
C) data validation
D) information checking

Question 12

An application that supports a front-end program sometimes is called which of the following?

A) back end
B) RDBMS
C) GUI
D) collaborative database

Question 13

A DBMS uses which of the following to perform validation checks?

A) data server
B) data mart
C) data warehouse
D) data dictionary

Question 14

Which of the following is a window on the screen that provides areas for entering or changing data in a database?

A) form
B) report
C) change screen
D) recovery screen

Question 15

Which of the following kind of checks is a validity check performed on data, like that in the accompanying figure, which ensures users enter only numeric data into a field?

A) range
B) numeric
C) completeness
D) consistency

Question 16

Which of the following is a request for specific data from a database?

A) query
B) index
C) ask
D) inquiry

Question 17

Which of the following kind of checks is a validity check performed on data, like that in the accompanying figure, which ensures users enter only alphabetic data into a field?

A) alphabetic
B) numeric
C) range
D) consistency

Question 18

Which of the following kinds of values is the one that a DBMS initially displays in a field?

A) query
B) start
C) initial
D) default

Question 19

Which of the following kind of checks is a validity check on data like that in the accompanying figure, which determines whether a number is within a specified group of numbers?

A) group
B) numeric
C) range
D) integer

Question 20

What is the process of comparing data with a set of rules or values to find out if the data is correct?

A) concatenation
B) validation
C) digit checking
D) integration

Question 21

Which of the following consists of rules and standards that define how a database organizes data?

A) data standard
B) data model
C) rules-based integration
D) object-relation

Question 22

Which of the following, with regard to the entire database, should be made on a regular basis?

A) backup
B) baseline
C) after image
D) retread

Question 23

The developer of a relational database refers to a field as which of the following?

A) tuple
B) attribute
C) key
D) relation

Question 24

Most of this kind of database products for servers and mainframes include SQL, an example of which is shown in the accompanying figure. What kind of database product is this?

A) relational
B) object-oriented
C) multidimensional
D) file processing

Question 25

Which of the following is true in a relational database?

A) Each row and each column has a primary key.
B) Each row has a unique name and each column has a primary key.
C) Each row has a primary key and each column has a unique name.
D) Each row and each column has a unique name.

Question 26

The developer of a relational database refers to a record as which of the following?

A) tuple
B) field
C) attribute
D) relation

Question 27

Which of the following kinds of backup are used by organizations such as hospitals, communications companies, and financial institutions?

A) dynamic
B) interactive
C) collaborative
D) continuous

Question 28

In what kind of recovery does the DBMS use the log to undo any changes made to a database during a certain period?

A) backward
B) restorative
C) undo
D) model

Question 29

In what kind of recovery does the DBMS use the log to reenter changes made to a database since the last save or backup?

A) instant
B) baseline
C) integrated
D) forward

Question 30

A user of a database such as that pictured in the accompanying figure refers to a field as what?

A) table
B) column
C) row
D) relationship

Question 31

The developer of a relational database refers to a file as which of the following?

A) attribute
B) record
C) relation
D) tuple

Question 32

Which of the following privileges for data involve establishing who can enter new data, change existing data, delete unwanted data, and view data?

A) viewing
B) writing
C) reading
D) access

Question 33

A checkout clerk with this level of privileges to the email addresses in a discount warehouse database could view the addresses but not change them. What is this level of privileges called?

A) read-only
B) write-only
C) full-update
D) no access

Question 34

A user of a database such as that pictured in the accompanying figure refers to a file as what?

A) table
B) column
C) row
D) relationship

Question 35

As shown in the accompanying figure, which of the following is a query language that allows users to manage, update, and retrieve data?

A) XML
B) DBMS
C) SQL
D) QBE

Question 36

A form that sends entered data across a network or the Internet is called which of the following terms?

A) i-form
B) e-form
C) webform
D) server form

Question 37

Which of the following is a database that stores data in tables that consist of rows and columns?

A) object-oriented
B) tabular
C) relational
D) attribute-based

Question 38

A user of a database such as that pictured in the accompanying figure refers to a record as what?

A) table
B) column
C) row
D) relationship

Question 39

In a database such as that pictured in the accompanying figure, users can set up a relationship between tables at any time, but the tables must have which of the following in common?

A) a record
B) a row
C) a column
D) a key

Question 40

In a database such as that pictured in the accompanying figure, which of the following is a connection within the data?

A) table
B) column
C) row
D) relationship

Question 41

Which of the following is a process designed to ensure the data within the relations (tables) contains the least amount of duplication?

A) concatenation
B) rasterization
C) dithering
D) normalization

Question 42

Which of the following stores data in objects?

A) ADB
B) OTDB
C) EDB
D) OODB

Question 43

Which kind of database stores data in dimensions?

A) hypermedia
B) hypercube
C) multidimensional
D) integrated

Question 44

COGNITIVE ASSESSMENT Which of the following is not considered a part of file maintenance?

A) adding a record to a database
B) modifying data in a record
C) the creation of a new database
D) deleting records from a database

Question 45

COGNITIVE ASSESSMENT What is the smallest unit of data the computer can process?

A) log
B) bit
C) reg
D) byte

Question 46

In managing a company's database, which of the following roles requires a technical inside view of data?

A) administrator
B) manager
C) modeler
D) leader

Question 47

Which of the following is an advantage of a multidimensional database?

A) There is a common query language.
B) The content of all dimensions is the same regardless of the subject.
C) It can consolidate data much faster than a relational database.
D) All multidimensional databases have a dimension of time.

Question 48

Compared with relational databases, which of the following is NOT true of object-oriented databases?

A) They can store more types of data.
B) They access data faster.
C) They allow programmers to reuse objects.
D) They store unstructured information less efficiently.

Question 49

COGNITIVE ASSESSMENT Which of the following is not one of the qualities associated with identifying the value of information?

A) accurate
B) verifiable
C) useful
D) expensive

Question 50

COGNITIVE ASSESSMENT To what does the term GIGO refer?

A) software used to create databases
B) global information
C) file processing
D) data integrity

Question 51

COGNITIVE ASSESSMENT Which of the following is not a way that a DBMS deals with deleting records from a database?

A) remove the record from the file immediately
B) records cannot be deleted from a DBMS
C) flags the record so that the DBMS will not process it again
D) running a program to remove records that have been marked as deleted

Question 52

Object-oriented and object-relational databases often use a query language to manipulate and retrieve data. What is the name of this query language?

A) OQL
B) SQL
C) TQL
D) AQL

Question 53

Which of the following is an item that contains data, as well as the actions that read or process the data?

A) object
B) hyperlink
C) action link
D) event

Question 54

Which of the following is a huge database that stores and manages the data required to analyze historical and current transactions?

A) data stockyard
B) data warehouse
C) data storehouse
D) data storage unit

Question 55

COGNITIVE ASSESSMENT In your school's database, in which of the following is all of the information about a particular student stored?

A) a field
B) a character
C) a record
D) a report

Question 56

COGNITIVE ASSESSMENT Which of the following statements about data types is not true?

A) Yes/No fields can be used to create a field with True or False options.
B) AutoNumber data types assign numbers automatically to each record.
C) Text data types are used for lengthy memos.
D) Object data types are used for photos, audio, or video.

Question 57

In a relational database, where does the only data redundancy exist?

A) in the hypermedia
B) in the fields
C) in the hypertext
D) in the relationships

Question 58

COGNITIVE ASSESSMENT In a database, what is the smallest unit of data a user accesses?

A) a field
B) a character
C) a record
D) a file

Question 59

COGNITIVE ASSESSMENT What is DBMS?

A) a file
B) information
C) software
D) a device

Question 60

COGNITIVE ASSESSMENT What is the term for a collection of data organized in a manner that allows access, retrieval, and use of that data?

A) a database
B) information
C) a DBMS
D) access

Question 61

COGNITIVE ASSESSMENT What is another term for data dictionary?

A) index
B) repository
C) file
D) table

Question 62

COGNITIVE ASSESSMENT Your database was damaged due to hardware failure. What can you use to restore it?

A) a backup
B) imaging software
C) restoration hardware
D) a wizard

Question 63

COGNITIVE ASSESSMENT What is the term for the process of comparing data with a set of rules or values to find out if the data is correct?

A) query
B) verification
C) procedure
D) validation

Question 64

COGNITIVE ASSESSMENT Which of the following is true about the database approach?

A) Data in a database is less vulnerable than data in file processing systems.
B) Unauthorized users are unable under any circumstances to gain access to a single database file that contains personal and confidential data.
C) Business and home users often work with databases because of their numerous advantages.
D) A database is never more complex than a file processing system.

Question 65

COGNITIVE ASSESSMENT What was Megan's Law designed to do?

A) predict the accuracy of data in a database and ways to improve the data integrity
B) create a list of names and addresses of people convicted of crimes against children
C) compile a list of database techniques and processes to share with DBMS users
D) make unauthorized access or data entry in a database illegal

Question 66

COGNITIVE ASSESSMENT Complex DBMSs maintain a listing of activities that modify the contents of a database. What is this listing called?

A) recovery disk
B) backup
C) index
D) log

Question 67

COGNITIVE ASSESSMENT What is a more user-friendly interface some users use instead of interacting directly with a DBMS?

A) front end
B) user environment
C) home page
D) data file

Question 68

COGNITIVE ASSESSMENT Which of the following statements is not true about report writers?

A) You use a report writer only to retrieve data.
B) Report writers usually allow you to format page numbers and dates; titles and column headings; subtotals and totals; and fonts, font sizes, color, and shading.
C) The capability of creating reports is rare in a DBMS.
D) Some report writers allow you to include images.

Question 69

COGNITIVE ASSESSMENT While working with a database, you encounter a wizard. What best describes the purpose of a wizard?

A) guides you through the steps of creating a database object
B) the database creator and administrator
C) a screen in which you enter or modify data
D) the instructions that control how the data in the database is connected

Question 70

COGNITIVE ASSESSMENT Which of the following statements best describes a form?

A) a window on the screen that provides areas for entering or modifying data in a database
B) a formatted, printable retrieval of specific data
C) a screen that enables a database user to add or delete tables
D) the opening screen in a DBMS in which the user logs in to achieve authorization to modify or retrieve data

Question 71

COGNITIVE ASSESSMENT A data dictionary contains details about data. What term is used to describe this characteristic?

A) omnidata
B) maxidata
C) metadata
D) duplidata

Question 72

COGNITIVE ASSESSMENT You are creating a database for your computer club. Most of the students live in your town, Durham. How can you make Durham appear initially in the field to make data entry easier?

A) make the field a maximum of size characters
B) make it the default value
C) use AutoComplete
D) add a drop-down box

Question 73

COGNITIVE ASSESSMENT If you are running a check to ensure that a required field contains data, or the correct minimum number of characters, what kind of check are you running?

A) completeness
B) alphabetic
C) range
D) check digit

Question 74

COGNITIVE ASSESSMENT Which term is used to describe the practice that users' access privileges are limited to the lowest level necessary to perform required tasks?

A) theory of restriction
B) principle of least privilege
C) hierarchy of administration
D) protocol of access

Question 75

COGNITIVE ASSESSMENT Which of the following does not improve with the database approach?

A) data integrity
B) data sharing
C) access
D) data security

Question 76

COGNITIVE ASSESSMENT What is data redundancy?

A) There is no primary key to distinguish records.
B) Each department has its own files, so the same data might be stored in multiple files.
C) Data is linked to multiple records in a database.
D) In the same database, each department enters data without checking to ensure it has not already been entered.

Question 77

COGNITIVE ASSESSMENT Which of the following statements is NOT true about the database approach?

A) The database approach allows nontechnical users to access and maintain data.
B) Databases require more memory, storage, and processing power than file processing systems.
C) A disadvantage to the database approach is isolated data.
D) The database approach increases the data's integrity.

Question 78

COGNITIVE ASSESSMENT What database term is used to describe a request for specific data from the database?

A) information
B) retrieval
C) analysis
D) query

Question 79

COGNITIVE ASSESSMENT If you are running a check that applies a formula to the primary key, what kind of check are you running?

A) completeness
B) alphabetic
C) range
D) check digit

Question 80

COGNITIVE ASSESSMENT What does the S in SQL stand for?

A) Server
B) System
C) Structured
D) Serial