Similar Collections

    No collections found

questions

Title
What is the difference between PL/SQL Function and PL/SQL Procedure?

What is the difference between PL/SQL Function and PL/SQL Procedure?

  1. PL/SQL function may or may not return the value whereas PL/SQL Procedure must have to return the value.
  2. PL/SQL Procedure may or may not return the value whereas PL/SQL Function must have to return the value.
  3. PL/SQL Function may or may not return the function whereas PL/SQL Procedure must have to return the function.
  4. None of the above
discuss
Which of the following is NOT present in the syntax of PL/SQL function?

Which of the following is NOT present in the syntax of PL/SQL function?

  1. Function_name
  2. [OR REPLACE]
  3. Optional Parameter List
  4. None of the above
discuss
PL/SQL function must contain a –

PL/SQL function must contain a –

  1. Follow Statement
  2. GOTO Statement
  3. Return Statement
  4. NULL Statement
discuss
AS Keyword is used in the PL/SQL function in order to create a –

AS Keyword is used in the PL/SQL function in order to create a –

  1. Identity Function
  2. Quadratic Function
  3. One to One Function
  4. Standalone Function
discuss
We can demonstrate which of the following in a PL/SQL function?

We can demonstrate which of the following in a PL/SQL function?

  1. Declare
  2. Define
  3. Invoke
  4. All of the above
discuss
Which of the following is /are TRUE about calling a PL/SQL function?

Which of the following is /are TRUE about calling a PL/SQL function?

  1. You need to define a function's purpose when creating it.
  2. In order to utilize a function, you must call it in order to accomplish the defined task.
  3. Calling a function passes the program control to that function.
  4. All of the above
discuss
The call function returns program control to the ____ after successful completion of the defined task

The call function returns program control to the ____ after successful completion of the defined task.

  1. Main Table
  2. Main Database
  3. Main Program
  4. Main Row
discuss
Calling a function requires that the parameters be provided along with the ____, and if the function returns a value, that value can be stored

Calling a function requires that the parameters be provided along with the ____, and if the function returns a value, that value can be stored.

  1. Function Name
  2. Optional Parameter List
  3. IF Statement
  4. Rollback Statement
discuss
It is called ____ when the subprogram calls itself and ____ is the process

 It is called ____ when the subprogram calls itself and ____ is the process.

  1. Recursion, Recursive Call
  2. Recursive Call, Recursion
  3. Recursive Name, Recursive Call
  4. Recursive Call, Recursive Name
discuss
In order to remove the PL/SQL function, which function is used?

In order to remove the PL/SQL function, which function is used?

  1. REMOVE FUNCTION
  2. DELETE FUNCTION
  3. ERASE FUNCTION
  4. DROP FUNCTION
discuss
total MCQs: 10

MCQs

10

Views

54

Best Answers

299

Points

5