Oracle - Data Retrieval MCQ

Oracle – Data Retrieval

1 / 17

1. In Oracle, which type of cursor is created implicitly by the system to process SQL statements?

Explicit cursor

Static cursor

Dynamic cursor

Implicit cursor

2 / 17

2. What does DML stand for in Oracle?

Data Manipulation Language

Data Management Language

Data Modeling Language

Database Markup Language

3 / 17

3. In Oracle PL/SQL, what is the primary advantage of using explicit cursors?

They are more efficient than implicit cursors

They don't support error handling

They are automatically managed by the system

They require fewer lines of code

4 / 17

4. Which SQL statement is used to open an explicit cursor in Oracle PL/SQL?

DECLARE

FETCH

OPEN

CLOSE

5 / 17

5. What is the purpose of the FETCH statement in Oracle PL/SQL?

To open an explicit cursor

To close a cursor

To declare a cursor variable

To fetch rows from a cursor into variables

6 / 17

6. In Oracle PL/SQL, what are column aliases used for in explicit cursors?

To specify the cursor type

To declare cursor variables

To rename columns in the result set

To define cursor parameters

7 / 17

7. What is the primary purpose of the WHERE CURRENT OF clause in Oracle PL/SQL?

To release locks acquired by a cursor

To declare cursor variables

To filter rows based on current cursor position

To specify a cursor's return type

8 / 17

8. What are cursor variables also known as in Oracle PL/SQL?

Explicit cursors

Dynamic cursors

Cursor expressions

REF CURSORs

9 / 17

9. In Oracle PL/SQL, what is the primary advantage of using cursor variables (REF CURSORs)?

They are statically defined

They can be used as arguments to procedures

They can be opened and closed explicitly

They are efficient for single-row queries

10 / 17

10. In Oracle PL/SQL, which statement is used to declare cursor variables (REF CURSORs)?

OPEN

DECLARE

CURSOR

FETCH

11 / 17

11. What is the purpose of cursor expressions in Oracle PL/SQL?

To create complex result sets

To simplify cursor declaration

To dynamically define cursor attributes

To define cursor parameters

12 / 17

12. When working with cursor expressions in Oracle PL/SQL, what is a key restriction?

They cannot be used with explicit cursors

They cannot be used with dynamic cursors

They cannot contain multiple SELECT statements

They cannot be used as arguments to procedures

13 / 17

13. In Oracle, what is the purpose of a cursor in PL/SQL?

To create and manage tables

To define user roles and permissions

To open and close database connections

To retrieve and manipulate data in a result set

14 / 17

14. In Oracle PL/SQL, how can you reference PL/SQL variables in a cursor?

By using only literal values

By using cursor attributes

By using table aliases

By using variable names directly in SQL statements

15 / 17

15. When should you choose explicit cursors over implicit cursors in Oracle PL/SQL?

When you want to simplify your code

When you want to use cursor attributes

When you need to retrieve data from the database

When you want to declare cursor variables

16 / 17

16. What is the purpose of the COMMIT statement in Oracle PL/SQL?

To define a savepoint within a transaction

To lock a table for exclusive access

To save all the changes made during the current transaction

To undo all the changes made during the current transaction

17 / 17

17. What does the RETURNING clause in DML statements provide in Oracle?

It returns the primary key of the table

It returns the total number of rows affected by the statement

It returns the current timestamp

It returns the rows that were inserted, updated, or deleted

Your score is

0%

Oracle – Data Retrieval MCQ