Test bank For Oracle 11G SQL 2nd Edition By Joan Casteel

Chapter 2: Basic SQL SELECT Statements

TRUE/FALSE

1. The majority of operations performed on a typical database table utilize the SELECT statement. ANS: T PTS: 1 REF: 30
2. When a user asks the database a question, the user is issuing a query. ANS: T PTS: 1 REF: 31
3. Each section of a SQL command that begins with a keyword is known as a statement. ANS: F PTS: 1 REF: 31
4. A clause is a section within a SQL statement that begins with a keyword. ANS: T PTS: 1 REF: 31
5. SQL*Plus is an Oracle tool used to enter and edit SQL statements. ANS: T PTS: 1 REF: 27
6. SQL*Plus can only be accessed via an internet interface. ANS: F PTS: 1 REF: 27
7. A script file containing SQL statements can be executed from SQL*Plus. ANS: T PTS: 1 REF: 27
8. The DESCRIBE command is used to view data in a table. ANS: F PTS: 1 REF: 30
9. A query is accomplished by issuing a SELECT statement. ANS: T 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.

    ANS: F PTS: 1 REF: 31|32