question

Which of the following is a reason for creating a list instead of creating a database? 1) to organize data for simple tasks 2) to prevent data inconsistency 3) to prevent data redundancy 4) to make it easier to share data in a central location

answer

1) to organize data for simple tasks

question

If a business keeps two lists, one for employee payroll and one for employee benefit information, both containing name and address information, this is an example of data ________. 1) integrity 2) redundancy 3) completeness 4) normalization

answer

2) redundancy

question

Data ________ means that the data contained in a database is accurate and reliable. 1) efficiency 2) integrity 3) redundancy 4) consistency

answer

2) integrity

question

________ helps to ensure data integrity by maintaining information in only one place. 1) Data flexibility 2) Data redundancy 3) Data mapping 4) Data centralization

answer

4) Data centralization

question

Which of the following is NOT a typical disadvantage associated with databases? 1) Databases can be expensive to set up. 2) Databases are usually more complex to administer. 3) Databases are more complex to construct. 4) Database information cannot be changed once it is entered.

answer

4) Database information cannot be changed once it is entered.

question

An individual trained in the design and building of databases is called a database ________. 1) master 2) technician 3) administrator 4) analyst

answer

3) administrator

question

In a database, a ________ is synonymous with a category of information. 1) field 2) record 3) row 4) table

answer

1) field

question

Which of the following is NOT a database component? 1) field 2) list 3) record 4) table

answer

2) list

question

Which of the following is NOT a common data type in a database? 1) hyperlink 2) memo 3) object 4) figure

answer

4) figure

question

In a database, ________ fields store numbers used to perform calculations. 1) date 2) numeric 3) computational 4) alphanumeric

answer

2) numeric

question

In a database, a video clip would be stored in a(n) ________ field. 1) text 2) object 3) memo 4) hyperlink

answer

2) object

question

To store a Web address, use a(n) ________ field in a database. 1) hyperlink 2) object 3) address 4) memo

answer

1) hyperlink

question

________ defines the maximum number of characters or numbers that a particular field can hold. 1) Type size 2) Max size 3) Field size 4) Text size

answer

3) Field size

question

In a database, a record is a: 1) group of related fields. 2) category of information. 3) cluster of adjacent cells. 4) collection of tables.

answer

1) group of related fields

question

Which of the following is NOT a likely primary key? 1) driver's license number 2) street address 3) student ID number 4) Social Security number

answer

2) street address

question

A unique field is called a primary key or a ________ field. 1) key 2) data 3) validation 4) referential

answer

1) key

question

________ databases have the largest market share among the primary types of electronic databases. 1) Relational 2) Flat-file 3) Multidimensional 4) Object-oriented

answer

1) Relational

question

Which of the following is NOT a type of electronic database? 1) object-oriented 2) flat-file 3) multidimensional 4) relational

answer

2) flat-file

question

In a relational database, what is a relationship? 1) a table that contains related data 2) the primary key in the database 3) the links among databases 4) the array of tables in a database

answer

1) a table that contains related data

question

Nontraditional data such as audio clips, video clips, pictures, and very large documents are called ________ data. 1) enterprise 2) structured 3) unstructured 4) multidimensional

answer

3) unstructured

question

Unstructured data such as video clips and pictures are known as ________ because of the way they are encoded. 1) hyperlink fields 2) multidimensional data 3) binary large objects (BLOBs) 4) metadata

answer

3) binary large objects (BLOBs)

question

Which of the following statements about object-oriented databases is FALSE? 1) They are more complex than relational databases. 2) They use a query language to access and manage data. 3) They are good at handling unstructured data. 4) They store data in table format.

answer

4) They store data in table format.

question

Which type of database excels in the storage of structured, analytical data? 1) relational 2) hierarchical 3) multidimensional 4) object-oriented

answer

1) relational

question

Data in a multidimensional database is organized in a ________ format. 1) linear 2) table 3) cube 4) cellular

answer

3) cube

question

________ databases can easily be customized to provide information to a variety of users (based on their need) and can process data much faster than pure relational databases. 1) Hierarchical 2) Multidimensional 3) Object-oriented 4) Structured

answer

2) Multidimensional

question

What does the acronym DBMS stand for? 1) database modeling system 2) database management system 3) data building and modeling system 4) data browsing and management system

answer

2) database management system

question

Microsoft ________ is a database management system. 1) Visio 2) Publisher 3) Access 4) Project

answer

3) Access

question

Which of the following is NOT a standard DBMS operation? 1) sorting data 2) querying data 3) outputting data 4) graphing data

answer

4) graphing data

question

A data dictionary is also called a(n) ________. 1) information system 2) summary report 3) relation 4) database schema

answer

4) database schema

question

When creating a database with a DBMS, you must create a description of the data called the ________. 1) data type 2) data dictionary 3) data mine 4) data warehouse

answer

2) data dictionary

question

When a user sees a field in a database with a value prior to changing the value (if needed), the user sees a ________. 1) default value 2) relation 3) field type 4) numeric check

answer

1) default value

question

A ________ check allows you to set credits allowed for students during one quarter from 0 to 21. 1) completeness 2) range 3) consistency 4) numeric

answer

2) range

question

A ________ check determines if all required fields were entered with appropriate data. 1) completeness 2) range 3) consistency 4) numeric

answer

1) completeness

question

A ________ displays a subset of data from a table (or tables) based on the criteria specified. 1) database query 2) join query 3) select query 4) criteria query

answer

3) select query

question

SQL uses ________ to extract records from a database by using English-like expressions that have variables and operations. 1) Boolean algebra 2) relational algebra 3) primary keys 4) foreign keys

answer

2) relational algebra

question

When you want to extract data from two or more tables, you use a(n) ________ query. 1) select 2) join 3) relational 4) object

answer

2) join

question

In Access, the Simple Query Wizard uses ________ to create a query. 1) ICQ 2) OQL 3) SQL 4) DQL

answer

3) SQL

question

________ is reordering records in a database. 1) Filtering 2) Alphabetizing 3) Querying 4) Sorting

answer

4) Sorting

question

A database ________ instructs a database to search for particular pieces of data. 1) query 2) template 3) formula 4) function

answer

1) query

question

Data from a database that, in electronic form, is formatted for another application is known as ________. 1) exporting 2) importing 3) batch processing 4) data mining

answer

1) exporting

question

A ________ relationship indicates that for a record in one table, there can be many related records in another table. 1) many-to-one 2) one-to-many 3) one-to-one 4) single-to-many

answer

2) one-to-many

question

________ means that for each value in the foreign key of one table, there is a corresponding value in the primary key of another table. 1) Referential integrity 2) Normalization 3) Database consistency 4) Record integrity

answer

1) Referential integrity

question

________ is the process of reducing data redundancy by recording data only once. 1) Consistency checking 2) Validation 3) Normalization 4) Range checking

answer

3) Normalization

question

A data ________ is a large-scale electronic repository of data that contains and organizes all of an organization's data in one place. 1) mart 2) chain 3) warehouse 4) storehouse

answer

3) warehouse

question

Data staging consists of all of the following steps EXCEPT: 1) transformation of data. 2) mining of data. 3) storage of data in a warehouse. 4) extraction of data.

answer

2) mining of data.

question

A(n) ________ is designed to improve communications and assist employees in accomplishing their daily tasks. 1) office support system 2) transaction-processing system 3) management information system 4) decision support system

answer

1) office support system

question

In a transaction-processing system (TPS), if the TPS database is queried and updated while the transaction is taking place, this is called ________ processing. 1) direct 2) batch 3) real-time 4) immediate

answer

3) real-time

question

In a transaction-processing system, if transaction data is accumulated until a certain point and then many transactions are processed all at once, this is called ________ processing. 1) delayed 2) batch 3) real-time 4) group

answer

2) batch

question

Exception reports and summary reports are part of a(n) ________. 1) transaction-processing system 2) office support system 3) management information system 4) decision support system

answer

3) management information system

question

Management information systems provide reports called ________, that show conditions that are unusual or need attention from users of the system. 1) detail reports 2) summary reports 3) exception reports 4) expert reports

answer

3) exception reports

question

The speech-recognition feature of Microsoft Windows is an example of a ________. 1) natural language processing (NLP) system 2) decision support system (DSS) 3) management information system (MIS) 4) database management system (DBMS)

answer

1) natural language processing (NLP) system

question

An example of ________ would be customer demographic data purchased from third parties or statistics compiled by the federal government. 1) internal data 2) external data 3) imported data 4) metadata

answer

2) external data

question

In a data warehouse, data gathered from sales, billing, and inventory departments are examples of ________ sources. 1) internal data 2) external data 3) metadata 4) exported data

answer

1) internal data

question

The type of information system that uses model management systems is a(n) ________. 1) transaction-processing system 2) management information system 3) decision support system 4) office support system

answer

3) decision support system

question

An expert system and a natural language processing system are both ________. 1) transaction-processing systems 2) knowledge-based systems 3) office support systems 4) database management systems

answer

2) knowledge-based systems

question

Classification, affinity grouping, and estimation are ________ methods used by managers to make their data more meaningful. 1) modeling 2) staging 3) artificial intelligence 4) data mining

answer

4) data mining

question

________ is the branch of computer science that deals with the attempt to create computers that think like humans. 1) Natural language processing 2) Expert system 3) Artificial intelligence 4) Enterprise resource planning

answer

3) Artificial intelligence

question

If a numeric field has a size of 7, which is the highest number it can hold? 1) 7 2) 9999999 3) 7777777 4) 700,000

answer

2) 9999999

question

Oracle Database 11g is an example of which type of database? 1) primary database 2) multidimensional database 3) object-oriented database 4) flat-file database

answer

2) multidimensional database

question

Data redundancy results when duplicate information is entered into a database. 1) True 2) False

answer

1) True

question

A database is a collection of related data that can be easily stored, sorted, organized, and queried. 1) True 2) False

answer

1) True

question

A pressing problem of lists is the inability of the listed data to be easily shared. 1) True 2) False

answer

1) True

question

Data centralization is a common feature of databases. 1) True 2) False

answer

1) True

question

A common disadvantage of databases is that databases are often flexibly organized. 1) True 2) False

answer

2) False

question

A numeric data field type can hold a dollar sign ($). 1) True 2) False

answer

1) True

question

A group of related fields is known as a table. 1) True 2) False

answer

2) False

question

An employee's ID number, name, company position, address, city, state, and zip makes up a record. 1) True 2) False

answer

1) True

question

Primary key fields must contain a unique value for each record. 1) True 2) False

answer

1) True

question

Employees' last name would usually make an appropriate key field. 1) True 2) False

answer

2) False

question

Primary keys have to be numbers that are entered by the user. 1) True 2) False

answer

2) False

question

Relational databases store more types of data than object-oriented databases. 1) True 2) False

answer

2) False

question

An advantage of multidimensional databases is that they can easily be customized for a variety of users. 1) True 2) False

answer

1) True

question

Feature attributes describe the measure attribute of a multidimensional database in some meaningful way. 1) True 2) False

answer

1) True

question

A data dictionary defines the name, data type, and length of each field in the database. 1) True 2) False

answer

1) True

question

A first name field should have a default value. 1) True 2) False

answer

2) False

question

Most databases cannot import data from other software applications. 1) True 2) False

answer

2) False

question

Alphabetic as well as numeric data can be entered in an alphabetic field. 1) True 2) False

answer

2) False

question

Viewing records of a database can also be referred to as browsing. 1) True 2) False

answer

1) True

question

Only Microsoft Access and MySQL use Structured Query Language. 1) True 2) False

answer

2) False

question

A database query is a question that a user asks of a database. 1) True 2) False

answer

1) True

question

All current DBMSs contain a query language that the software uses to retrieve and display requested records. 1) True 2) False

answer

1) True

question

Database query output can be imported into Microsoft Word. 1) True 2) False

answer

1) True

question

In a many-to-many relationship, a single record in one table can have many corresponding records in a related table. 1) True 2) False

answer

2) False

question

In a relational database, when two tables have a common field, the link between the tables is known as a hyperlink. 1) True 2) False

answer

2) False

question

A foreign key in one table is the primary key of another table and is used to establish relationships with that other table. 1) True 2) False

answer

1) True

question

A record is a category of information in a database. 1) True 2) False

answer

2) False

question

Normalization reduces data redundancy by recording data only once. 1) True 2) False

answer

1) True

question

For a relationship to be established between two tables, fields with common data must be present. 1) True 2) False

answer

1) True

question

There does not necessarily have to be a common field between two tables to establish a relationship. 1) True 2) False

answer

2) False

question

Knowledge-based systems support the concept of normal logic. 1) True 2) False

answer

2) False

question

The text of the Gettysburg Address would be stored in a text field. 1) True 2) False

answer

2) False

question

Artificial intelligence (AI) is the branch of computer science that deals with the attempt to create computers that think like humans. 1) True 2) False

answer

1) True

question

Data integrity means that the data contained in the database is accurate and reliable. 1) True 2) False

answer

1) True

question

Normalization means that there are no data entry errors in a database. 1) True 2) False

answer

2) False

question

A data warehouse must include data that pertains only to one time period. 1) True 2) False

answer

2) False

question

A data warehouse can be populated with external sources such as suppliers and vendors. 1) True 2) False

answer

1) True

question

A transaction-processing system (TPS) keeps track of everyday business activities. 1) True 2) False

answer

1) True

question

Real-time processing means that transactions are accumulated and then a number of transactions are processed at once. 1) True 2) False

answer

2) False

question

In data mining, classification involves organizing data into similar subgroups of data. 1) True 2) False

answer

2) False

question

A summary report shows unusual conditions or conditions that need system users' attention. 1) True 2) False

answer

2) False

question

Data warehousing is the process by which great amounts of data are analyzed and investigated with the purpose of spotting significant patterns or trends. 1) True 2) False

answer

2) False

question

Data mining is the process by which great amounts of data are analyzed and examined. 1) True 2) False

answer

1) True

question

The information in a data mart spans an entire enterprise. 1) True 2) False

answer

2) False

CIS*1200 Chapter 11 (Final Exam Questions) – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards