Oracle SQL Oracle SQL Joins and Subqueries 2

Question 1

Which Oracle SQL operator checks if a subquery returns at least one row?

Accepted Answer

EXISTS

Answer

IN

Answer

ANY

Answer

SOME

Question 2

What is an inline view in Oracle SQL?

Accepted Answer

A subquery used in the FROM clause

Answer

A view stored in the database

Answer

A view with no data

Answer

A synonym for a table

Question 3

What does a correlated subquery do in Oracle SQL?

Accepted Answer

References a column from the outer query and executes once per outer row

Answer

Runs once and returns a single value

Answer

Creates a permanent view

Answer

Performs a full table scan only once

Question 4

Which keyword allows you to join tables using a column with the same name in both tables in Oracle SQL?

Accepted Answer

USING

Answer

ON

Answer

WHERE

Answer

NATURAL JOIN

Question 5

What does the NATURAL JOIN keyword do in Oracle SQL?

Accepted Answer

Joins tables based on all columns with the same name

Answer

Joins tables based on primary key relationships

Answer

Returns only distinct rows from joined tables

Answer

Performs a full outer join automatically

Question 6

Which type of subquery is used with the ANY operator in Oracle SQL?

Accepted Answer

Multi-row subquery returning multiple values

Answer

Scalar subquery returning one value

Answer

Correlated subquery with no outer reference

Answer

Inline view in FROM clause