LSU ISDS 3003 FINAL QUESTIONS & ANSWERS
A relational database is ________.
Select one:
A.a collection of forms and reports that support a given purpose
B.a self-describing collection of related tables
C.a set of metadata
D.a set of applications and the data sets for those applications
E.a library of queries and data files for querying - Answer -B
Data mining applications are used to accomplish all of the following tasks except
________.
Select one:
A.incorporate results into some other report/system
B.classify entities
C.perform what-if analysis
D.facilitate decision making
E.make predictions - Answer -B
Business Intelligence (BI) reporting systems can do which of the following operations?
Select one:
A.Filter data
B.Group data
C.Modify data
D.Both Filter data and Group data
E.Secure data - Answer -D
SQL stands for ________.
Select one:
A.Structured Query Language
B.Structured Question Language
C.Standard Question Language
D.Structural Question Language
E.Standard Query Language - Answer -A
Which of the following is not true about null values?
Select one:
A.A null value can mean that no value for the field is appropriate.
B.Null values cannot be avoided.
C.A null value can mean that the value is known to be blank.
, D.A null value can mean that the value is unknown.
E.A null value is ambiguous. - Answer -B
Which of the following terms is synonymous with "relation"?
Select one:
A.Record
B.Table
C.Tuple
D.Attribute
E.Row - Answer -B
A relational database stores data in the form of ________.
Select one:
A.columns
B.spreadsheets
C.tables
D.forms
E.lists - Answer -C
The first step of the normalization process is to ________.
Select one:
A.identify all the foreign keys of a relation
B.split the relation into two or more new relations
C.identify all the determinants of a relation
D.identify all the functional dependencies of a relation
E.identify all the candidate keys of a relation - Answer -E
When the primary key of one relation is placed into a second relation, it is called a
________.
Select one:
A.relocated key
B.referential integrity
C.candidate key
D.field key
E.foreign key - Answer -E
Which symbol is used in standard SQL as a wildcard to represent a series of one or
more unspecified characters?
Select one:
A.? (question mark)
B.; (semi-colon)
A relational database is ________.
Select one:
A.a collection of forms and reports that support a given purpose
B.a self-describing collection of related tables
C.a set of metadata
D.a set of applications and the data sets for those applications
E.a library of queries and data files for querying - Answer -B
Data mining applications are used to accomplish all of the following tasks except
________.
Select one:
A.incorporate results into some other report/system
B.classify entities
C.perform what-if analysis
D.facilitate decision making
E.make predictions - Answer -B
Business Intelligence (BI) reporting systems can do which of the following operations?
Select one:
A.Filter data
B.Group data
C.Modify data
D.Both Filter data and Group data
E.Secure data - Answer -D
SQL stands for ________.
Select one:
A.Structured Query Language
B.Structured Question Language
C.Standard Question Language
D.Structural Question Language
E.Standard Query Language - Answer -A
Which of the following is not true about null values?
Select one:
A.A null value can mean that no value for the field is appropriate.
B.Null values cannot be avoided.
C.A null value can mean that the value is known to be blank.
, D.A null value can mean that the value is unknown.
E.A null value is ambiguous. - Answer -B
Which of the following terms is synonymous with "relation"?
Select one:
A.Record
B.Table
C.Tuple
D.Attribute
E.Row - Answer -B
A relational database stores data in the form of ________.
Select one:
A.columns
B.spreadsheets
C.tables
D.forms
E.lists - Answer -C
The first step of the normalization process is to ________.
Select one:
A.identify all the foreign keys of a relation
B.split the relation into two or more new relations
C.identify all the determinants of a relation
D.identify all the functional dependencies of a relation
E.identify all the candidate keys of a relation - Answer -E
When the primary key of one relation is placed into a second relation, it is called a
________.
Select one:
A.relocated key
B.referential integrity
C.candidate key
D.field key
E.foreign key - Answer -E
Which symbol is used in standard SQL as a wildcard to represent a series of one or
more unspecified characters?
Select one:
A.? (question mark)
B.; (semi-colon)
