OCP SQL & PL/SQL Programming

Question 1

What is the function of a cursor in PL/SQL?

Accepted Answer

It points to the data being queried

Answer

It stores query results

Answer

It holds user inputs

Answer

It handles exceptions

Question 2

Which PL/SQL block is used to handle exceptions?

Accepted Answer

EXCEPTION

Answer

BEGIN-END

Answer

DECLARE-BEGIN

Answer

LOOP-END LOOP

Question 3

Which SQL clause is used to filter results based on specific conditions?

Accepted Answer

WHERE

Answer

FROM

Answer

ORDER BY

Answer

HAVING

Question 4

What is the purpose of a trigger in PL/SQL?

Accepted Answer

To automatically perform actions based on certain events

Answer

To display results

Answer

To modify data manually

Answer

To create a new table

Question 5

Which command is used to exit from SQL*Plus?

Accepted Answer

EXIT

Answer

QUIT

Answer

STOP

Answer

END

Question 6

What is the use of the SQL IN operator?

Accepted Answer

To check if a value matches any in a list

Answer

To filter by a range of values

Answer

To group similar records

Answer

To find patterns in text data

Question 7

What is the difference between a LEFT JOIN and a RIGHT JOIN in SQL?

Accepted Answer

LEFT JOIN returns all from left, RIGHT JOIN returns all from right

Answer

There is no difference

Answer

LEFT JOIN is used for smaller datasets

Answer

RIGHT JOIN is used for data filtering

Question 8

What is a sequence in SQL?

Accepted Answer

A generator of unique numbers

Answer

A set of data from a table

Answer

A collection of rows in a database

Answer

A temporary storage for data

Question 9

What does the PL/SQL keyword 'EXCEPTION' handle?

Accepted Answer

It handles runtime errors

Answer

It terminates the program

Answer

It stores data in a backup file

Answer

It stores user inputs