Oracle SQL Test 1

Question 1

Keywords can't be split across lines or truncated.

Accepted Answer

True

Answer

In Oracle SQL, keywords are reserved words that have specific meanings and functions within the language. These keywords must be written as complete, unbroken units and cannot be split across multiple lines or truncated. This rule ensures that the SQL parser can correctly interpret the commands and execute the query as intended.

Question 2

Which clause limits the query to rows that fulfill a set of criteria?

Accepted Answer

Where

Answer

The `WHERE` clause in SQL is specifically used to filter the rows returned by a query, limiting the result set to only those rows that satisfy a specified condition or set of criteria. It evaluates a boolean expression for each row and includes only the rows for which the expression is true. Other clauses like `ORDER BY` sort the results, and `DISTINCT` removes duplicates, but `WHERE` is for row-level filtering.

Question 3

Which of the following statements concerning Column Alias is incorrect?

Accepted Answer

Is Oracle vendor specific

Answer

Column aliases are a standard feature in SQL, used to rename a column heading in the query's output for better readability, especially when dealing with complex expressions or calculations. They are not Oracle vendor-specific but are part of the ANSI SQL standard. If an alias contains spaces, special characters, or needs to be case-sensitive, it must be enclosed in double quotation marks.

Question 4

Which of the following statements about subquery operators is correct?

Accepted Answer

The <ANY operator means less than the maximum.

Answer

The `<ANY` operator in SQL subqueries means that the value being compared is less than at least one of the values returned by the subquery. This effectively means the value is less than the maximum value present in the subquery's result set. For example, `salary < ANY (SELECT salary FROM employees WHERE department_id = 10)` would return employees whose salary is less than the highest salary in department 10.

Question 5

The columns to be shown are identified by_______, while the table containing columns is identified by _______ .

Accepted Answer

From and select

Answer

In a standard SQL `SELECT` statement, the `SELECT` clause is used to identify the specific columns that you want to display in your query's output. Conversely, the `FROM` clause is used to specify the table or tables from which these columns and their corresponding data should be retrieved. This fundamental structure dictates what data is shown and where it originates.

Oracle SQL Practice Test

Oracle SQL Practice Test

Oracle SQL Test 1