DP - Section 1 (2)

Question 1

In its simplest form, a SELECT statement must include the following: 2

Answer 1

1. SELECT clause
2. FROM clause

Question 2

……….. ………: Specifies the columns to be displayed (or use * symbol to display all columns).

Answer 2

SELECT clause

Question 3

………… ………….: Specifies the table containing the column(s) listed in the select clause.

Answer 3

FROM clause

Question 4

…………..: An implementation of an attribute or relationship in a table.

Answer 4

Column

Question 5

A ……………. refers to a individual SQL Command

Answer 5

Keyword

for example SELECT and FROM are keywords

Question 6

A …………… is part of SQL statement

Answer 6

clause

For example, SELECT Last_name is a clause

Question 7

A ………….. is combination of two or more clauses

Answer 7

statement

For example, SELECT last_name From employees is statement

Question 8

The following SQL style conventions are used throughout this course:

1. SQL Keywords in ………………………………
2. Column and table names in …………………………
3. Each clause on a ………………….

Answer 8

1. UPPERCASE – e.g. SELECT, FROM, WHERE.
2. lower case – e.g. first_name, employees.
3. new line – e.g:

SELECT last_name
FROM employees
WHERE employee_id = 101;

Question 9

Capabilities of SELECT Statements ……………… 2

Answer 9

1. Projection
2. Selection

Question 10

………………: Used to choose rows in a table

Answer 10

Selection

Question 11

……………: Used to choose columns in a table

Answer 11

Projection

Question 12

The …………… clause determines Projection

The ………….. clause determines Selection.

Answer 12

SELECT

WHERE

Question 13

Sometimes doing a SELECT * FROM table can take a long time to return the data. It all depends on the number of rows stored in that particular table. Remember, Oracle tables can store millions of rows of data.

Answer 13

R 1

Question 14

All examples on the slides have a ………….. after each statement. Oracle Application Express does not require this syntax, but other Oracle SQL Interfaces do, so we have included them in the courseware.

Answer 14

semicolon