Week 8

Question 1

The most used operation performed in most Databases is what?

Answer 1

SELECT (running a query)

Question 2

If you want the SELECT statement to return all columns, what do you use?

A. All
B. Any
C. *
D. $

Answer 2

C. *

Select *

Question 3

Use the _____ statement to choose a table from the SELECT statement.

Answer 3

FROM

Question 4

To choose a specific condition, what statement do you use?

Answer 4

WHERE

Question 5

what is the statement to use to rename a column in the query?

A. RENAME
B. AS
C. COLUMN-NAME
D. FIX

Answer 5

B. AS

Question 6

T/F: When you use the AS statement, you MUST use double quotes (“ “).

Answer 6

False

Only if you want to add spaces or use lower case.

Question 7

In Oracle 12c, arithmetic operations work in what order, and what operations are performed first?

Answer 7

left to right
multiplication/division, then addition/subtraction
Parenthesis can change the order

Question 8

What is the statement used if you do not want your query to return duplicates?

Answer 8

DISTINCT

Question 9

Combining the contents of two or more columns is known as ______.

Answer 9

concatenation

Question 10

To concatenate what do you use?

A. “ “
B. | |
C. - -

Answer 10

B. | |