ISDS 3003 FINAL- BORNE QUESTIONS & ANSWERS
A relational database is ________.
A. a self-describing collection of related tables
B. a set of applications and the data sets for those applications
C. a library of queries and data files for querying
D. a collection of forms and reports that support a given purpose
E. a set of metadata
A.
a self-describing collection of related tables
Data mining applications are used to accomplish all of the following tasks except
________.
A. facilitate decision making
B. classify entities
C. incorporate results into some other report/system
D. perform what-if analysis
E. make predictions
B.
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
D.
Both Filter data and Group data
Which of the following terms is synonymous with "relation"?
Select one:
A. Tuple
B. Table
C. Record
D. Row
E. Attribute
B.
,Table
The first step of the normalization process is to ________.
Select one:
A. identify all the determinants of a relation
B. identify all the foreign keys of a relation
C. identify all the functional dependencies of a relation
D. split the relation into two or more new relations
E. identify all the candidate keys of a relation
E.
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
________.
Select one:
A. candidate key
B. relocated key
C. referential integrity
D. foreign key
E. field key
D.
foreign key
Which symbol is used in standard SQL as a wildcard to represent a series of one or
more unspecified characters?
Select one:
A. ! (exclamation mark)
B. % (percent sign)
C. ? (question mark)
D. _ (underscore)
E. ; (semi-colon)
B.
% (percent sign)
Which of the following is not one of the five SQL built-in functions?
Select one:
A. MODE
B. COUNT
C. AVG
D. MAX
E. SUM
A. 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 Name, PhoneNum
B. SELECT CUSTOMER-Name AND CUSTOMER-PhoneNum
C. SELECT (Name, PhoneNum)
D. SELECT *
E. SELECT (CUSTOMER-Name AND CUSTOMER-PhoneNum)
A.
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. HAVING AcctBalance > 50
B. WHERE CUSTOMER-AcctBalance > 50
C. WHERE (AcctBalance > 50)
D. WHERE (CUSTOMER-AcctBalance > 50)
E. WHERE AcctBalance > 50
Clear my choice
WHERE AcctBalance > 50
A relational database stores data in the form of ________.
A. lists
B. spreadsheets
C. forms
D. tables
E. columns
D.
tables
SQL stands for ________.
, A. Structured Query Language
B. Structured Question Language
C. Standard Question Language
D. Structural Question Language
E. Standard Query Language
Clear my choice
A.
Structured Query Language
Which of the following is not true about null values?
A. A null value is ambiguous.
B. Null values cannot be avoided.
C. A null value can mean that no value for the field is appropriate.
D. A null value can mean that the value is unknown.
E. A null value can mean that the value is known to be blank.
Clear my choice
B.
Null values cannot be avoided.
Which of the following is not a basic element of the E-R Model?
Select one:
A. Relationships
B. Cardinalities
C. Use cases
D. Entities
E. Identifiers
C.
Use cases
In crow's foot style E-R diagrams, a circle across the relationship line near an entity
indicates ________.
Select one:
A. a minimum cardinality of mandatory
B. a minimum cardinality of optional
C. a maximum cardinality of one
D. a maximum cardinality of many
E. Both a minimum cardinality of optional and a maximum cardinality of one
B.
a minimum cardinality of optional
A relational database is ________.
A. a self-describing collection of related tables
B. a set of applications and the data sets for those applications
C. a library of queries and data files for querying
D. a collection of forms and reports that support a given purpose
E. a set of metadata
A.
a self-describing collection of related tables
Data mining applications are used to accomplish all of the following tasks except
________.
A. facilitate decision making
B. classify entities
C. incorporate results into some other report/system
D. perform what-if analysis
E. make predictions
B.
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
D.
Both Filter data and Group data
Which of the following terms is synonymous with "relation"?
Select one:
A. Tuple
B. Table
C. Record
D. Row
E. Attribute
B.
,Table
The first step of the normalization process is to ________.
Select one:
A. identify all the determinants of a relation
B. identify all the foreign keys of a relation
C. identify all the functional dependencies of a relation
D. split the relation into two or more new relations
E. identify all the candidate keys of a relation
E.
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
________.
Select one:
A. candidate key
B. relocated key
C. referential integrity
D. foreign key
E. field key
D.
foreign key
Which symbol is used in standard SQL as a wildcard to represent a series of one or
more unspecified characters?
Select one:
A. ! (exclamation mark)
B. % (percent sign)
C. ? (question mark)
D. _ (underscore)
E. ; (semi-colon)
B.
% (percent sign)
Which of the following is not one of the five SQL built-in functions?
Select one:
A. MODE
B. COUNT
C. AVG
D. MAX
E. SUM
A. 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 Name, PhoneNum
B. SELECT CUSTOMER-Name AND CUSTOMER-PhoneNum
C. SELECT (Name, PhoneNum)
D. SELECT *
E. SELECT (CUSTOMER-Name AND CUSTOMER-PhoneNum)
A.
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. HAVING AcctBalance > 50
B. WHERE CUSTOMER-AcctBalance > 50
C. WHERE (AcctBalance > 50)
D. WHERE (CUSTOMER-AcctBalance > 50)
E. WHERE AcctBalance > 50
Clear my choice
WHERE AcctBalance > 50
A relational database stores data in the form of ________.
A. lists
B. spreadsheets
C. forms
D. tables
E. columns
D.
tables
SQL stands for ________.
, A. Structured Query Language
B. Structured Question Language
C. Standard Question Language
D. Structural Question Language
E. Standard Query Language
Clear my choice
A.
Structured Query Language
Which of the following is not true about null values?
A. A null value is ambiguous.
B. Null values cannot be avoided.
C. A null value can mean that no value for the field is appropriate.
D. A null value can mean that the value is unknown.
E. A null value can mean that the value is known to be blank.
Clear my choice
B.
Null values cannot be avoided.
Which of the following is not a basic element of the E-R Model?
Select one:
A. Relationships
B. Cardinalities
C. Use cases
D. Entities
E. Identifiers
C.
Use cases
In crow's foot style E-R diagrams, a circle across the relationship line near an entity
indicates ________.
Select one:
A. a minimum cardinality of mandatory
B. a minimum cardinality of optional
C. a maximum cardinality of one
D. a maximum cardinality of many
E. Both a minimum cardinality of optional and a maximum cardinality of one
B.
a minimum cardinality of optional
