1Z0-006 Basic SQL Statements 4

Question 1

In Oracle SQL, which pseudo-table is used when you want to SELECT an expression or function without referencing a real table?

Accepted Answer

DUAL

Answer

DUAL is a special one-row, one-column dummy table in Oracle used to evaluate expressions that don't require a real table.

Question 2

What does the BETWEEN operator include in its range?

Accepted Answer

Both the lower and upper bounds

Answer

BETWEEN x AND y is inclusive; it matches values greater than or equal to x AND less than or equal to y.

Question 3

Which of the following correctly inserts a row with specific column values?

Accepted Answer

INSERT INTO EMPLOYEES VALUES (101, 'Ana');

Answer

The correct Oracle syntax is INSERT INTO table_name [(columns)] VALUES (values).

Question 4

What is a column alias in SQL?

Accepted Answer

A temporary label given to a column in the query result

Answer

A column alias (using AS or a space) gives a temporary name to the column in the output without changing the underlying table.

Question 5

Which SQL function converts a string to uppercase?

Accepted Answer

UPPER

Answer

UPPER(string) returns the string with all characters converted to uppercase letters.

(1Z0-006) Oracle Database Foundations Associate Practice Test