NiC IT Academy

PLSQL Quiz – 01

By Mr.Chandra

Loading

1) PL/SQL is a –

2) What does PL/SQL stand for?

3) Oracle Database's ____ are inherited in PL/SQL.

4) PL/SQL text is made up of lexical units, which are groups of characters and can be classified as –

5) A Variable in PL/SQL should not exceed –

6) PL/SQL Variables are by default –

7) PL/SQL Variable needs to be declared in the –

8) The term ____ refers to a declaration with a size, scale, or precision limit.

9) In order to initialize a variable with the value other than NULL, it can be done using which method?

10) What is the name of the two variable scopes in PL/SQL?

11) __ are values used in PL/SQL blocks that do not change during execution.

12) PL/SQL Constant is a/an ____ literal value.

13) Choose the correct syntax to declare a constant.

14) What is TRUE about constant_name in PL/SQL Constant?

15) A value is assigned to a constant in PL/SQL at the time of –

16) ____ are values which do not have an identifier and are numeric, character, string, or boolean.

17) Which is the correct example of the literal of type Boolean.

18) Select the correct statement.

19) Which of the following is NOT a type of PL/SQL literal?

20) Which of the following is Numeric literal?

Login with your email & password

Sign up with your email & password

Signup/Registration Form