MIS 3353 - Single-Table SQL Exam
Questions With Correct Answers
Which |of |the |following |is |not |a |clause |in |a |SELECT |query?
- |GROUP |BY
- |WHERE
- |SORT |BY
- |SELECT |- |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?
- |SELECT |PlayerName, |Gender, |Position
WHERE |Position |= |'Seeker'
SORT |BY |PlayerName |ASC;
- |SELECT |PlayerName, |Hometown
FROM |Roster
WHERE |Hometown |IS |'Pittsburgh'
- |SELECT |PlayerNumber, |PlayerName, |Weight
WHERE |Weight |> |100
, FROM |Roster;
- |SELECT |PlayerName, |Position, |Height
FROM |Roster
WHERE |Height |> |63
ORDER |BY |Position; |- |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?
- |SORT |BY |clause
- |HAVING |clause
- |WHERE |clause
- |@ |operator |- |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?
- |WHERE |Destination |<> |'Norman'
Questions With Correct Answers
Which |of |the |following |is |not |a |clause |in |a |SELECT |query?
- |GROUP |BY
- |WHERE
- |SORT |BY
- |SELECT |- |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?
- |SELECT |PlayerName, |Gender, |Position
WHERE |Position |= |'Seeker'
SORT |BY |PlayerName |ASC;
- |SELECT |PlayerName, |Hometown
FROM |Roster
WHERE |Hometown |IS |'Pittsburgh'
- |SELECT |PlayerNumber, |PlayerName, |Weight
WHERE |Weight |> |100
, FROM |Roster;
- |SELECT |PlayerName, |Position, |Height
FROM |Roster
WHERE |Height |> |63
ORDER |BY |Position; |- |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?
- |SORT |BY |clause
- |HAVING |clause
- |WHERE |clause
- |@ |operator |- |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?
- |WHERE |Destination |<> |'Norman'
