Deck 10: Database Management

Question 1

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

Answer 1

A

Question 2

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

Answer 2

C

Question 3

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

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

Answer 3

A

Question 4

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 5

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

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 disk or optical disc?

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

Question 7

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 8

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 9

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 10

Most DBMSs include a feature, as shown in 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

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

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

Question 13

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

Question 14

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 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

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

Question 17

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 18

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 19

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 20

A checkout clerk with this level of privileges to the e-mail 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 21

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

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

Question 22

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 23

In a log, a DBMS places which of the following?

A) a copy of a record prior to a change
B) the actual change to a record
C) a copy of a record after a change
D) all of the above

Question 24

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 25

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 26

In a relational 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 27

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

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

Question 28

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 29

Which of the following stores data in objects?

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

Question 30

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 31

In a relational 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 32

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

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

Question 33

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 34

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 35

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 36

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

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

Question 37

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 38

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

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

Question 39

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

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

Question 40

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 41

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 42

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

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

Question 43

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 44

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 45

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 46

Most of these 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) all of the above

Question 47

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 48

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 49

Which kind of database stores data in dimensions?

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

Question 50

Compared with relational databases, which of the following is 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) all of the above

Question 51

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 52

COGNITIVE ASSESSMENT What is DBMS?

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

Question 53

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 of the above

Question 54

COGNITIVE ASSESSMENT If you are working with Equifax, Experian, or TransUnion, what are you trying to accomplish?

A) transfer funds electronically
B) verify your credit report
C) send an electronic telegram
D) retrieve data from a database

Question 55

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 utility to remove records that have been marked as deleted

Question 56

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

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

Question 57

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 58

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 59

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 60

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, video, or documents stored as bitmaps.

Question 61

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 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 a more user-friendly interface some users use instead of interacting directly with a DBMS?

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

Question 64

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 65

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 appreoach is isolated data.
D) The database approach increases the data's integrity.

Question 66

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 67

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 68

COGNITIVE ASSESSMENT You are creating a database for your computer clu b. 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 69

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 70

COGNITIVE ASSESSMENT Which database vendor has the largest market share?

A) Microsoft
B) IBM
C) Sybase
D) Oracle

Question 71

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) the theory of restriction
B) the principle of least privilege
C) the hierarchy of administration
D) the protocol of access

Question 72

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

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

Question 73

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 74

COGNITIVE ASSESSMENT Define 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 hasn't already been entered.

Question 75

COGNITIVE ASSESSMENT Which database vendor created the Access database program?

A) Microsoft
B) IBM
C) Sybase
D) Oracle

Question 76

COGNITIVE ASSESSMENT After a power failure, you instruct the DBMS to use the log to reenter any changes made to the database since the last save or backup. What term is used to describe this backup technique?

A) restoration principle
B) forward recovery
C) continuous backup
D) rollback

Question 77

COGNITIVE ASSESSMENT Which of the following statements is not true about e-forms?

A) The E stands for electronic.
B) E-forms are used to send entered data across a network or the Internet.
C) The capability of creating e-forms is rare in a DBMS.
D) E-forms generally use a means to secure the data while it is transported across the network.

Question 78

COGNITIVE ASSESSMENT What is another term for data dictionary?

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

Question 79

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 80

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