MIS 3353 Final Exam Review Questions
With Correct Answers
Enabling |different |data |points |to |relate |to |one |another... |- |CORRECT |ANSWER✔✔-Is |one |of |the
|core |functions |of |a |database.
A |company |includes |information |about |its |customers |in |a |database |table |called |Customer. |
Each |line |within |this |table |includes |a |customer's |name, |phone |number, |address, |and |date |of |
birth. |These |lines |are |called... |
` |- |CORRECT |ANSWER✔✔-Records
A |"primary |key" |is... |- |CORRECT |ANSWER✔✔-Required |for |each |record.
Databases... |(Select |all/any |that |apply.) |- |CORRECT |ANSWER✔✔-Rely |on |primary |and |foreign |
keys |to |relate |records |from |different |tables.
In |a |company's |database, |a |given |table... |- |CORRECT |ANSWER✔✔-Can |include |millions |of |
records.
Given |the |following |two |tables |(Product, |Manufacturer), |which |one |of |the |following |is |an |
example |of |a |foreign |key?
Product
ProductID |MfrID |Name |Price |Qty
5006 |2 |Ball |Peen |Hammer |6.99 |47
5007 |1 |5-lb. |Mallet |9.99 |11
5009 |2 |10-lb. |Mallet |11.49 |6
, Manufacturer
MfrID |MfrName
1 |Arcturus |Tools
2 |Nemesis |Manufacturing |Supply |- |CORRECT |ANSWER✔✔-The |MfrID |field |in |the |Product |
table.
When |there |is |a |relationship |between |records |in |two |different |tables... |- |CORRECT |
ANSWER✔✔-The |mandatory |side |donates |its |key |to |the |many |side.
Which |of |the |following |is |not |a |clause |in |a |SELECT |query? |- |CORRECT |ANSWER✔✔-SORT |BY
Assuming |that |the |table |and |fields |referenced |are |valid, |which |of |the |following |queries |have |
appropriate |syntax |and |would |work |without |error? |- |CORRECT |ANSWER✔✔-SELECT |
PlayerName, |Position, |Height
FROM |Roster
WHERE |Height |> |63
ORDER |BY |Position;
Using |a |database |that |includes |information |about |every |opera |ever |written, |I |want |to |write |a |
query |that |displays |information |only |about |those |operas |that |were |written |prior |to |the |year |
1825. |To |do |this, |I |would |use |which |of |the |following? |- |CORRECT |ANSWER✔✔-WHERE |clause
Which |of |the |following |WHERE |clauses |would |include |only |those |records |in |the |output |where |
the |value |in |the |Destination |field |is |something |OTHER |than |Norman? |- |CORRECT |ANSWER✔✔-
WHERE |Destination |<> |'Norman'
With Correct Answers
Enabling |different |data |points |to |relate |to |one |another... |- |CORRECT |ANSWER✔✔-Is |one |of |the
|core |functions |of |a |database.
A |company |includes |information |about |its |customers |in |a |database |table |called |Customer. |
Each |line |within |this |table |includes |a |customer's |name, |phone |number, |address, |and |date |of |
birth. |These |lines |are |called... |
` |- |CORRECT |ANSWER✔✔-Records
A |"primary |key" |is... |- |CORRECT |ANSWER✔✔-Required |for |each |record.
Databases... |(Select |all/any |that |apply.) |- |CORRECT |ANSWER✔✔-Rely |on |primary |and |foreign |
keys |to |relate |records |from |different |tables.
In |a |company's |database, |a |given |table... |- |CORRECT |ANSWER✔✔-Can |include |millions |of |
records.
Given |the |following |two |tables |(Product, |Manufacturer), |which |one |of |the |following |is |an |
example |of |a |foreign |key?
Product
ProductID |MfrID |Name |Price |Qty
5006 |2 |Ball |Peen |Hammer |6.99 |47
5007 |1 |5-lb. |Mallet |9.99 |11
5009 |2 |10-lb. |Mallet |11.49 |6
, Manufacturer
MfrID |MfrName
1 |Arcturus |Tools
2 |Nemesis |Manufacturing |Supply |- |CORRECT |ANSWER✔✔-The |MfrID |field |in |the |Product |
table.
When |there |is |a |relationship |between |records |in |two |different |tables... |- |CORRECT |
ANSWER✔✔-The |mandatory |side |donates |its |key |to |the |many |side.
Which |of |the |following |is |not |a |clause |in |a |SELECT |query? |- |CORRECT |ANSWER✔✔-SORT |BY
Assuming |that |the |table |and |fields |referenced |are |valid, |which |of |the |following |queries |have |
appropriate |syntax |and |would |work |without |error? |- |CORRECT |ANSWER✔✔-SELECT |
PlayerName, |Position, |Height
FROM |Roster
WHERE |Height |> |63
ORDER |BY |Position;
Using |a |database |that |includes |information |about |every |opera |ever |written, |I |want |to |write |a |
query |that |displays |information |only |about |those |operas |that |were |written |prior |to |the |year |
1825. |To |do |this, |I |would |use |which |of |the |following? |- |CORRECT |ANSWER✔✔-WHERE |clause
Which |of |the |following |WHERE |clauses |would |include |only |those |records |in |the |output |where |
the |value |in |the |Destination |field |is |something |OTHER |than |Norman? |- |CORRECT |ANSWER✔✔-
WHERE |Destination |<> |'Norman'
