CSIS 110 Chap 12
Which of the following represents an invalid reference to a cell in a spreadsheet?
15B
Which of the following designates a single location in a spreadsheet?
Cell
Which of the following is used to specify a set of adjacent elements in a spreadsheet?
Range
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?
Record
Which of the following is a common database language?
SQL
Which of the following provides the logical view of the data in a database?
Schema
Which of the following is composed of a related set of database records?
Table
True or False? A query is a request to retrieve data from a database.
True
True or False? A relational database table is composed of records and each record is a collection of related fields.
True
True or False? A schema provides the logical view of the data in the database
True
True or False? An Entity-Relationship (ER) diagram is used to design relational databases.
True
True or False? In a relational database, a table can represent a collection of relationships among objects.
True
True or False? In a relational database, data and the relationships among them are organized into tables.
True
True or False? Project is an SQL operation to produce a subset of the columns in a table.
True
True or False? SQL's insert, update, and delete statements allow the data in a table to changed
True
True or False? Select is an SQL operation to identify records in a table.
True
True or False? Spreadsheet formulas can make use of basic arithmetic operations as well as spreadsheet functions that are built into the software
True
True or False? The SQL select statement is used to retrieve particular data from the database.
True
True or False? The Structured Query Language (SQL) is a language for managing relational databases.
True
True or False? The engine of a database management system (DBMS) consists of the software that allows the user to access and modify the database contents.
True
True or False? The key of a database table can be composed of more than one field.
True
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.
True
True or False? Using an asterisk (*) in an SQL select statement will return all attributes from the selected records.
True
Which of the following represents the type of analysis that spreadsheets are particularly good at performing?
What-if
Which of the following describes a spreadsheet calculation that cannot be resolved?
circular reference
Which of the following is used to retrieve data from a database?
query
All of the following were important aspects contributing to the success of e-commerce EXCEPT:
traditional "bricks and mortar" businesses declining to develop a competitive online presence
Which of the following uniquely identifies a particular record within a database table?
Key
True or False? A database key is a unique numeric value used to grant users access a particular database.
False
True or False? A query is an error that occurs when an inappropriate request is made to a database management system.
False
True or False? A relational database table is composed of schema and queries
False
True or False? A schema describes the relationships among the cells of a spreadsheet
False
True or False? An Entity-Relationship (ER) diagram is used to compose and execute queries in a database management system.
False
True or False? Cartesian product is an SQL operation to identify records in a table.
False
True or False? SQL is case sensitive.
False
True or False? Whenever possible, a constant value should be used in a spreadsheet instead of a formula.
False
Which of the following represents a single piece of information in a database, such as a person's last name?
Field
Which of the following is used to perform a calculation in a spreadsheet?
Formula
Which of the following represents a multi-column range in a spreadsheet?
G14..H27
