DP - Section 1 (2) Flashcards

1
Q

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

A
  1. SELECT clause
  2. FROM clause
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

SELECT clause

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

FROM clause

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

Column

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

Keyword

for example SELECT and FROM are keywords

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

A …………… is part of SQL statement

A

clause

For example, SELECT Last_name is a clause

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

statement

For example, SELECT last_name From employees is statement

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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 ………………….
A
  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;

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Capabilities of SELECT Statements ……………… 2

A
  1. Projection
  2. Selection
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

Selection

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

Projection

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

The …………… clause determines Projection

The ………….. clause determines Selection.

A

SELECT

WHERE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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.

A

R 1

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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.

A

semicolon

How well did you know this?
1
Not at all
2
3
4
5
Perfectly