1Z0-006 Basic SQL Statements 5

Question 1

Which of the following SQL statements modifies existing data in a table?

Accepted Answer

UPDATE

Answer

UPDATE changes the values of existing rows in a table based on the specified SET and optional WHERE conditions.

Question 2

What is the effect of using ORDER BY SALARY DESC in a SELECT statement?

Accepted Answer

Rows are sorted by SALARY from highest to lowest

Answer

DESC (descending) orders values from the largest to the smallest, so the highest salary appears first.

Question 3

In Oracle, which character is used to concatenate two strings in SQL?

Accepted Answer

||

Answer

Oracle uses the || (double pipe) operator to concatenate strings, e.g., first_name || ' ' || last_name.

Question 4

Which of the following WHERE conditions correctly uses the LIKE operator to find names starting with 'J'?

Accepted Answer

WHERE name LIKE 'J%'

Answer

J% matches any string that starts with 'J' followed by zero or more characters.

Question 5

What does the AVG aggregate function do when NULL values are present in the column?

Accepted Answer

Ignores NULL values in the calculation

Answer

AVG (like most aggregate functions) ignores NULL values and calculates the average only from non-NULL values.

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