Oracle-11G-2nd-Edition-Joan-Casteel-Test-Bank.docx -...

Chapter 2: Basic SQL SELECT Statements
TRUE/FALSE
1. The majority of operations performed on a typical database table utilize the SELECT statement.
PTS: 1 REF: 30
2. When a user asks the database a question, the user is issuing a query.
PTS: 1 REF: 31
3. Each section of a SQL command that begins with a keyword is known as a statement.
PTS: 1 REF: 31
4. A clause is a section within a SQL statement that begins with a keyword.
PTS: 1 REF: 31
5. SQL*Plus is an Oracle tool used to enter and edit SQL statements.
PTS: 1 REF: 27
6. SQL*Plus can only be accessed via an internet interface.
PTS: 1 REF: 27
7. A script file containing SQL statements can be executed from SQL*Plus.
PTS: 1 REF: 27
8. The DESCRIBE command is used to view data in a table.
PTS: 1 REF: 30
9. A query is accomplished by issuing a SELECT statement.
PTS: 1 REF: 31
10. The asterisk symbol (*) can be used in a SELECT statement to indicate that all rows in the table
should be displayed in the results.
PTS: 1 REF: 31|32
11. A user can indicate that all columns of a table should be displayed in the results of a SELECT
statement by including an asterisk (*) in the SELECT clause.
PTS: 1 REF: 31|32
12. Column headings may be truncated in the results of a SELECT statement.

PTS: 1 REF: 32
13. The SELECT clause of the SELECT statement is used to identify which rows are to be retrieved from
a specified table.
PTS: 1 REF: 31
14. Choosing specific columns to be displayed by a SELECT statement is known as selection.
PTS: 1 REF: 33
15. Choosing specific columns to be displayed by a SELECT statement is known as projection.
PTS: 1 REF: 33
16. If a column name is entered in lower case in the SELECT statement, the data for the column will be
displayed in lower case in the results.
PTS: 1 REF: 34
17. If multiple column names are listed in the SELECT clause of a SELECT statement, the columns must
be separated by a comma (,).
PTS: 1 REF: 34|35
18. The columns displayed in the results of a SELECT statement will be in the same order as they are
stored in the database table.
PTS: 1 REF: 35
19. If you assign a column alias to a column, it must be enclosed in double quotation marks (" ").
PTS: 1 REF: 37
20. By default, a column alias is displayed in lower case characters in the results.
PTS: 1 REF: 37