Oracle SQL Oracle SQL Advanced Features 3

Question 1

What is a bind variable in Oracle SQL and why is it important?

Accepted Answer

A placeholder in SQL that promotes cursor sharing and prevents hard parses

Answer

A variable defined in a view

Answer

A constant value defined at database startup

Answer

A variable that binds two tables together

Question 2

Which Oracle SQL feature enables row-level security by filtering rows based on the current user?

Accepted Answer

Virtual Private Database (VPD)

Answer

Column-level encryption

Answer

Fine-Grained Auditing

Answer

Label Security

Question 3

What does the EXPLAIN PLAN statement do in Oracle SQL?

Accepted Answer

Shows the execution plan Oracle will use to run a query without executing it

Answer

Runs a query and explains the result

Answer

Generates documentation for a stored procedure

Answer

Analyzes table statistics

Question 4

Which Oracle SQL hint forces the optimizer to use a specific index?

Accepted Answer

/*+ INDEX(table index_name) */

Answer

/*+ ALL_ROWS */

Answer

/*+ FULL(table) */

Answer

/*+ USE_NL(table) */

Question 5

What is the purpose of the DBMS_STATS package in Oracle SQL?

Accepted Answer

Gathers optimizer statistics on tables, indexes, and columns

Answer

Monitors active database sessions

Answer

Manages database backup statistics

Answer

Reports on SQL execution times

Question 6

Which Oracle SQL feature allows you to query XML data stored in a column using SQL?

Accepted Answer

XMLTABLE

Answer

JSON_TABLE

Answer

EXTRACT

Answer

XML_QUERY