Deck 12: Information Systems

Question 1

Which of the following represents the type of analysis that spreadsheets are particularly good at performing?

A) What-if
B) Range
C) Formula
D) Cell
E) Circular reference

Answer 1

A

Question 2

Which of the following is used to specify a set of adjacent elements in a spreadsheet?

A) What-if
B) Range
C) Formula
D) Cell
E) Circular reference

Answer 2

B

Question 3

Which of the following database elements is composed of a set of related data items, such as a person's name, address, and ID number?

A) Record
B) Key
C) Field
D) Query
E) Table

Answer 3

A

Question 4

Which of the following uniquely identifies a particular record within a database table?

A) SQL
B) Key
C) Field
D) Query
E) Schema

Question 5

Each cell of a spreadsheet is referenced by a 6-digit index number.

Question 6

The engine of a database management system (DBMS) consists of the software that allows the user to access and modify the database contents.

Question 7

A schema describes the relationships among the cells of a spreadsheet.

Question 8

A(n) _______________ helps the user organize and analyze data.

Question 9

A(n) _______________ application allows the user to organize and analyze data using a grid of cells.

Question 10

Multiple cells in a spreadsheet can be identified by specifying a(n) _______________.

Question 11

A(n) _______________ is the software within a database management system that allows the user to interact with the database.

Question 12

A single value in a database record is called a(n) _______________.

Question 13

_______________ is the process of buying and selling products and services using the World Wide Web.

Question 14

A(n) _______________ reference in a spreadsheet cannot be resolved because the result of one formula is based on another, and vice versa.

Question 15

A(n) _______________ statement is used to retrieve specific information from a database.

Question 16

What is a spreadsheet application?

Question 17

What is a cardinality constraint in an ER diagram?

Question 18

Which of the following designates a single location in a spreadsheet?

A) What-if
B) Range
C) Formula
D) Cell
E) Circular reference

Question 19

Which of the following represents an invalid reference to a cell in a spreadsheet?

A) G14..H27
B) J24
C) A3..A7
D) =J24/J23
E) 15B

Question 20

Which of the following represents a single piece of information in a database, such as a person's last name?

A) Record
B) Key
C) Field
D) Query
E) Table

Question 21

Which of the following provides the logical view of the data in a database?

A) SQL
B) Key
C) Field
D) Query
E) Schema

Question 22

Which of the following is a popular technique for designing relational databases?

A) Entity-relationship modeling
B) What-if analysis
C) Querying
D) Grid layout
E) Spreadsheet visualization

Question 23

All of the following were important aspects contributing to the success of e-commerce, except:

A) the development of electronic payment systems such as PayPal, which eased the process of online purchases.
B) the development of secure protocols and other technological enhancements that permitted the secure transfer of electronic funds and enhanced e-commerce security.
C) electronic shopping carts that allowed users to maintain a running collection of items and purchase those items in a single transaction.
D) facilities that permit a user to search for and compare items in various ways.
E) traditional "bricks and mortar" businesses declining to develop a competitive online presence.

Question 24

A spreadsheet cell can contain a data value or a formula.

Question 25

A spreadsheet cell can contain data, but not a formula.

Question 26

Spreadsheets are particularly helpful when performing what-if analysis.

Question 27

A spreadsheet is organized into a grid of labeled tables.

Question 28

Sequal, an early database language, was developed by IBM.

Question 29

The relational database model organizes data and relationships into tables.

Question 30

In a relational database, a table can represent a collection of relationships among objects.

Question 31

E-commerce provides the consumer with several advantages over in-store shopping.

Question 32

Which of the following is used to perform a calculation in a spreadsheet?

A) What-if
B) Range
C) Formula
D) Cell
E) Circular reference

Question 33

Which of the following describes a spreadsheet calculation that cannot be resolved?

A) What-if
B) Range
C) Formula
D) Cell
E) Circular reference

Question 34

Which of the following is composed of a related set of database records?

A) SQL
B) Key
C) Field
D) Query
E) Table

Question 35

Which of the following is a common database language?

A) SQL
B) Key
C) Field
D) Query
E) Schema

Question 36

Which of the following represents a single cell in a spreadsheet?

A) G14..H27
B) J24
C) A3..A7
D) =J24/J23
E) 15B

Question 37

Which of the following represents a single-column range in a spreadsheet?

A) G14..H27
B) J24
C) A3..A7
D) =J24/J23
E) 15B

Question 38

A spreadsheet cell can contain numeric or text data.

Question 39

Circular references should be avoided in spreadsheets.

Question 40

A query is an error that occurs when an inappropriate request is made to a database management system.

Question 41

SQLs insert, update, and delete statements allow the data in a table to changed.

Question 42

An Entity-Relationship (ER) diagram is used to compose and execute queries in a database management system.

Question 43

A(n) _______________ is a request for information submitted to a database management system.

Question 44

_______________ is a comprehensive database language for managing relational databases.

Question 45

List the three general cardinality relationships that are possible.