02
Chapter 2: Basic SQL SELECT Statements
TRUE/FALSE
1. An RDBMS is a software program that allows users to enter, manipulate, and retrieve data.
ANS: T PTS: 1 REF: 25
2. An ORDBMS is more advanced than a simple RDBMS since the user can also create reports.
ANS: F PTS: 1 REF: 26
3. There are six editions available for Oracle10g.
ANS: F PTS: 1 REF: 26
4. The majority of operations performed on a database table utilize the SELECT statement.
ANS: T PTS: 1 REF: 28
5. When a user asks the database a question, the user is issuing a query.
ANS: T PTS: 1 REF: 28
6. Each section of a SQL command that begins with a keyword is known as a statement.
ANS: F PTS: 1 REF: 29
7. A clause is a section within a SQL statement that begins with a keyword.
ANS: T PTS: 1 REF: 29
8. SQL*Plus is an Oracle tool used to enter and edit SQL statements.
ANS: T PTS: 1 REF: 26
9. SQL*Plus can only be accessed via an internet interface.
ANS: F PTS: 1 REF: 26
10. A script file containing SQL statements can be executed from SQL*Plus.
ANS: T PTS: 1 REF: 26
11. The DESCRIBE command is used to view data in a table.
ANS: F PTS: 1 REF: 26
12. A query is accomplished by issuing a SELECT statement.
ANS: T PTS: 1 REF: 28
13. The asterisk symbol (*) can be used in a SELECT statement to indicate that all rows in the table should be displayed in the results.
ANS: F PTS: 1 REF: 29
14. 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.
ANS: T PTS: 1 REF: 29
15. Column headings may be truncated in the results of a SELECT statement.
ANS: T PTS: 1 REF: 30
16. The SELECT clause of the SELECT statement is used to identify which rows are to be retrieved from a specified table.
ANS: F PTS: 1 REF: 31
17. Choosing specific columns to be displayed by a SELECT statement is known as selection.
ANS: F PTS: 1 REF: 31
18. Choosing specific columns to be displayed by a
TRUE/FALSE
1. An RDBMS is a software program that allows users to enter, manipulate, and retrieve data.
ANS: T PTS: 1 REF: 25
2. An ORDBMS is more advanced than a simple RDBMS since the user can also create reports.
ANS: F PTS: 1 REF: 26
3. There are six editions available for Oracle10g.
ANS: F PTS: 1 REF: 26
4. The majority of operations performed on a database table utilize the SELECT statement.
ANS: T PTS: 1 REF: 28
5. When a user asks the database a question, the user is issuing a query.
ANS: T PTS: 1 REF: 28
6. Each section of a SQL command that begins with a keyword is known as a statement.
ANS: F PTS: 1 REF: 29
7. A clause is a section within a SQL statement that begins with a keyword.
ANS: T PTS: 1 REF: 29
8. SQL*Plus is an Oracle tool used to enter and edit SQL statements.
ANS: T PTS: 1 REF: 26
9. SQL*Plus can only be accessed via an internet interface.
ANS: F PTS: 1 REF: 26
10. A script file containing SQL statements can be executed from SQL*Plus.
ANS: T PTS: 1 REF: 26
11. The DESCRIBE command is used to view data in a table.
ANS: F PTS: 1 REF: 26
12. A query is accomplished by issuing a SELECT statement.
ANS: T PTS: 1 REF: 28
13. The asterisk symbol (*) can be used in a SELECT statement to indicate that all rows in the table should be displayed in the results.
ANS: F PTS: 1 REF: 29
14. 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.
ANS: T PTS: 1 REF: 29
15. Column headings may be truncated in the results of a SELECT statement.
ANS: T PTS: 1 REF: 30
16. The SELECT clause of the SELECT statement is used to identify which rows are to be retrieved from a specified table.
ANS: F PTS: 1 REF: 31
17. Choosing specific columns to be displayed by a SELECT statement is known as selection.
ANS: F PTS: 1 REF: 31
18. Choosing specific columns to be displayed by a