CSIS 110 Chap 12, final exam cis1000
Question and answers rated A+
True or False? Whenever possible, a constant value should be used in a
spreadsheet instead of a formula. - correct answer False
True or False? A relational database table is composed of records and each
record is a collection of related fields. - correct answer True
True or False? An Entity-Relationship (ER) diagram is used to design
relational databases. - correct answer True
True or False? An Entity-Relationship (ER) diagram is used to compose and
execute queries in a database management system. - correct answer False
All of the following were important aspects contributing to the success of e-
commerce EXCEPT: - correct answer traditional "bricks and mortar"
businesses declining to develop a competitive online presence
True or False? The key of a database table is composed of one or more fields
of a database record that uniquely identifies it among all other records in the
table. - correct answer True
Which of the following is a common database language? - correct answer
SQL
True or False? A query is a request to retrieve data from a database. - correct
answer True
, True or False? The SQL select statement is used to retrieve particular data
from the database. - correct answer True
True or False? The key of a database table can be composed of more than
one field. - correct answer True
Which of the following is used to retrieve data from a database? - correct
answer query
Which of the following represents the type of analysis that spreadsheets are
particularly good at performing? - correct answer What-if
True or False? The Structured Query Language (SQL) is a language for
managing relational databases. - correct answer True
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? - correct answer
Record
Which of the following describes a spreadsheet calculation that cannot be
resolved? - correct answer circular reference
True or False? A relational database table is composed of schema and
queries - correct answer False
Which of the following is used to perform a calculation in a spreadsheet? -
correct answer Formula
Which of the following is used to specify a set of adjacent elements in a
spreadsheet? - correct answer Range
Question and answers rated A+
True or False? Whenever possible, a constant value should be used in a
spreadsheet instead of a formula. - correct answer False
True or False? A relational database table is composed of records and each
record is a collection of related fields. - correct answer True
True or False? An Entity-Relationship (ER) diagram is used to design
relational databases. - correct answer True
True or False? An Entity-Relationship (ER) diagram is used to compose and
execute queries in a database management system. - correct answer False
All of the following were important aspects contributing to the success of e-
commerce EXCEPT: - correct answer traditional "bricks and mortar"
businesses declining to develop a competitive online presence
True or False? The key of a database table is composed of one or more fields
of a database record that uniquely identifies it among all other records in the
table. - correct answer True
Which of the following is a common database language? - correct answer
SQL
True or False? A query is a request to retrieve data from a database. - correct
answer True
, True or False? The SQL select statement is used to retrieve particular data
from the database. - correct answer True
True or False? The key of a database table can be composed of more than
one field. - correct answer True
Which of the following is used to retrieve data from a database? - correct
answer query
Which of the following represents the type of analysis that spreadsheets are
particularly good at performing? - correct answer What-if
True or False? The Structured Query Language (SQL) is a language for
managing relational databases. - correct answer True
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? - correct answer
Record
Which of the following describes a spreadsheet calculation that cannot be
resolved? - correct answer circular reference
True or False? A relational database table is composed of schema and
queries - correct answer False
Which of the following is used to perform a calculation in a spreadsheet? -
correct answer Formula
Which of the following is used to specify a set of adjacent elements in a
spreadsheet? - correct answer Range
