Deck 11: Building Solutions

Question 1

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

Answer 1

B

Question 2

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 2

D

Question 3

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

Answer 3

C

Question 4

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 5

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 6

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 7

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 8

Which of the following does a back end interact with?

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

Question 9

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 10

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 11

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 12

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 13

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 14

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

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

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

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 18

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 19

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 20

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 21

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 22

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 23

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 24

What is another term used for data dictionary?

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

Question 25

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

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

Question 26

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 27

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 28

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

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

Question 29

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 30

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

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

Question 31

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 32

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 33

SQL stands for which of the following?

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

Question 34

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 35

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 36

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 37

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 38

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 39

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 40

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 41

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 42

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 43

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

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 46

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 47

COGNITIVE ASSESSMENT What does each byte in the ASCII coding scheme represent?

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

Question 48

COGNITIVE ASSESSMENT 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 49

Which kind of database stores data in dimensions?

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

Question 50

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 51

COGNITIVE ASSESSMENT 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 52

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 53

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 54

COGNITIVE ASSESSMENT What is DBMS?

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

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

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 57

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

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

Question 58

Which of the following stores data in objects?

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

Question 59

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 60

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 61

COGNITIVE ASSESSMENT 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 62

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 63

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 64

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 65

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 66

COGNITIVE ASSESSMENT What is another term for data dictionary?

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

Question 67

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 68

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 69

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 70

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 71

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 72

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 73

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 74

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 75

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 76

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

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 80

COGNITIVE ASSESSMENT What does the S in SQL stand for?

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