IncludeHelp_logo
Skip Navigation Links

Home » SQL

PL/SQL Multiple-Choice Questions (MCQs)

PL/SQL stands for "Procedural Language Extension of SQL". PL/SQL uses a block-structured syntax. Each of the logical blocks of PL/SQL can be nested into any number of subblocks.

This section contains the PL/SQL MCQs on various topics such as Variables, Constants, Literals, Case, Loop, Continue, Trigger, Cursor, Procedure, etc.

These PL/SQL MCQs are written for beginners as well as advanced, practice these MCQs to enhance and test the knowledge of PL/SQL.

PL/SQL MCQs Index

  1. PL/SQL Variables MCQs
  2. PL/SQL Constants, Literals, and If MCQs
  3. PL/SQL CASE, LOOP, CONTINUE, GOTO MCQs
  4. PL/SQL Procedure MCQs
  5. PL/SQL Function MCQs
  6. PL/SQL Cursor MCQs
  7. PL/SQL Triggers MCQs
  8. PL/SQL Exception MCQs

1) PL/SQL Variables MCQs

1. PL/SQL is a –

  1. Brick Structured Language
  2. Block Structured Language
  3. Banner Structured Language
  4. Build Structured Language

Answer: B) Block Structured Language

Explanation:

PL/SQL is a Block Structured Language.

Discuss this Question

2. What does PL/SQL stand for?

  1. PL/SQL stands for Procedural Language Extension of SQL
  2. PL/SQL stands for Primary Language Extension of SQL
  3. PL/SQL stands for Pattern Language Extension of SQL
  4. PL/SQL stands for Private Language Extension of SQL

Answer: A) PL/SQL stands for Procedural Language Extension of SQL

Explanation:

PL/SQL stands for Procedural Language Extension of SQL.

Discuss this Question

3. What is TRUE about PL/SQL functionalities?

  1. Conditions and loops are fundamental elements of procedural languages like PL/SQL.
  2. Various types and variables can be declared, as can procedures and functions, as well as types and variables of those types.
  3. Arrays can be used with it as well as handling exceptions (runtime errors).
  4. All of the above

Answer: D) All of the above

Explanation:

TRUE about PL/SQL functionalities –

  1. Conditions and loops are fundamental elements of procedural languages like PL/SQL.
  2. Various types and variables can be declared, as can procedures and functions, as well as types and variables of those types.
  3. Arrays can be used with it as well as handling exceptions (runtime errors).

Discuss this Question

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

  1. Portability
  2. Robustness
  3. Security
  4. All of the above

Answer: D) All of the above

Explanation:

Oracle Database's portability, robustness and security are inherited in it.

Discuss this Question

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

  1. Delimiters
  2. Identifiers
  3. Literals
  4. All of the above

Answer: D) All of the above

Explanation:

PL/SQL text is made up of lexical units, which are groups of characters and can be classified as Delimiters, Identifiers, Literals and Comments.

Discuss this Question

6. A Variable in PL/SQL should not exceed –

  1. 10
  2. 20
  3. 30
  4. 40

Answer: C) 30

Explanation:

A Variable in PL/SQL should not exceed 30 characters.

Discuss this Question

7. Which of the following is/are TRUE about PL/SQL Variables?

  1. Variables serve as a means for programmers to temporarily store data during code execution.
  2. PL/SQL programs benefit from its use.
  3. There is nothing special about it other than being the name of a storage area.
  4. All of the above

Answer: D) All of the above

Explanation:

In the case of PL/SQL Variables –

  1. Variables serve as a means for programmers to temporarily store data during code execution.
  2. PL/SQL programs benefit from its use.
  3. There is nothing special about it other than being the name of a storage area.

Discuss this Question

8. PL/SQL Variables are by default –

  1. Case Sensitive
  2. Upper Case Sensitive
  3. Lower Case Sensitive
  4. Not Case Sensitive

Answer: D) Not Case Sensitive

Explanation:

PL/SQL Variables are by default not case sensitive.

Discuss this Question

9. PL/SQL Variable needs to be declared in the –

  1. Variable Section
  2. Declaration Section
  3. Initialization Section
  4. None of the above

Answer: B) Declaration Section

Explanation:

PL/SQL Variable needs to be declared in the Declaration Section.

Discuss this Question

10. The correct syntax to declare PL/SQL variable is –

  1. variable_name [CONSTANT] datatype [NOT NULL] [:= | DEFAULT initial_value]
  2. datatype [CONSTANT] variable_name [NOT NULL] [:= | DEFAULT initial_value]
  3. variable_name [CONSTANT] datatype [NULL] [:= | DEFAULT initial_value]
  4. datatype [CONSTANT] variable_name [NULL] [:= | DEFAULT initial_value]

Answer: A) variable_name [CONSTANT] datatype [NOT NULL] [:= | DEFAULT initial_value]

Explanation:

The correct syntax to declare PL/SQL variable is –

variable_name [CONSTANT] datatype [NOT NULL] [:= | DEFAULT initial_value]

Discuss this Question

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

  1. Constant declaration
  2. Constrained declaration
  3. Constant decision
  4. Constrained decision

Answer: B) Constrained declaration

Explanation:

The term constrained declaration refers to a declaration with a size, scale, or precision limit.

Discuss this Question

12. Which of the following is TRUE about Constrained Declaration?

  1. An unconstrained declaration requires more memory than a constrained declaration.
  2. An unconstrained declaration requires less memory than a constrained declaration.
  3. An unconstrained declaration requires equal memory to a constrained declaration.
  4. None of the above

Answer: A) An unconstrained declaration requires more memory than a constrained declaration

Explanation:

An unconstrained declaration requires more memory than a constrained declaration.

Discuss this Question

13. What is/are the Naming Rules for the PL/SQL Variables?

  1. An ASCII letter must be the first letter in the variable name.
  2. In the case of variables, make sure you use easy to read, easy to understand characters after the first character, such as underscore (_) or dollar sign ($).
  3. Optionally, the variable can be specified as NOT NULL.
  4. All of the above

Answer: D) All of the above

Explanation:

The Naming Rules for the PL/SQL Variables states that –

  1. An ASCII letter must be the first letter in the variable name.
  2. In the case of variables, make sure you use easy to read, easy to understand characters after the first character, such as underscore (_) or dollar sign ($).
  3. Optionally, the variable can be specified as NOT NULL.

Discuss this Question

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

  1. The Assignment Operator
  2. The DEFAULT Keyword
  3. Both A. and B.
  4. None of the above

Answer: C) Both A. and B.

Explanation:

In order to initialize a variable with the value other than NULL, it can be done using the Assignment Operator and the DEFAULT Keyword both.

Discuss this Question

15. What is the name of the two variable scopes in PL/SQL?

  1. Local & Grind Variable
  2. Letter & Grind Variable
  3. Local & Global Variable
  4. Letter & Global Variable

Answer: C) Local & Global Variable

Explanation:

The two variable scopes in PL/SQL are Local & Global Variables.

Discuss this Question

16. What is the difference between Local & Global Variables?

  1. Variables in an outer block are defined as local variables since they cannot be accessed from the outside whereas the innermost block declares global variables.
  2. Variables in an inner block are defined as global variables since they cannot be accessed from the outside whereas the outermost block declares local variables.
  3. Variables in an outer block are defined as global variables since they can be accessed from the outside and the innermost block also declares global variables.
  4. Variables in an inner block are defined as local variables since they cannot be accessed from the outside whereas the outermost block declares global variables.

Answer: D) Variables in an inner block are defined as local variables since they cannot be accessed from the outside whereas the outermost block declares global variables.

Explanation:

Variables in an inner block are defined as local variables since they cannot be accessed from the outside whereas the outermost block declares global variables.

Discuss this Question

2) PL/SQL Constants, Literals, and If MCQs

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

  1. Variables
  2. Constants
  3. Functions
  4. Cursor

Answer: B) Constants

Explanation:

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

Discuss this Question

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

  1. In-built
  2. User-defined
  3. Both a and b
  4. None of the above

Answer: B) User-defined

Explanation:

PL/SQL Constant is a User-defined literal value.

Discuss this Question

19. Choose the correct syntax to declare a constant.

  1. constant_name CONSTANT datatype := VALUE;
  2. datatype CONSTANT constant_name := VALUE;
  3. constant_name CONST datatype =: VALUE;
  4. datatype CONSTANT constant_name =: VALUE;

Answer: A) constant_name CONSTANT datatype := VALUE;

Explanation:

The correct syntax to declare a constant is –

constant_name CONSTANT datatype := VALUE;

Discuss this Question

20. 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

Answer: C) Both A. and B.

Explanation:

In case of 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.

Discuss this Question

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

  1. Initialization
  2. Declaration
  3. Valuation
  4. Numeralization

Answer: B) Declaration

Explanation:

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

Discuss this Question

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

  1. Constants
  2. Literals
  3. Cursor
  4. Variables

Answer: B) Literals

Explanation:

Literals are values which do not have an identifier and are numeric, character, string, or Boolean.

Discuss this Question

23. 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

Answer: C) Both A. and B.

Explanation:

NULL, TRUE, etc. Are the examples of the literal of type Boolean.

Discuss this Question

24. 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

Answer: A) PL/SQL literals are case-sensitive

Explanation:

PL/SQL literals are case-sensitive.

Discuss this Question

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

  1. Numeric
  2. String
  3. Boolean
  4. Check

Answer: D) Check

Explanation:

Type of PL/SQL literals are Numeric, Character, String, Boolean and Date & Time.

Discuss this Question

26. Which of the following is Numeric literal?

  1. 1234
  2. 22
  3. 0
  4. All of the above

Answer: D) All of the above

Explanation:

Examples of Numeric literals are 1234, 12.22, 0 etc.

Discuss this Question

27. Which of the following is NOT a Boolean literal?

  1. TRUE
  2. FALSE
  3. HELLO
  4. NULL

Answer: C) HELLO

Explanation:

HELLO is NOT a Boolean literal. TRUE, FALSE, NULL etc. are Boolean literals.

Discuss this Question

28. Which of the following is a Character literal?

  1. B
  2. 4
  3. %
  4. All of the above

Answer: D) All of the above

Explanation:

B, 4, % etc. are all Character literals.

Discuss this Question

29. 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

Answer: C) Both A. and B.

Explanation:

Programming languages features that are used in PL/SQL are iterative and conditional statements.

Discuss this Question

30. 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

Answer: D) All of the above

Explanation:

Explanation: Different Syntax of If statements are –

  1. IF-THEN statement
  2. IF-THEN-ELSE statement
  3. IF-THEN-ELSIF statement
  4. IF-THEN-ELSIF-ELSE statement

Discuss this Question

31. 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.

Answer: B) If the condition is TRUE, then you want statements to be executed

Explanation:

If the condition is TRUE, then you want statements to be executed

Discuss this Question

32. 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.

Answer: A) Depending on whether the condition is TRUE or FALSE, you may want to execute one set of statements or another set.

Explanation:

Depending on whether the condition is TRUE or FALSE, you may want to execute one set of statements or another set.

Discuss this Question

33. 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.

Answer: C) As long as condition1 is TRUE, then one set of statements will be executed, and when condition2 is TRUE, another set will be executed.

Explanation:

As long as condition1 is TRUE, then one set of statements will be executed, and when condition2 is TRUE, another set will be executed.

Discuss this Question

34. ____ 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

Answer: B) IF-THEN-ELSE statement

Explanation:

IF-THEN-ELSE executes the corresponding code whenever a TRUE condition is found. Otherwise, the condition cannot be checked again.

Discuss this Question

35. 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

Answer: A) IF-THEN-ELSE statement

Explanation:

In the absence of a condition, the ELSE part of the IF-THEN-ELSE statement will be executed.

Discuss this Question

36. Which portion is optional in IF statements?

  1. IF
  2. THEN
  3. ELSE
  4. None of the above

Answer: C) ELSE

Explanation:

ELSE and ELSIF portions are optional in IF statements.

Discuss this Question

3) PL/SQL CASE, LOOP, CONTINUE, GOTO MCQs

37. CASE statement uses which keyword to work like IF statement?

  1. INTO
  2. AS
  3. WHEN
  4. IN

Answer: C) WHEN

Explanation:

CASE statement uses WHEN keyword to work like IF statement.

Discuss this Question

38. What are the selectors in case of CASE statement?

  1. Variable
  2. Function
  3. Expression
  4. All of the above

Answer: D) All of the above

Explanation:

The selectors in case of CASE statement are Variable, Function or Expression.

Discuss this Question

39. Evaluation of CASE statement is done –

  1. RIGHT to LEFT
  2. TOP to BOTTOM
  3. BOTTOM to TOP
  4. None of the above

Answer: B) TOP to BOTTOM

Explanation:

Evaluation of CASE statement is done TOP to BOTTOM.

Discuss this Question

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

  1. Loops
  2. Cursor
  3. Variables
  4. Case

Answer: A) Loops

Explanation:

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

Discuss this Question

41. PL/SQL Loops are also known as –

  1. Iterative Case Statements
  2. Iterative Control Statements
  3. Indentation Control Statements
  4. Indentation Case Statements

Answer: B) Iterative Control Statements

Explanation:

PL/SQL Loops are also known as Iterative Control Statements.

Discuss this Question

42. What is the syntax of PL/SQL Loop?

  1. LOOP
END LOOP;
Sequence of statements;
  2. END LOOP;
LOOP
Sequence of statements;
  3. LOOP
Sequence of statements;
END LOOP;
  4. END LOOP;
Sequence of statements;
LOOP

Answer: C) 

LOOP
Sequence of statements;
END LOOP;

Explanation:

Syntax of PL/SQL Loop is –

LOOP
Sequence of statements;
END LOOP;

Discuss this Question

43. How many types of PL/SQL Loops are there?

  1. 3
  2. 4
  3. 5
  4. 6

Answer: B) 4

Explanation:

There are 4 types of PL/SQL loops.

Discuss this Question

44. Which of the following is correct type of PL/SQL Loop?

  1. While
  2. For
  3. Cursor For
  4. All of the above

Answer: D) All of the above

Explanation:

Types of PL/SQL Loops are –

  1. Basic Loop / Exit Loop
  2. While Loop
  3. For Loop
  4. Cursor For Loop

Discuss this Question

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

  1. While
  2. For
  3. Cursor For
  4. Exit

Answer: D) Exit

Explanation:

An exit loop in PL/SQL ensures that at least one statement is executed before the loop terminates.

Discuss this Question

46. Which of the following is TRUE while using PL/SQL Exit Loop?

  1. The loop body should be initialized with a variable
  2. Variables in the loop are incremented.
  3. When you are ready to exit the loop, you should use the EXIT WHEN statement.
  4. All of the above

Answer: D) All of the above

Explanation:

While using PL/SQL Exit Loop –

  1. The loop body should be initialized with a variable
  2. Variables in the loop are incremented.
  3. When you are ready to exit the loop, you should use the EXIT WHEN statement.

Discuss this Question

47. 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.

  1. While
  2. Cursor For
  3. Basic
  4. For

Answer: A) While

Explanation:

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

Discuss this Question

48. What is the correct syntax of WHILE Loop?

  1. WHILE <condition>   
LOOP statements;   
END LOOP;
  2. LOOP statements;   
WHILE <condition>    
END LOOP;
  3. END LOOP;
WHILE <condition>   
LOOP statements;
  4. None of the above

Answer: A) 

WHILE <condition>   
LOOP statements;   
END LOOP;

Explanation:

The correct syntax of WHILE Loop is –

WHILE <condition>
LOOP statements;   
END LOOP;

Discuss this Question

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

  1. Cursor For
  2. Cursor
  3. For
  4. While

Answer: C) For

Explanation:

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

Discuss this Question

50. The counter in PL/SQL FOR Loop is by default incremented by –

  1. 0
  2. 1
  3. 2
  4. NULL

Answer: B) 1

Explanation:

The counter in PL/SQL FOR Loop is by default incremented by 1.

Discuss this Question

51. Which of the following is TRUE while using PL/SQL FOR Loop?

  1. The counter variable is implicitly declared in the declaration section, so you do not need to declare it explicitly.
  2. It is not necessary to explicitly increment the counter variable since it is incremented by 1.
  3. FOR loops can use EXIT WHEN and EXIT statements, but it isn't often used.
  4. All of the above

Answer: D) All of the above

Explanation:

While using PL/SQL FOR Loop –

  1. The counter variable is implicitly declared in the declaration section, so you do not need to declare it explicitly.
  2. It is not necessary to explicitly increment the counter variable since it is incremented by 1.
  3. FOR loops can use EXIT WHEN and EXIT statements, but it isn't often used.

Discuss this Question

52. 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.

  1. Condition
  2. Cursor
  3. Continue
  4. Check

Answer: C) Continue

Explanation:

PL/SQL Continue 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.

Discuss this Question

53. In which Oracle does the PL/SQL Continue Statement is supported?

  1. Oracle 8g
  2. Oracle 9g
  3. Oracle 10g
  4. Oracle 11g

Answer: D) Oracle 11g

Explanation:

Oracle 11g supports PL/SQL Continue statement.

Discuss this Question

54. 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.

  1. JUMP
  2. GOTO
  3. CONTINUE
  4. BLINK

Answer: B) GOTO

Explanation:

A GOTO 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.

Discuss this Question

55. The symbol in which the label_name is encapsulated in PL/SQL GOTO statement is –

  1. ( )
  2. { }
  3. [ ]
  4. <<>> 

Answer: D) <<>> 

Explanation:

The symbol in which the label_name is encapsulated in PL/SQL GOTO statement is << >>.

Discuss this Question

56. What is/are the correct restriction(s) on GOTO statement?

  1. A LOOP statement or sub-block cannot be used as an IF statement, CASE statement, or LOOP statement.
  2. A CASE statement WHEN clause or an IF statement clause cannot transfer control to another.
  3. No control can be transferred between outer blocks and sub-blocks.
  4. All of the above

Answer: D) All of the above

Explanation:

The restrictions on the GOTO statement are –

  1. A LOOP statement or sub-block cannot be used as an IF statement, CASE statement, or LOOP statement.
  2. A CASE statement WHEN clause or an IF statement clause cannot transfer control to another.
  3. No control can be transferred between outer blocks and sub-blocks.
  4. A subprogram cannot be controlled by a parent program.
  5. An exception handler cannot take control.

Discuss this Question

4) PL/SQL Procedure MCQs

57. PL/SQL Procedure consists of –

  1. Header and Footer
  2. Body and Footer
  3. Header and Body
  4. None of the above

Answer: C) Header and Body

Explanation:

PL/SQL Procedure consists of Header and Body.

Discuss this Question

58. What is TRUE about header?

  1. Parameters and variables are contained in the header of the procedure.
  2. Similar to a general PL/SQL block, the header contains declarations, executions, and exceptions.
  3. Both A. and B.
  4. None of the above

Answer: A) Parameters and variables are contained in the header of the procedure

Explanation:

Parameters and variables are contained in the header of the procedure.

Discuss this Question

59. How much number of ways is there to pass the parameters in procedure?

  1. 1
  2. 2
  3. 3
  4. 4

Answer: C) 3

Explanation:

There are 3 numbers of ways to pass the parameters in the procedure.

Discuss this Question

60. Which of the following are the pass parameters in procedure?

  1. IN
  2. OUT
  3. INOUT
  4. All of the above

Answer: D) All of the above

Explanation:

The pass parameters in procedure are –

  1. IN
  2. OUT
  3. INOUT

Discuss this Question

61. Which of the following pass parameters can be referenced by procedure?

  1. IN, OUT
  2. OUT, INOUT
  3. IN, INOUT
  4. None of the above

Answer: C) IN, INOUT

Explanation:

IN and INOUT pass parameters can be reference by procedure.

Discuss this Question

62. Which of the following cannot be overwritten by procedure?

  1. IN
  2. OUT
  3. INOUT
  4. None of the above

Answer: A) IN

Explanation:

IN pass parameter cannot be overwritten by procedure.

Discuss this Question

63. Which of the following can be performed in PL/SQL Procedure?

  1. Create
  2. Call
  3. Drop
  4. All of the above

Answer: D) All of the above

Explanation:

In PL/SQL Procedure, the following functions can be performed –

  1. Create
  2. Call
  3. Drop

Discuss this Question

5) PL/SQL Function MCQs

64. What is the difference between PL/SQL Function and PL/SQL Procedure?

  1. PL/SQL function may or may not return the value whereas PL/SQL Procedure must have to return the value.
  2. PL/SQL Procedure may or may not return the value whereas PL/SQL Function must have to return the value.
  3. PL/SQL Function may or may not return the function whereas PL/SQL Procedure must have to return the function.
  4. None of the above

Answer: B) PL/SQL Procedure may or may not return the value whereas PL/SQL Function must have to return the value

Explanation:

PL/SQL Procedure may or may not return the value whereas PL/SQL Function must have to return the value.

Discuss this Question

65. Which of the following is NOT present in the syntax of PL/SQL function?

  1. Function_name
  2. [OR REPLACE]
  3. Optional Parameter List
  4. None of the above

Answer: D) None of the above

Explanation:

Function_name, [OR REPLACE], Optional Parameter List, IN are all present in the syntax of PL/SQL function.

Discuss this Question

66. PL/SQL function must contain a –

  1. Follow Statement
  2. GOTO Statement
  3. Return Statement
  4. NULL Statement

Answer: C) Return Statement

Explanation:

PL/SQL function must contain a Return Statement.

Discuss this Question

67. AS Keyword is used in the PL/SQL function in order to create a –

  1. Identity Function
  2. Quadratic Function
  3. One to One Function
  4. Standalone Function

Answer: D) Standalone Function

Explanation:

AS keyword is used in the PL/SQL function in order to create a Standalone Function.

Discuss this Question

68. We can demonstrate which of the following in a PL/SQL function?

  1. Declare
  2. Define
  3. Invoke
  4. All of the above

Answer: D) All of the above

Explanation:

We can demonstrate Declare, Define and Invoke in PL/SQL function.

Discuss this Question

69. Which of the following is /are TRUE about calling a PL/SQL function?

  1. You need to define a function's purpose when creating it.
  2. In order to utilize a function, you must call it in order to accomplish the defined task.
  3. Calling a function passes the program control to that function.
  4. All of the above

Answer: D) All of the above

Explanation:

All the below points are TRUE about calling a PL/SQL function –

  1. You need to define a function's purpose when creating it.
  2. In order to utilize a function, you must call it in order to accomplish the defined task.
  3. Calling a function passes the program control to that function.

Discuss this Question

70. The call function returns program control to the ____ after successful completion of the defined task.

  1. Main Table
  2. Main Database
  3. Main Program
  4. Main Row

Answer: C) Main Program

Explanation:

The call function returns program control to the main program after successful completion of the defined task.

Discuss this Question

71. Calling a function requires that the parameters be provided along with the ____, and if the function returns a value, that value can be stored.

  1. Function Name
  2. Optional Parameter List
  3. IF Statement
  4. Rollback Statement

Answer: A) Function Name

Explanation:

Calling a function requires that the parameters be provided along with the function name, and if the function returns a value, that value can be stored.

Discuss this Question

72. It is called ____ when the subprogram calls itself and ____ is the process.

  1. Recursion, Recursive Call
  2. Recursive Call, Recursion
  3. Recursive Name, Recursive Call
  4. Recursive Call, Recursive Name

Answer: B) Recursive Call, Recursion

Explanation:

It is called recursive call when the subprogram calls itself and recursion is the process.

Discuss this Question

73. In order to remove the PL/SQL function, which function is used?

  1. REMOVE FUNCTION
  2. DELETE FUNCTION
  3. ERASE FUNCTION
  4. DROP FUNCTION

Answer: D) DROP FUNCTION

Explanation:

In order to remove the PL/SQL function, DROP FUNCTION is used.

Discuss this Question

6) PL/SQL Cursor MCQs

74. Oracle creates ____ when SQL statements are processed.

  1. Content Areas
  2. Context Areas
  3. Context Ids
  4. Content Ids

Answer: B) Context Areas

Explanation:

Oracle creates context areas when SQL statements are processed.

Discuss this Question

75. In the contexts created by Oracle, a cursor represents a ____.

  1. Function
  2. Table
  3. Pointer
  4. None of the above

Answer: C) Pointer

Explanation:

In the contexts, create by Oracle, a cursor represents a Pointer.

Discuss this Question

76. An SQL ____ refers to a program that retrieves and processes one row at a time, based on the results of the SQL statement.

  1. Cursor
  2. Function
  3. Procedure
  4. View

Answer: A) Cursor

Explanation:

An SQL cursor refers to a program that retrieves and processes one row at a time, based on the results of the SQL statement.

Discuss this Question

77. How many types of PL/SQL Cursor are there?

  1. 1
  2. 2
  3. 3
  4. 4

Answer: B) 2

Explanation:

There are 2 types of PL/SQL Cursors.

Discuss this Question

78. Which of the following is/are the type(s) of the PL/SQL Cursor?

  1. Implicit
  2. Explicit
  3. Both A. and B.
  4. None of the above

Answer: C) Both A. and B.

Explanation:

Implicit and Explicit Cursors are the types of PL/SQL Cursor.

Discuss this Question

79. Which of the following PL/SQL Cursor is automatically generated by Oracle?

  1. Implicit
  2. Explicit
  3. Both a and b
  4. None of the above

Answer: A) Implicit

Explanation:

Implicit Cursor is automatically generated by Oracle.

Discuss this Question

80. The Implicit cursors are created in order to process the ____ statements.

  1. DDL
  2. DCL
  3. DML
  4. TCL

Answer: C) DML

Explanation:

The implicit cursors are created in order to process the DML statements such as INSERT, DELETE, UPDATE, etc.

Discuss this Question

81. Which of the following is/are an/the implicit cursor's attribute(s)?

  1. %FOUND
  2. %ROWCOUNT
  3. %ISOPEN
  4. All of the above

Answer: D) All of the above

Explanation:

%FOUND, %ROWCOUNT, %OPEN and %NOTFOUND are all the implicit cursor's attributes.

Discuss this Question

82. What is TRUE about %FOUND in PL/SQL Cursor?

  1. If any DML statement, such as INSERT, DELETE or UPDATE, effects one or more rows, or if a SELECT INTO statement returns at least one row, this method returns TRUE.
  2. A SELECT INTO statement or DML statements like INSERT, DELETE, AND UPDATE do not result in any rows being affected.
  3. Because SQL cursors are automatically closed after execution of their associated SQL statements, the function always returns FALSE for implicit cursors.
  4. Results are returned for DML statements such as inserting, deleting, and updating records, or for those returned by a SELECT INTO command.

Answer: A) If any DML statement, such as INSERT, DELETE or UPDATE, effects one or more rows, or if a SELECT INTO statement returns at least one row, this method returns TRUE

Explanation:

In the case of %FOUND, if any DML statement, such as INSERT, DELETE or UPDATE, effects one or more rows, or if a SELECT INTO statement returns at least one row, this method returns TRUE.

Discuss this Question

83. What is TRUE about %ISOPEN in PL/SQL Cursor?

  1. If any DML statement, such as INSERT, DELETE or UPDATE, effects one or more rows, or if a SELECT INTO statement returns at least one row, this method returns TRUE.
  2. A SELECT INTO statement or DML statements like INSERT, DELETE, AND UPDATE do not result in any rows being affected.
  3. Because SQL cursors are automatically closed after execution of their associated SQL statements, the function always returns FALSE for implicit cursors.
  4. Results are returned for DML statements such as inserting, deleting, and updating records, or for those returned by a SELECT INTO command.

Answer: C) Because SQL cursors are automatically closed after execution of their associated SQL statements, the function always returns FALSE for implicit cursors

Explanation:

In the case of %ISOPEN, Because SQL cursors are automatically closed after execution of their associated SQL statements, the function always returns FALSE for implicit cursors.

Discuss this Question

84. What is TRUE about %ROWCOUNT in PL/SQL Cursor?

  1. A SELECT INTO statement or DML statements like INSERT, DELETE, AND UPDATE do not result in any rows being affected.
  2. Results are returned for DML statements such as inserting, deleting, and updating records, or for those returned by a SELECT INTO command.
  3. Both A. and B.
  4. None of the above

Answer: B) Results are returned for DML statements such as inserting, deleting, and updating records, or for those returned by a SELECT INTO command

Explanation:

Results are returned for DML statements such as inserting, deleting, and updating records, or for those returned by a SELECT INTO command.

Discuss this Question

85. For ____ control over the context area, programmers can define explicit cursors.

  1. Greater
  2. Lesser
  3. Equal
  4. None of the above

Answer: A) Greater

Explanation:

For greater control over the context area, programmers can define explicit cursors.

Discuss this Question

86. In the PL/SQL Block, Explicit cursors are defined in ___________ section.

  1. Initialization
  2. Declaration
  3. End
  4. None of the above

Answer: B) Declaration

Explanation:

In the PL/SQL Block, Explicit cursors are defined in Declaration Section.

Discuss this Question

87. On the ____ statements, the explicit cursors are created which return rows more than one.

  1. DELETE
  2. CREATE
  3. SELECT
  4. UPDATE

Answer: C) SELECT

Explanation:

On the SELECT statements, the explicit cursors are created which return rows more than one.

Discuss this Question

88. Which of the following is the correct syntax to create the Explicit Cursor?

  1. IS select_statement cursor_name CURSOR;
  2. CURSOR select_statement IS cursor_name;
  3. CURSOR cursor_name select_statement IS;
  4. CURSOR cursor_name IS select_statement;

Answer: D) CURSOR cursor_name IS select_statement;

Explanation:

CURSOR cursor_name IS select_statement; is the correct syntax to create the Explicit Cursor.

Discuss this Question

89. There are 4 steps to work on Explicit Cursor:

  1. Declare the cursor to be initialized in memory.
  2. Allocate memory by opening the cursor.
  3. Retrieve data by fetching the cursor.
  4. Release allocated memory by closing the cursor.

Select the correct order of the above 4 steps to work on Explicit Cursor.

  1. II > III > IV > I
  2. I > II > IV > III
  3. I > II > III > IV
  4. IV > III > II > I

Answer: C) I > II > III > IV

Explanation:

This is the order in which 4 steps will be performed to work on Explicit Cursor:

  1. Declare the cursor to be initialized in memory.
  2. Allocate memory by opening the cursor.
  3. Retrieve data by fetching the cursor.
  4. Release allocated memory by closing the cursor.

Discuss this Question

90. Which of the following is the correct syntax to declare explicit cursor?

  1. CURSOR IS name
SELECT statement;
  2. CURSOR name is
Statement SELECT;
  3. Name IS CURSOR
SELECT statement;
  4. CURSOR name IS
SELECT statement;

Answer: D) 

CURSOR name IS
SELECT statement;

Explanation:

The correct syntax to declare explicit cursor is –

CURSOR name IS
SELECT statement;

Discuss this Question

91. Which of the following is the correct syntax to fetch the cursor?

  1. FETCH cursor_name INTO variable_list;
  2. FETCH variable_list INTO cursor_name;
  3. INTO cursor_name FETCH variable_list;
  4. INTO variable_list FETCH cursor_name;

Answer: A) FETCH cursor_name INTO variable_list;

Explanation:

FETCH cursor_name INTO variable_list is the correct syntax to fetch the cursor.

Discuss this Question

92. Which clause is used to open the cursor?

  1. BEGIN
  2. START
  3. OPEN
  4. INITIATE

Answer: C) OPEN

Explanation:

OPEN is the clause used to open the cursor.

Discuss this Question

93. Which clause is used to close the cursor?

  1. END
  2. STOP
  3. FINISH
  4. CLOSE

Answer: D) CLOSE

Explanation:

CLOSE clause is used to close the cursor.

Discuss this Question

7) PL/SQL Triggers MCQs

94. Whenever a specified event occurs, the ____ is automatically triggered by the Oracle engine.

  1. Cursor
  2. Trigger
  3. Exception
  4. View

Answer: B) Trigger

Explanation:

Whenever a specified event occurs, the trigger is automatically triggered by the Oracle engine.

Discuss this Question

95. Which of the following is TRUE about PL/SQL Trigger?

  1. When certain conditions are met, a trigger stored in a database is triggered.
  2. A trigger is an application that executes or fires automatically when a certain event occurs.
  3. Both A. and B.
  4. None of the above

Answer: C) Both A. and B.

Explanation:

The following points are TRUE about PL/SQL Trigger –

  1. When certain conditions are met, a trigger stored in a database is triggered.
  2. A trigger is an application that executes or fires automatically when a certain event occurs.

Discuss this Question

96. In which event(s) trigger is executed?

  1. DDL
  2. DML
  3. Database Operation
  4. All of the above

Answer: D) All of the above

Explanation:

Trigger is executed when -

  1. DDL occurs
  2. DML occurs
  3. Database Operation occurs

Discuss this Question

97. Which of the following is database operation?

  1. SERVERERROR
  2. STARTUP
  3. SHUTDOWN
  4. All of the above

Answer: D) All of the above

Explanation:

SERVERERROR, STARTUP, SHUTDOWN, LOGON and LOGOFF are all the database operations.

Discuss this Question

98. Which of the following is not an advantage of trigger?

  1. Various column values are automatically generated by triggers
  2. Maintains the integrity of referential
  3. Tables are replicated asynchronously
  4. Validating transactions and preventing them from being invalid

Answer: C) Tables are replicated asynchronously

Explanation:

Trigger has this advantage of the tables to be replicated synchronously and not asynchronously.

Discuss this Question

99. What does INSERT or UPDATE or DELETE clauses do in Trigger syntax?

  1. DML Operation is performed
  2. DDL Operation is performed
  3. DCL Operation is performed
  4. TCL Operation is performed

Answer: A) DML Operation is performed

Explanation:

INSERT or UPDATE or DELETE clauses performs the DML Operations in Trigger syntax.

Discuss this Question

100. Which clause(s) is/are used to specify when the trigger will get executed?

  1. BEFORE
  2. AFTER
  3. INSTEAD OF
  4. All of the above

Answer: D) All of the above

Explanation:

BEFORE or AFTER or INSTEAD OF clauses are used to specify when the trigger will get executed.

Discuss this Question

101. Which clause is used to create trigger on a view?

  1. BEFORE
  2. AFTER
  3. INSTEAD OF
  4. None of the above

Answer: C) INSTEAD OF

Explanation:

INSTEAD OF clause is used to create trigger on a view.

Discuss this Question

102. What is the difference between OF column_name and ON table_name in trigger syntax?

  1. OF column_name specifies the column name that is needed to be updated whereas ON table_name specified the table name that is associated with the trigger.
  2. ON table_name specifies the column name that is needed to be updated whereas OF column_name specified the table name that is associated with the trigger.
  3. OF table_name specifies the column name that is needed to be updated whereas ON column_name specified the table name that is associated with the trigger.
  4. ON column_name specifies the column name that is needed to be updated whereas OF table_name specified the table name that is associated with the trigger.

Answer: A) OF column_name specifies the column name that is needed to be updated whereas ON table_name specified the table name that is associated with the trigger.

Explanation:

OF column_name specifies the column name that is needed to be updated whereas ON table_name specified the table name that is associated with the trigger.

Discuss this Question

103. What does FOR EACH ROW clause do in Trigger syntax?

  1. A row-level trigger is specified, meaning that each row is affected by this trigger
  2. When the SQL statement is run, the trigger will be executed just once, which is what is called a table-level trigger
  3. Both A. and B.
  4. None of the above

Answer: C) Both A. and B.

Explanation:

In the case of FOR EACH ROW –

  1. A row-level trigger is specified, meaning that each row is affected by this trigger
  2. When the SQL statement is run, the trigger will be executed just once, which is what is called a table-level trigger

Discuss this Question

104. WHEN condition is valid for which triggers?

  1. Table Level Triggers
  2. Row Level Triggers
  3. Column Level Triggers
  4. Database Level Triggers

Answer: B) Row Level Triggers

Explanation:

WHEN condition is valid for Row Level Triggers.

Discuss this Question

105. Which of the following statement is TRUE?

  1. Table-level triggers do not have access to OLD and NEW references. Record-level triggers use OLD and NEW references.
  2. Record-level triggers do not have access to OLD and NEW references. Table-level triggers use OLD and NEW references.
  3. Table-level triggers have access to OLD and NEW references.
  4. Record-level triggers do not use OLD and NEW references.

Answer: A) Table-level triggers do not have access to OLD and NEW references. Record-level triggers use OLD and NEW references.

Explanation:

Table-level triggers do not have access to OLD and NEW references. Record-level triggers use OLD and NEW references.

Discuss this Question

106. Which keyword is used to query the table in the same trigger?

  1. BEFORE
  2. AFTER
  3. SAME
  4. EXACT

Answer: B) AFTER

Explanation:

AFTER keyword is used to query the table in the same trigger.

Discuss this Question

107. What does REFERENCING OLD AS o NEW AS n clause do in trigger?

  1. This clause is used to refer the old values for different DML statements.
  2. This clause is used to refer the new values for different DML statements.
  3. Both A. and B.
  4. None of the above

Answer: C) Both A. and B.

Explanation:

REFERENCING OLD AS o NEW AS n clause is used to refer the old and new values for different DML statements.

Discuss this Question

108. Which of the following is an advantage of trigger?

  1. Imposing authorizations for security
  2. Keeping track of table access events and logging them
  3. Auditing
  4. All of the above

Answer: D) All of the above

Explanation:

The advantages of trigger are –

  1. Imposing authorizations for security
  2. Keeping track of table access events and logging them
  3. Auditing

Discuss this Question

109. Which of the following clause is not present in the syntax of trigger?

  1. DECLARE
  2. TRIGGER
  3. CURSOR
  4. INSTEAD OF

Answer: C) CURSOR

Explanation:

CURSOR clause is not present in the syntax of trigger.

Discuss this Question

110. Tables, views, schemas, or databases can be defined as ________ for events.

  1. Procedure
  2. Views
  3. Triggers
  4. Cursors

Answer: C) Triggers

Explanation:

Tables, views, schemas, or databases can be defined as triggers for events.

Discuss this Question

8) PL/SQL Exception MCQs

111. Errors that are encountered during the execution of the program are referred to as ____ in PL/SQL.

  1. FUNCTION
  2. CURSOR
  3. EXCEPTION
  4. PROCEDURE

Answer: C) EXCEPTION

Explanation:

Errors that are encountered during the execution of the program are referred to as exceptions in PL/SQL.

Discuss this Question

112. How many types of exceptions are there?

  1. 2
  2. 3
  3. 4
  4. 5

Answer: A) 2

Explanation:

There are 2 types of exceptions.

Discuss this Question

113. Which of the following is/are an/the type(s) of exceptions?

  1. System-defined
  2. User-defined
  3. Both A. and B.
  4. None of the above

Answer: C) Both A. and B.

Explanation:

System-defined and User-defined exceptions are both the types of exceptions.

Discuss this Question

114. Which command is used in order to raise an exception explicitly?

  1. RISE
  2. ROSE
  3. RAISE
  4. RINSE

Answer: C) RAISE

Explanation:

With the help of RAISE command, one can easily raise an exception explicitly.

Discuss this Question

115. Which of the following is TRUE about User-defined exceptions?

  1. Users can explicitly raise an exception by using a RAISE statement
  2. RAISE_APPLICATION_ERROR can be used to raise a user-defined exception explicitly.
  3. Both A. and B.
  4. None of the above

Answer: C) Both A. and B.

Explanation:

Users can explicitly raise an exception by using a RAISE statement or DBMS_STANDARD.RAISE_APPLICATION_ERROR can be used to raise a user-defined exception explicitly.

Discuss this Question

116. What is the syntax of User-defined exceptions?

  1. DECLARE my-exception EXCEPTION;
  2. DECLARE EXCEPTION;
  3. DECLARE my-exception;
  4. EXCEPTION;

Answer: A) DECLARE my-exception EXCEPTION;

Explanation:

DECLARE my-exception EXCEPTION is the syntax of user-defined exceptions.

Discuss this Question

117. Which of the following clause does not comes in the syntax while raising an exception?

  1. DECLARE
  2. WHEN
  3. CLOSE
  4. END

Answer: C) CLOSE

Explanation:

CLOSE clause doesn't come in the syntax while raising an exception.

Discuss this Question

118. When SELECT INTO returns no rows, which pre-defined exception is raised?

  1. ACCESS_INTO_NULL
  2. NO_DATA_FOUND
  3. NOT_LOGGED_ON
  4. VALUE_ERROR

Answer: B) NO_DATA_FOUND

Explanation:

When SELECT INTO returns no rows, NO_DATA_FOUND pre-defined exception is raised.

Discuss this Question

119. When ACCESS_INTO_NULL exception does is raised?

  1. A unique index column with duplicate values is raised when this error occurs.
  2. An invalid username or password is used by a program to connect to a database.
  3. An automatic assignment of a value to a NULL object raises this exception.
  4. It is raised when more than one row is returned by a SELECT INTO statement.

Answer: C) An automatic assignment of a value to a NULL object raises this exception.

Explanation:

ACCESS_INTO_NULL exception is raised when an automatic assignment of a value to a NULL object raises this exception.

Discuss this Question

120. Which exception is rose when there is no other clause in the "WHEN" clause of a CASE statement, and none of the choices in the "WHEN" clause have been selected?

  1. INVALID_CURSOR
  2. DUP_VAL_ON_INDEX
  3. VALUE_ERROR
  4. CASE_NOT_FOUND

Answer: D) CASE_NOT_FOUND

Explanation:

CASE_NOT_FOUND exception is rose when there is no other clause in the "WHEN" clause of a CASE statement, and none of the choices in the "WHEN" clause have been selected.

Discuss this Question

121. When COLLECTION_IS_NULL exception is raised?

  1. A unique index column with duplicate values is raised when this error occurs.
  2. The exception is thrown when an uninitialized nested table or varray is attempted to be populated with collection methods other than exist, or when an element of an uninitialized nested table or varray is attempted to be assigned values.
  3. If a select into statement fails to return any rows, it raises this error.
  4. This error message appears when a number is divided by zero.

Answer: B) The exception is thrown when an uninitialized nested table or varray is attempted to be populated with collection methods other than exist, or when an element of an uninitialized nested table or varray is attempted to be assigned values.

Explanation:

COLLECTION_IS_NULL exception is raised when an uninitialized nested table or varray is attempted to be populated with collection methods other than exist, or when an element of an uninitialized nested table or varray is attempted to be assigned values.

Discuss this Question

122. When DUP_VAL_ON_INDEX exception does is raised?

  1. A unique index column with duplicate values is raised when this error occurs.
  2. The error is raised if an attempt is made to close an unopened cursor or perform a cursor operation without permission.
  3. When character strings are converted to numbers, it is raised if the string did not represent a valid number.
  4. An invalid username or password is used to log on to the database by a program.

Answer: A) A unique index column with duplicate values is raised when this error occurs.

Explanation:

DUP_VAL_ON_INDEX exception is raised when an attempt is made to close an unopened cursor or perform a cursor operation without permission.

Discuss this Question

123. An exception which occurs when attempting to access a database without connecting to it is –

  1. PROGRAM_ERROR
  2. NOT_LOGGED_IN
  3. NOT_LOGGED_ON
  4. NULL_LOGGED-ON

Answer: C) NOT_LOGGED_ON

Explanation:

An exception which occurs when attempting to access a database without connecting to it is NOT_LOGGED_ON.

Discuss this Question

124. Which exception is raised when there is an internal problem in PL/SQL?

  1. VALUE_ERROR
  2. INTERNAL_ERROR
  3. PROBLEM_ERROR
  4. PROGRAM_ERROR

Answer: D) PROGRAM_ERROR

Explanation:

PROGRAM_ERROR is raised when there is an internal problem in PL/SQL.

Discuss this Question

125. When ROWTYPE_MISMATCH exception is raised?

  1. When a member method is invoked on an object type, but its instance has not been initialized, this exception is raised.
  2. Error in PL/SQL occurs when memory is exhausted or corrupt.
  3. Cursors raise this exception when they seek values in variables of incompatible types.
  4. None of the above

Answer: C) Cursors raise this exception when they seek values in variables of incompatible types.

Explanation:

Cursors raise the exception ROWTYPE_MISMATCH when they seek values in variables of incompatible types.

Discuss this Question

126. When SELF_IS_NULL exception is raised?

  1. Errors are raised when dividing by zero is attempted.
  2. When a member method is invoked on an object type, but its instance has not been initialized, this exception is raised.
  3. Error in PL/SQL occurs when memory is exhausted or corrupt.
  4. It is raised when more than one row is returned by a SELECT INTO statement.

Answer: B) When a member method is invoked on an object type, but its instance has not been initialized, this exception is raised.

Explanation:

SELF_IS_NULL exception is raised when a member method is invoked on an object type, but its instance has not been initialized, this exception is raised.

Discuss this Question

127. A PL/SQL exception, which occurs when a memory error occurs?

  1. ZERO-DIVIDE
  2. VALUE_ERROR
  3. MEMORY_ERROR
  4. STORAGE_ERROR

Answer: D) STORAGE_ERROR

Explanation:

A PL /SQL exception, which occurs when a memory error occurs, is STORAGE_ERROR.

Discuss this Question

128. The exception thrown when more than one row is returned from a SELECT INTO statement?

  1. MORE_THAN_ONE_ROW
  2. MORE_ROWS
  3. TOO_MANY_ROWS
  4. MANY_ROWS

Answer: C) TOO_MANY_ROWS

Explanation:

The exception thrown when more than one row is returned from a SELECT INTO statement is TOO_MANY_ROWS.

Discuss this Question

129. When VALUE_ERROR exception is raised?

  1. Errors relating to arithmetic, conversion, truncation, or size constraints raise this signal.
  2. This error message appears when a number is divided by zero.
  3. Both A. and B.
  4. None of the above

Answer: A) Errors relating to arithmetic, conversion, truncation, or size constraints raise this signal.

Explanation:

VALUE_ERROR exception is raised when errors relating to arithmetic, conversion, truncation, or size constraints occur.

Discuss this Question

130. When ZERO_DIVIDE exception is raised?

  1. This error message appears when a number is multiplied by zero.
  2. This error message appears when a number is divided by zero.
  3. This error message appears when a number is integrated by zero.
  4. This error message appears when a number is zero.

Answer: B) This error message appears when a number is divided by zero.

Explanation:

This error message appears when a number is divided by zero.

Discuss this Question



Comments and Discussions!

Load comments ↻



Top MCQs
Top Programs/Examples
Top Tutorials
About
Student's Section
Subscribe

Copyright © 2024 www.includehelp.com. All rights reserved.