Deck 11: Building Solutions

Question 1

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 1

D

Question 2

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 2

A

Question 3

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

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

Answer 3

D

Question 4

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 5

Which of the following does a back end interact with?

A) DBNS
B) DBMS
C) BDNS
D) BDMS

Question 6

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

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

Question 7

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 8

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

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

Question 9

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 10

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 on cloud storage?

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

Question 11

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 12

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 13

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

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

Question 14

What is the process of comparing data with a set of rules or values to determine if the data meets certain criteria?

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

Question 15

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

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

Question 16

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

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

Question 17

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

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

Question 18

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 19

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 20

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 21

What is another term used for data dictionary?

A) archive
B) cache
C) repository
D) relation

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

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 25

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 26

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 27

In a database which of the following is a connection within the data?

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

Question 28

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 29

SQL stands for which of the following?

A) Structured Query Language
B) Statement Query Language
C) Standard Query Language
D) Student Query Language

Question 30

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 31

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 32

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 33

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 34

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 35

Analysts often refer to the three ____'s when describing characteristics of Big Data.

A) C
B) G
C) D
D) V

Question 36

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 37

What is the process of presenting data graphically as charts, maps, or other pictorial formats in order to understand the resulting information easily?

A) data visualization
B) data integrity
C) data velocity
D) data relationships

Question 38

A table that has rows and columns is what type of table?

A) three-dimensional
B) primary
C) two-dimensional
D) object-oriented

Question 39

What type of database are organizations MOST LIKELY to use for payroll, accounts receivable, inventory, and invoicing?

A) distributed
B) multi-dimensional
C) relational
D) object-oriented

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

What is DBMS?

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

Question 42

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 43

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 store data in two dimensions.
D) All multidimensional databases have a dimension of time.

Question 44

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 45

Which kind of database stores data in dimensions?

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

Question 46

What type of database exists in many separate locations throughout a network or the Internet?

A) object-oriented
B) data
C) relational
D) distributed

Question 47

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 48

Which of the following statements about data types is FALSE?

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 49

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 50

What does each byte in the ASCII coding scheme represent?

A) multiple characters
B) single character
C) multiple bits
D) single cluster

Question 51

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 52

Which of the following stores data in objects?

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

Question 53

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 54

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

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

Question 55

Most data items are stored in only one file, which greatly reduces _____.

A) duplicate redundancy
B) duplicate data
C) hypertext redundancy
D) data relationships

Question 56

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 57

Which of the following refers to the different formats to represent or store data for use by humans and computer applications?

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

Question 58

Who was the inventor of the relational database model?

A) E. L. Coff
B) E. G. Cott
C) E. F. Codd
D) E. L. Codd

Question 59

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

A) They store data in tables.
B) They store relationships.
C) They use two-dimensional tables.
D) They store data in objects.

Question 60

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 61

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 62

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 63

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 64

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 65

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

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

Question 66

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 67

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

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

Question 68

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 69

Which of the following does NOT improve with the database approach?

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

Question 70

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 71

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 72

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 73

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

What is a feature that has a graphical user interface to assist users with retrieving data?

A) QBE
B) DBE
C) SQL
D) NoSQL

Question 75

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 76

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 77

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 78

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 79

What is another term for data dictionary?

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

Question 80

What does the S in SQL stand for?

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