MIS 3353 Master Study Guide 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'
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'
Which |aggregate |function |would |you |use |(in |the |SELECT |clause) |if |you |wanted |to |know |the |
total |number |of |magicians |in |the |Magician |table |who |are |from |Albuquerque? |- |CORRECT |
ANSWER✔✔-COUNT
To |override |precedence |of |AND, |OR, |and |NOT, |use: |- |CORRECT |ANSWER✔✔-Parentheses
* |in |an |SQL |SELECT |statement |means: |- |CORRECT |ANSWER✔✔-List |all |columns
Let's |assume |that |you |wrote |a |query |that |has |the |following |four |clauses: |SELECT, |FROM, |
WHERE, |ORDER |BY. |The |order |in |which |the |four |SQL |query |clauses |are |executed |is |_____ |
_____ |_____ |_____. |(separate |your |answers |by |commas.) |- |CORRECT |ANSWER✔✔-From, |
Where, |Select, |Order |By
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.
Assuming |no |fields/keys |are |misnamed, |which |of |the |following |multiple-table |queries |would |
you |expect |to |run |without |errors? |- |CORRECT |ANSWER✔✔-SELECT |Mountain.GPSLat, |
Mountain.GPSLon, |Location.StateName
FROM |Mountain, |Location
WHERE |Mountain.LocID |= |Location.LocID
ORDER |BY |Location.LocID;
When |joining |three |tables |within |the |same |query, |which |of |the |following |is |true? |- |CORRECT |
ANSWER✔✔-You |create |a |"virtual |table" |that |includes |matching |records |from |all |three |tables.
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'
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'
Which |aggregate |function |would |you |use |(in |the |SELECT |clause) |if |you |wanted |to |know |the |
total |number |of |magicians |in |the |Magician |table |who |are |from |Albuquerque? |- |CORRECT |
ANSWER✔✔-COUNT
To |override |precedence |of |AND, |OR, |and |NOT, |use: |- |CORRECT |ANSWER✔✔-Parentheses
* |in |an |SQL |SELECT |statement |means: |- |CORRECT |ANSWER✔✔-List |all |columns
Let's |assume |that |you |wrote |a |query |that |has |the |following |four |clauses: |SELECT, |FROM, |
WHERE, |ORDER |BY. |The |order |in |which |the |four |SQL |query |clauses |are |executed |is |_____ |
_____ |_____ |_____. |(separate |your |answers |by |commas.) |- |CORRECT |ANSWER✔✔-From, |
Where, |Select, |Order |By
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.
Assuming |no |fields/keys |are |misnamed, |which |of |the |following |multiple-table |queries |would |
you |expect |to |run |without |errors? |- |CORRECT |ANSWER✔✔-SELECT |Mountain.GPSLat, |
Mountain.GPSLon, |Location.StateName
FROM |Mountain, |Location
WHERE |Mountain.LocID |= |Location.LocID
ORDER |BY |Location.LocID;
When |joining |three |tables |within |the |same |query, |which |of |the |following |is |true? |- |CORRECT |
ANSWER✔✔-You |create |a |"virtual |table" |that |includes |matching |records |from |all |three |tables.
