NiC IT Academy

PLSQL Quiz – 02

By Mr.Chandra

Loading

1) Which of the following is NOT a Boolean literal?

2) Which of the following is a Character literal?

3) What programming languages features are used in PL/SQL?

4) Which of the following is correct syntax of IF statement?

5) ____ executes the corresponding code whenever a TRUE condition is found. Otherwise, the condition cannot be checked again.

6) Which portion is optional in IF statements?

7) CASE statement uses which keyword to work like IF statement?

8) What are the selectors in case of CASE statement?

9) Evaluation of CASE statement is done –

10) By using PL/SQL ____, you can repeatedly execute one or more statements over and over again.

11) PL/SQL Loops are also known as –

12) How many types of PL/SQL Loops are there?

13) Which of the following is correct type of PL/SQL Loop?

14) A/An _______ loop in PL/SQL ensures that at least one statement is executed before the loop terminates.

15) The PL/SQL ____ loop runs a series of statements as long as a condition is true, so it can be used in a series of statements.

16) When you want to execute a series of statements repeatedly, you use the PL/SQL ____ loop.

17) The counter in PL/SQL FOR Loop is by default incremented by –

18) PL/SQL ____ statement initiates the next iteration of a loop, skipping any code in between, by exiting the loop from the reminder in its body either conditionally or unconditionally.

19) In which Oracle does the PL/SQL Continue Statement is supported?

20) A ____ statement in PL/SQL allows you to jump from this statement to a specific statement label within the same subprogram within a PL/SQL block.

Login with your email & password

Sign up with your email & password

Signup/Registration Form