preview

02

Satisfactory Essays
Open Document

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 …show more content…

The syntax for a SQL statement gives the basic structure required to execute the statement. _________________________

ANS: T PTS: 1 REF: 28

4. A query can be executed in the SQL*Plus tool. _________________________

ANS: T PTS: 1 REF: 26

5. Each section of a statement that begins with a keyword is known as a(n) buffer. _________________________

ANS: F, clause

PTS: 1 REF: 29

6. The only required clauses for a SELECT statement are the WHERE and FROM clauses. _________________________

ANS: F, SELECT

PTS: 1 REF: 29

7. The ALL option can be used in the SELECT clause to indicate that all columns should be retrieved. _________________________

ANS: F, *

PTS: 1 REF: 29

8. Each clause of a SELECT statement must be entered on a new line in SQL*Plus. _________________________

ANS: F, optional

PTS: 1 REF: 29

9. The SELECT clause identifies the table containing the data to be queried. _________________________

ANS: F, FROM

PTS: 1 REF: 29

10. A column heading that is longer than the width of a column will not be truncated for a column that is defined to store character data. _________________________

ANS: F, numeric

PTS: 1 REF: 30

11. The SELECT command can be used to display the structure of a database table. _________________________

ANS: F, DESCRIBE

PTS: 1 REF: 27 | 30

12. Choosing specific columns from a database through a SELECT statement is known as projection. _________________________

ANS: T PTS: 1 REF: 31

13. In

Get Access
Related
Get Access