ISDS 3003 FINAL QUESTIONS & ANSWERS
A relational database is _____
a. a set of applications and the data sets for those applications
b. a library of queries and data files for querying
c. a set of metadata
d. a collection of forms and reports that support a given purpose
e. a self-describing collection of related tables - Answer -e. a self-describing collection
of related tables
Data mining applications are used to accomplish all of the following tasks except____
a. make predictions
b. perform what-if analysis
c. incorporate results into some other report/system
d. classify entities
e. facilitate decision making - Answer -d. classify entities
Business Intelligence (BI) reporting systems can do which of the following operations?
a. Filter data
b. Group data
c. Modify data
d. Both Filter data and Group data
e. Secure data - Answer -d. Both Filter data and Group data
A relational database stores data in the form of _____
a. Tables
b. Spreadsheet
c. Lists
d. Columns
e. Forms - Answer -a. Tables
Which of the following is not true about null values?
a. A null value can mean that the value is known to be blank.
b. A null value is ambiguous.
c. Null values cannot be avoided.
d. A null value can mean that no value for the field is appropriate.
e. A null value can mean that the value is unknown. - Answer -c. Null values cannot be
avoided.
1. Which of the following terms is synonymous with "relation"
a. Record
b. Table
c. Row
d. Attribute
e. Tuple - Answer -b. Table
, The first step of the normalization process is to ____
a. identify all the candidate keys of a relation
b. identify all the functional dependencies of a relation
c. identify all the foreign keys of a relation
d. identify all the determinants of a relation
e. split the relation into two or more new relations - Answer -a. identify all the candidate
keys of a relation
when the primary key of one relation is placed into a second relation it is called a ____
a. referential integrity
b. relocated key
c. candidate key
d. field key
e. foreign key - Answer -e. foreign key
which symbol is used in standard SQL as a wildcard to represent a series of one or
more unspecified characters?
a. ! (exclamation mark)
b. ? (question mark)
c. ; (semi-colon)
d. _ (underscore)
e. % (percent sign) - Answer -e. % (percent sign)
Which of the following is not one of the five SQL built in functions?
a. SUM
b. MODE
c. MAX
d. COUNT
e. AVG - Answer -b. MODE
Given the table
CUSTOMER(CustID, Name, PhoneNum, AcctBalance)
what is the standard SQL query phrase to retrieve the Name and Phone Number of
customers?
A. SELECT (CUSTOMER-Name AND CUSTOMER-PhoneNum)
B. SELECT *
C. SELECT IN (Name, PhoneNum)
D. SELECT Name, PhoneNum
E. SELECT CUSTOMER-Name AND CUSTOMER-PhoneNum - Answer -D. SELECT
Name, PhoneNum
Given the table
CUSTOMER(CustID, Name, PhoneNum, AcctBalance)
what is the standard SQL query phrase to retrieve data for customers with an account
balance greater than 50?
A relational database is _____
a. a set of applications and the data sets for those applications
b. a library of queries and data files for querying
c. a set of metadata
d. a collection of forms and reports that support a given purpose
e. a self-describing collection of related tables - Answer -e. a self-describing collection
of related tables
Data mining applications are used to accomplish all of the following tasks except____
a. make predictions
b. perform what-if analysis
c. incorporate results into some other report/system
d. classify entities
e. facilitate decision making - Answer -d. classify entities
Business Intelligence (BI) reporting systems can do which of the following operations?
a. Filter data
b. Group data
c. Modify data
d. Both Filter data and Group data
e. Secure data - Answer -d. Both Filter data and Group data
A relational database stores data in the form of _____
a. Tables
b. Spreadsheet
c. Lists
d. Columns
e. Forms - Answer -a. Tables
Which of the following is not true about null values?
a. A null value can mean that the value is known to be blank.
b. A null value is ambiguous.
c. Null values cannot be avoided.
d. A null value can mean that no value for the field is appropriate.
e. A null value can mean that the value is unknown. - Answer -c. Null values cannot be
avoided.
1. Which of the following terms is synonymous with "relation"
a. Record
b. Table
c. Row
d. Attribute
e. Tuple - Answer -b. Table
, The first step of the normalization process is to ____
a. identify all the candidate keys of a relation
b. identify all the functional dependencies of a relation
c. identify all the foreign keys of a relation
d. identify all the determinants of a relation
e. split the relation into two or more new relations - Answer -a. identify all the candidate
keys of a relation
when the primary key of one relation is placed into a second relation it is called a ____
a. referential integrity
b. relocated key
c. candidate key
d. field key
e. foreign key - Answer -e. foreign key
which symbol is used in standard SQL as a wildcard to represent a series of one or
more unspecified characters?
a. ! (exclamation mark)
b. ? (question mark)
c. ; (semi-colon)
d. _ (underscore)
e. % (percent sign) - Answer -e. % (percent sign)
Which of the following is not one of the five SQL built in functions?
a. SUM
b. MODE
c. MAX
d. COUNT
e. AVG - Answer -b. MODE
Given the table
CUSTOMER(CustID, Name, PhoneNum, AcctBalance)
what is the standard SQL query phrase to retrieve the Name and Phone Number of
customers?
A. SELECT (CUSTOMER-Name AND CUSTOMER-PhoneNum)
B. SELECT *
C. SELECT IN (Name, PhoneNum)
D. SELECT Name, PhoneNum
E. SELECT CUSTOMER-Name AND CUSTOMER-PhoneNum - Answer -D. SELECT
Name, PhoneNum
Given the table
CUSTOMER(CustID, Name, PhoneNum, AcctBalance)
what is the standard SQL query phrase to retrieve data for customers with an account
balance greater than 50?
