ISDS 3003 Final Exam Review questions with 100%
complete solution
A |relational |database |is
A. a |self-describing |collection |of |related |tables
B. a |library |of |queries |and |data |files |for |querying
C. a |set |of |applications |and |the |data |sets |for |those |applications
D. a |set |of |metadata
E. a |collection |of |forms |and |reports |that |support |a |given |purpose |- |a |self-describing
|collection |of |related |tables
Data |mining |applications |are |used |to |accomplish |all |of |the |following |tasks |except
A. incorporate |results |into |some |other |report/system
B. facilitate |decision |making
C. classify |entities
D. make |predictions
E. perform |what-if |analysis |- |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 |- |Both |Filter |data |and |Group |data
A |relational |database |stores |data |in |the |form |of
A. forms
B. tables
C. lists
D. columns
E. spreadsheets |- |tables
SQL |stands |for
A. Standard |Question |Language
B. Structural |Question |Language
C. Structured |Query |Language
D. Structured |Question |Language
E. Standard |Query |Language |- |Structured |Query |Language
Which |of |the |following |is |not |true |about |null |values?
, A. A |null |value |can |mean |that |no |value |for |the |field |is |appropriate.
B. A |null |value |is |ambiguous.
C. A |null |value |can |mean |that |the |value |is |unknown.
D. Null |values |cannot |be |avoided.
E. A |null |value |can |mean |that |the |value |is |known |to |be |blank |- |Null |values |cannot |be
|avoided
Which |of |the |following |terms |is |synonymous |with |"relation"?
A. Row
B. Record
C. Table
D. Tuple
E. Attribute |- |Table
The |first |step |of |the |normalization |process |is |to
A. identify |all |the |determinants |of |a |relation
B. split |the |relation |into |two |or |more |new |relations
C. identify |all |the |functional |dependencies |of |a |relation
D. identify |all |the |foreign |keys |of |a |relation
E. identify |all |the |candidate |keys |of |a |relation |- |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. field |key
B. foreign |key
C. referential |integrity
D. candidate |key
E. relocated |key |- |Foreign |key
Which |symbol |is |used |in |standard |SQL |as |a |wildcard |to |represent |a |series |of |one |or |more
|unspecified |characters?
% |(percent |sign)
B. ; |(semi-colon)
C. ! |(exclamation |mark)
D. _ |(underscore)
E. ? |(question |mark) |- |% |(percent |sign)
Which |of |the |following |is |not |one |of |the |five |SQL |built-in |functions?
A. AVG
B. SUM
complete solution
A |relational |database |is
A. a |self-describing |collection |of |related |tables
B. a |library |of |queries |and |data |files |for |querying
C. a |set |of |applications |and |the |data |sets |for |those |applications
D. a |set |of |metadata
E. a |collection |of |forms |and |reports |that |support |a |given |purpose |- |a |self-describing
|collection |of |related |tables
Data |mining |applications |are |used |to |accomplish |all |of |the |following |tasks |except
A. incorporate |results |into |some |other |report/system
B. facilitate |decision |making
C. classify |entities
D. make |predictions
E. perform |what-if |analysis |- |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 |- |Both |Filter |data |and |Group |data
A |relational |database |stores |data |in |the |form |of
A. forms
B. tables
C. lists
D. columns
E. spreadsheets |- |tables
SQL |stands |for
A. Standard |Question |Language
B. Structural |Question |Language
C. Structured |Query |Language
D. Structured |Question |Language
E. Standard |Query |Language |- |Structured |Query |Language
Which |of |the |following |is |not |true |about |null |values?
, A. A |null |value |can |mean |that |no |value |for |the |field |is |appropriate.
B. A |null |value |is |ambiguous.
C. A |null |value |can |mean |that |the |value |is |unknown.
D. Null |values |cannot |be |avoided.
E. A |null |value |can |mean |that |the |value |is |known |to |be |blank |- |Null |values |cannot |be
|avoided
Which |of |the |following |terms |is |synonymous |with |"relation"?
A. Row
B. Record
C. Table
D. Tuple
E. Attribute |- |Table
The |first |step |of |the |normalization |process |is |to
A. identify |all |the |determinants |of |a |relation
B. split |the |relation |into |two |or |more |new |relations
C. identify |all |the |functional |dependencies |of |a |relation
D. identify |all |the |foreign |keys |of |a |relation
E. identify |all |the |candidate |keys |of |a |relation |- |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. field |key
B. foreign |key
C. referential |integrity
D. candidate |key
E. relocated |key |- |Foreign |key
Which |symbol |is |used |in |standard |SQL |as |a |wildcard |to |represent |a |series |of |one |or |more
|unspecified |characters?
% |(percent |sign)
B. ; |(semi-colon)
C. ! |(exclamation |mark)
D. _ |(underscore)
E. ? |(question |mark) |- |% |(percent |sign)
Which |of |the |following |is |not |one |of |the |five |SQL |built-in |functions?
A. AVG
B. SUM
