Similar Collections

    No collections found

questions

Title
Oracle creates ____ when SQL statements are processed

Oracle creates ____ when SQL statements are processed.

  1. Content Areas
  2. Context Areas
  3. Context Ids
  4. Content Ids
discuss
In the contexts created by Oracle, a cursor represents a ____

In the contexts created by Oracle, a cursor represents a ____.

  1. Function
  2. Table
  3. Pointer
  4. None of the above
discuss
An SQL ____ refers to a program that retrieves and processes one row at a time, based on the results of the SQL statement

An SQL ____ refers to a program that retrieves and processes one row at a time, based on the results of the SQL statement.

  1. Cursor
  2. Function
  3. Procedure
  4. View
discuss
How many types of PL/SQL Cursor are there?

How many types of PL/SQL Cursor are there?

  1. 1
  2. 2
  3. 3
  4. 4
discuss
Which of the following is/are the type(s) of the PL/SQL Cursor?

Which of the following is/are the type(s) of the PL/SQL Cursor?

  1. Implicit
  2. Explicit
  3. Both A. and B.
  4. None of the above
discuss
Which of the following PL/SQL Cursor is automatically generated by Oracle?

Which of the following PL/SQL Cursor is automatically generated by Oracle?

  1. Implicit
  2. Explicit
  3. Both a and b
  4. None of the above
discuss
The Implicit cursors are created in order to process the ____ statements

The Implicit cursors are created in order to process the ____ statements.

  1. DDL
  2. DCL
  3. DML
  4. TCL
discuss
Which of the following is/are an/the implicit cursor's attribute(s)?

Which of the following is/are an/the implicit cursor's attribute(s)?

  1. %FOUND
  2. %ROWCOUNT
  3. %ISOPEN
  4. All of the above
discuss
What is TRUE about %FOUND in PL/SQL Cursor?

What is TRUE about %FOUND in PL/SQL Cursor?

  1. If any DML statement, such as INSERT, DELETE or UPDATE, effects one or more rows, or if a SELECT INTO statement returns at least one row, this method returns TRUE.
  2. A SELECT INTO statement or DML statements like INSERT, DELETE, AND UPDATE do not result in any rows being affected.
  3. Because SQL cursors are automatically closed after execution of their associated SQL statements, the function always returns FALSE for implicit cursors.
  4. Results are returned for DML statements such as inserting, deleting, and updating records, or for those returned by a SELECT INTO command.
discuss
What is TRUE about %ISOPEN in PL/SQL Cursor?

What is TRUE about %ISOPEN in PL/SQL Cursor?

  1. If any DML statement, such as INSERT, DELETE or UPDATE, effects one or more rows, or if a SELECT INTO statement returns at least one row, this method returns TRUE.
  2. A SELECT INTO statement or DML statements like INSERT, DELETE, AND UPDATE do not result in any rows being affected.
  3. Because SQL cursors are automatically closed after execution of their associated SQL statements, the function always returns FALSE for implicit cursors.
  4. Results are returned for DML statements such as inserting, deleting, and updating records, or for those returned by a SELECT INTO command.
discuss
What is TRUE about %ROWCOUNT in PL/SQL Cursor?

What is TRUE about %ROWCOUNT in PL/SQL Cursor?

  1. A SELECT INTO statement or DML statements like INSERT, DELETE, AND UPDATE do not result in any rows being affected.
  2. Results are returned for DML statements such as inserting, deleting, and updating records, or for those returned by a SELECT INTO command.
  3. Both A. and B.
  4. None of the above
discuss
For ____ control over the context area, programmers can define explicit cursors

For ____ control over the context area, programmers can define explicit cursors.

  1. Greater
  2. Lesser
  3. Equal
  4. None of the above
discuss
In the PL/SQL Block, Explicit cursors are defined in ___________ section

In the PL/SQL Block, Explicit cursors are defined in ___________ section.

  1. Initialization
  2. Declaration
  3. End
  4. None of the above
discuss
On the ____ statements, the explicit cursors are created which return rows more than one

On the ____ statements, the explicit cursors are created which return rows more than one.

  1. DELETE
  2. CREATE
  3. SELECT
  4. UPDATE
discuss
Which of the following is the correct syntax to create the Explicit Cursor?

Which of the following is the correct syntax to create the Explicit Cursor?

  1. IS select_statement cursor_name CURSOR;
  2. CURSOR select_statement IS cursor_name;
  3. CURSOR cursor_name select_statement IS;
  4. CURSOR cursor_name IS select_statement;
discuss
There are 4 steps to work on Explicit Cursor:

There are 4 steps to work on Explicit Cursor:

  1. Declare the cursor to be initialized in memory.
  2. Allocate memory by opening the cursor.
  3. Retrieve data by fetching the cursor.
  4. Release allocated memory by closing the cursor.

 

Select the correct order of the above 4 steps to work on Explicit Cursor.

  1. II > III > IV > I
  2. I > II > IV > III
  3. I > II > III > IV
  4. IV > III > II > I
discuss
Which of the following is the correct syntax to declare explicit cursor?

Which of the following is the correct syntax to declare explicit cursor?

  1. CURSOR IS name SELECT statement;
  2. CURSOR name is Statement SELECT;
  3. Name IS CURSOR SELECT statement;
  4. CURSOR name IS SELECT statement;
discuss
Which of the following is the correct syntax to fetch the cursor?

Which of the following is the correct syntax to fetch the cursor?

  1. FETCH cursor_name INTO variable_list;
  2. FETCH variable_list INTO cursor_name;
  3. INTO cursor_name FETCH variable_list;
  4. INTO variable_list FETCH cursor_name;
discuss
Which clause is used to open the cursor?

Which clause is used to open the cursor?

  1. BEGIN
  2. START
  3. OPEN
  4. INITIATE
discuss
Which clause is used to close the cursor?

Which clause is used to close the cursor?

  1. END
  2. STOP
  3. CLOSE
  4. FINISH
discuss
total MCQs: 20

MCQs

20

Views

242

Best Answers

299

Points

5