NiC IT Academy

PLSQL Quiz -3

By Mr.Chandra

Loading

1) The symbol in which the label_name is encapsulated in PL/SQL GOTO statement is –

2) PL/SQL Procedure consists of –

3) How much number of ways is there to pass the parameters in procedure?

4) Which of the following are the pass parameters in procedure?

5) Which of the following pass parameters can be referenced by procedure?

6) Which of the following cannot be overwritten by procedure?

7) Which of the following can be performed in PL/SQL Procedure?

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

9) PL/SQL function must contain a –

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

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

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

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

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

15) Oracle creates ____ when SQL statements are processed.

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

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

18) How many types of PL/SQL Cursor are there?

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

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

Login with your email & password

Sign up with your email & password

Signup/Registration Form

Registred Email:

- Not Updated -

Set/Update Password