CIS 360 EXAM 1 FINAL PREP QUESTIONS WITH VERIFIED ANSWERS

CIS 360 EXAM 1 FINAL PREP QUESTIONS WITH
VERIFIED ANSWERS


A candidate key is one of a group of keys that may serve as the primary key in a
relation. - Answers - True

A combination key is a group of attributes that uniquely identifies a row. - Answers -
False

The SQL keyword WHERE is used to specify the table(s) that contain(s) the data to be
retrieved. - Answers - False

In an SQL query, which SQL keyword is used to state the condition that specifies which
rows are to be selected? - Answers - WHERE

A database extracted from the operational database for BI purposes typically ____. -
Answers - contains just part of the operational database

Like a spreadsheet, a database table has rows and columns. - Answers - True

A determinant of a functional dependency may or may not be unique in a relation. -
Answers - True

SQL is a _____. - Answers - data sublanguage

The WHERE clause contains the condition that specifies which rows are to be selected.
- Answers - True

The purpose of a database is to help people keep track of things. - Answers - True

Enterprise Resource Planning (ERP) is an example of a data mining application -
Answers - False

To remove duplicate rows from the result of a query, specify the DISTINCT keyword. -
Answers - True

When making an SQL query, we are using SQL as a(n)_____. - Answers - DML

The columns to be obtained by an SQL command are listed after the FROM keyword. -
Answers - False

A relation is in second normal form (2NF) if and only if it is in 1NF and _____. - Answers
- all non-key attributes are determined by the entire primary key