20 Questions

Plsql Quiz

1 :-

1)What is PL/SQL?

2 :-

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

3 :-

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

4 :-

12)Which PL/SQL keyword is used to exit a loop?

5 :-

17)Which PL/SQL statement is used to declare a fixed-length character string?

6 :-

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

7 :-

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

8 :-

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

9 :-

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

10 :-

36)Which PL/SQL statement is used to declare a cursor?

11 :-

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

12 :-

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

13 :-

28)Which PL/SQL construct is used to handle implicit cursors?

14 :-

23)Which PL/SQL package contains the UTL_FILE package for reading and writing files?

15 :-

40)Which PL/SQL statement is used to drop a package

16 :-

25)Which PL/SQL package is used for dynamic SQL?

17 :-

8)Which PL/SQL statement is used to update data in a table?

18 :-

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

19 :-

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

20 :-

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

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.