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