20 Questions

Plsql Quiz

1 :-

34)Which PL/SQL statement is used to create a trigger?

2 :-

1)What is PL/SQL?

3 :-

3)What is the maximum number of parameters that can be passed to a PL/SQL procedure or function?

4 :-

22)Which keyword is used to create a nested table type?

5 :-

31)Which PL/SQL construct is used to define a procedure?

6 :-

18)Which PL/SQL statement is used to declare a date variable?

7 :-

33)Which keyword is used to declare a global variable in a PL/SQL block?

8 :-

50)Which PL/SQL construct is used to define a trigger that fires once for each row affected by the DML statement?

9 :-

27)Which PL/SQL construct is used to pass a cursor variable as a parameter?

10 :-

7)Which PL/SQL construct is used to iterate through a set of values?

11 :-

21)Which PL/SQL construct is used to define a collection Table type?

12 :-

9)Which PL/SQL statement is used to delete data from a table?

13 :-

44)Which PL/SQL construct is used to handle NULL values?

14 :-

15)Which PL/SQL statement is used to declare a constant?

15 :-

6)What is the purpose of a package in PL/SQL?

16 :-

37)Which PL/SQL statement is used to open a cursor?

17 :-

11)What is the difference between a function and a procedure in PL/SQL?

18 :-

20)Which PL/SQL construct is used to define a user-defined type?

19 :-

10)Which PL/SQL keyword is used to define a variable?

20 :-

26)Which PL/SQL construct is used to define a cursor variable?

Mock Test Completion Certificate
You scored 0 out of 20 questions.

🏅

For your extraordinary service and contributions to your profession.
We are delighted in providing this certificate to you.

Tips for improving your score:

  • Make sure to read the questions and answer choices carefully.
  • Don't try to answer any choices that you don't know. It's better to skip a question.