MIS 3353 Final Exam Review with verified 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'
Which |of |the |following |WHERE |clauses |would |include |only |those |records |in |the |output |for |which |the |
value |of |UniformNumber |is |1, |3, |5, |or |7? |- |correct |answer | |WHERE |UniformNumber |IN |(1, |3, |5, |7)
Which |of |the |following |WHERE |clauses |would |include |only |those |records |from |the |Customer |table |
where |the |customer's |last |name |(the |LastName |field) |starts |with |Y |and |the |customer's |birthday |(DOB |
field) |falls |some |time |after |1994? |- |correct |answer | |WHERE |LastName |LIKE |'Y%' |AND |DOB |> |'1994-12-
31'
When |joining |tables... |- |correct |answer | |It |is |necessary |to |match |the |foreign |key |in |one |table |to |the |
primary |key |in |another |within |the |query.
| | | | | | |
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'
Which |of |the |following |WHERE |clauses |would |include |only |those |records |in |the |output |for |which |the |
value |of |UniformNumber |is |1, |3, |5, |or |7? |- |correct |answer | |WHERE |UniformNumber |IN |(1, |3, |5, |7)
Which |of |the |following |WHERE |clauses |would |include |only |those |records |from |the |Customer |table |
where |the |customer's |last |name |(the |LastName |field) |starts |with |Y |and |the |customer's |birthday |(DOB |
field) |falls |some |time |after |1994? |- |correct |answer | |WHERE |LastName |LIKE |'Y%' |AND |DOB |> |'1994-12-
31'
When |joining |tables... |- |correct |answer | |It |is |necessary |to |match |the |foreign |key |in |one |table |to |the |
primary |key |in |another |within |the |query.
