Quiz on Restricting Rows and Sorting Data
Chapter 8: Restricting Rows and Sorting Data
TRUE/FALSE
1. Retrieving only certain rows from a table is known as projection.
ANS: F PTS: 1 REF: 223
2. Retrieving only specific rows from a table is a process known as selection.
ANS: T PTS: 1 REF: 223
3. Although Oracle10g is not case sensitive in regards to keywords, table names, and column names, it is case sensitive when comparing search conditions to the data contained in a database table.
ANS: T PTS: 1 REF: 225
4. Search conditions for data contained in non-numeric columns must be enclosed in double quotation marks.
ANS: F PTS: 1 REF: 226 | 249
5. Search conditions for data contained in numeric columns must be enclosed in single quotation marks.
ANS: F PTS: 1 REF: 226
6. The BETWEEN...AND comparison operator can be used to specify a range of values as a search condition.
ANS: T PTS: 1 REF: 230
7. The IN comparison operator is used when searching for a pattern of characters.
ANS: F PTS: 1 REF: 230
8. The percent sign (%) and asterisk (*) symbols can be used with the LIKE comparison operator to create a search pattern.
ANS: F PTS: 1 REF: 236
9. The percent sign (%) and underscore (_) symbols can be used with the LIKE comparison operator to create a search pattern.
ANS: T PTS: 1 REF: 236
10. The percent sign (%) is used in a search pattern to indicate "exactly one character in this position".
ANS: F PTS: 1 REF: 236
11. The underscore symbol (_) is used in a search pattern to indicate "exactly one character in this position".
ANS: T PTS: 1 REF: 236
12. When two conditions are joined by the AND logical operator, only one of the conditions must be TRUE to be included in the query results.
ANS: F PTS: 1 REF: 238
13. When two conditions are joined by the AND logical operator, both of the conditions must be evaluated as FALSE to be included in the query results.
ANS: F PTS: 1 REF: 238
14. When two conditions are joined by the AND logical operator, both of the conditions must be
TRUE/FALSE
1. Retrieving only certain rows from a table is known as projection.
ANS: F PTS: 1 REF: 223
2. Retrieving only specific rows from a table is a process known as selection.
ANS: T PTS: 1 REF: 223
3. Although Oracle10g is not case sensitive in regards to keywords, table names, and column names, it is case sensitive when comparing search conditions to the data contained in a database table.
ANS: T PTS: 1 REF: 225
4. Search conditions for data contained in non-numeric columns must be enclosed in double quotation marks.
ANS: F PTS: 1 REF: 226 | 249
5. Search conditions for data contained in numeric columns must be enclosed in single quotation marks.
ANS: F PTS: 1 REF: 226
6. The BETWEEN...AND comparison operator can be used to specify a range of values as a search condition.
ANS: T PTS: 1 REF: 230
7. The IN comparison operator is used when searching for a pattern of characters.
ANS: F PTS: 1 REF: 230
8. The percent sign (%) and asterisk (*) symbols can be used with the LIKE comparison operator to create a search pattern.
ANS: F PTS: 1 REF: 236
9. The percent sign (%) and underscore (_) symbols can be used with the LIKE comparison operator to create a search pattern.
ANS: T PTS: 1 REF: 236
10. The percent sign (%) is used in a search pattern to indicate "exactly one character in this position".
ANS: F PTS: 1 REF: 236
11. The underscore symbol (_) is used in a search pattern to indicate "exactly one character in this position".
ANS: T PTS: 1 REF: 236
12. When two conditions are joined by the AND logical operator, only one of the conditions must be TRUE to be included in the query results.
ANS: F PTS: 1 REF: 238
13. When two conditions are joined by the AND logical operator, both of the conditions must be evaluated as FALSE to be included in the query results.
ANS: F PTS: 1 REF: 238
14. When two conditions are joined by the AND logical operator, both of the conditions must be