Similar Collections

    No collections found

questions

Title
____ are values used in PL/SQL blocks that do not change during execution

____ are values used in PL/SQL blocks that do not change during execution.

  1. Variables
  2. Constants
  3. Functions
  4. Cursor
discuss
PL/SQL Constant is a/an ____ literal value

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

  1. In-built
  2. User-defined
  3. Both a and b
  4. None of the above
discuss
Choose the correct syntax to declare a constant

Choose the correct syntax to declare a constant.

  1. constant_name CONSTANT datatype := VALUE;
  2. datatype CONSTANT constant_name := VALUE;
  3. constant_name CONSTANT datatype =: VALUE;
  4. datatype CONSTANT constant_name =: VALUE;
discuss
What is TRUE about constant_name in PL/SQL Constant?

What is TRUE about constant_name in PL/SQL Constant?

  1. Exactly like a variable name, it is a name for a constant.
  2. A constant word doesn't change its value and is a reserved word.
  3. Both A. and B.
  4. None of the above
discuss
A value is assigned to a constant in PL/SQL at the time of –

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

  1. Initialization
  2. Declaration
  3. Valuation
  4. Numeralization
discuss
____ are values which do not have an identifier and are numeric, character, string, or boolean

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

  1. Constants
  2. Literals
  3. Cursor
  4. Variables
discuss
Which is the correct example of the literal of type Boolean

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

  1. NULL
  2. TRUE
  3. Both A. and B.
  4. None of the above
discuss
Select the correct statement

Select the correct statement.

  1. PL/SQL literals are case-sensitive
  2. PL/SQL literals are not case-sensitive
  3. PL-SQL Variables are not case-sensitive
  4. None of the above
discuss
Which of the following is NOT a type of PL/SQL literal?

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

  1. Numeric
  2. String
  3. Boolean
  4. Check
discuss
Which of the following is Numeric literal?

Which of the following is Numeric literal?

  1. 1234
  2. 22
  3. 0
  4. All of the above
discuss
Which of the following is NOT a Boolean literal?

Which of the following is NOT a Boolean literal?

  1. TRUE
  2. FALSE
  3. HELLO
  4. NULL
discuss
Which of the following is a Character literal?

Which of the following is a Character literal?

  1. B
  2. 4
  3. %
  4. All of the above
discuss
What programming languages features are used in PL/SQL?

What programming languages features are used in PL/SQL?

  1. Iterative Statements
  2. Conditional Statements
  3. Both A. and B.
  4. None of the above
discuss
Which of the following is correct syntax of IF statement?

Which of the following is correct syntax of IF statement?

  1. IF-THEN statement
  2. IF-THEN-ELSE statement
  3. IF-THEN-ELSIF statement
  4. All of the above
discuss
IF-THEN syntax is used –

IF-THEN syntax is used –

  1. Depending on whether the condition is TRUE or FALSE, you may want to execute one set of statements or another set.
  2. If the condition is TRUE, then you want statements to be executed
  3. As long as condition1 is TRUE, then one set of statements will be executed, and when condition2 is TRUE, another set will be executed.
  4. When condition1 is TRUE, one set of statements will be executed, and when both conditions are FALSE, a different set of statements will be executed.
discuss
IF-THEN-ELSE syntax is used –

IF-THEN-ELSE syntax is used –

  1. Depending on whether the condition is TRUE or FALSE, you may want to execute one set of statements or another set.
  2. If the condition is TRUE, then you want statements to be executed
  3. As long as condition1 is TRUE, then one set of statements will be executed, and when condition2 is TRUE, another set will be executed.
  4. When condition1 is TRUE, one set of statements will be executed, and when both conditions are FALSE, a different set of statements will be executed.
discuss
IF-THEN-ELSIF syntax is used –

IF-THEN-ELSIF syntax is used –

  1. Depending on whether the condition is TRUE or FALSE, you may want to execute one set of statements or another set.
  2. If the condition is TRUE, then you want statements to be executed
  3. As long as condition1 is TRUE, then one set of statements will be executed, and when condition2 is TRUE, another set will be executed.
  4. When condition1 is TRUE, one set of statements will be executed, and when both conditions are FALSE, a different set of statements will be executed.
discuss
____ executes the corresponding code whenever a TRUE condition is found. Otherwise, the condition cannot be checked again

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

  1. IF-THEN statement
  2. IF-THEN-ELSE statement
  3. IF-THEN-ELSIF statement
  4. IF-THEN-ELSIF-ELSE statement
discuss
In the absence of a condition, the ELSE part of the ____ statement will be executed

In the absence of a condition, the ELSE part of the ____ statement will be executed.

  1. IF-THEN-ELSE statement
  2. IF-THEN-ELSIF statement
  3. IF-THEN-ELSIF-ELSE statement
  4. None of the above
discuss
Which portion is optional in IF statements?

Which portion is optional in IF statements?

  1. IF
  2. THEN
  3. ELSE
  4. None of the above
discuss
total MCQs: 20

MCQs

20

Views

64

Best Answers

299

Points

5