PL/SQL Variables MCQs

by karimhani25
95
16

pl/sql

questions

Title
PL/SQL is a – PL/SQL is a – Brick Structured Language Block Structured Language Banner Structured Language Build Structured Language discuss The answer is: B. Block Structured Language
What does PL/SQL stand for? What does PL/SQL stand for? PL/SQL stands for Procedural Language Extension of SQL PL/SQL stands for Primary Language Extension of SQL PL/SQL stands for Pattern Language Extension of SQL PL/SQL stands for Private Language Extension of SQL discuss The answer is: A. PL/SQL stands for Procedural Language Extension of SQL
What is TRUE about PL/SQL functionalities? What is TRUE about PL/SQL functionalities? Conditions and loops are fundamental elements of procedural languages like PL/SQL. Various types and variables can be declared, as can procedures and functions, as well as types and variables of those types. Arrays can be used with it as well as handling exceptions (runtime errors). All of the above discuss The answer is: D. All of the above
Oracle Database's ____ are inherited in PL/SQL Oracle Database's ____ are inherited in PL/SQL. Portability Robustness Security All of the above discuss The answer is: D. All of the above
PL/SQL text is made up of lexical units, which are groups of characters and can be classified as – PL/SQL text is made up of lexical units, which are groups of characters and can be classified as – Delimiters Identifiers Literals All of the above discuss The answer is: D. All of the above
A Variable in PL/SQL should not exceed – A Variable in PL/SQL should not exceed – 10 20 30 40 discuss The answer is: C. 30
Which of the following is/are TRUE about PL/SQL Variables? Which of the following is/are TRUE about PL/SQL Variables? Variables serve as a means for programmers to temporarily store data during code execution. PL/SQL programs benefit from its use. There is nothing special about it other than being the name of a storage area. All of the above discuss The answer is: D. All of the above
PL/SQL Variables are by default – PL/SQL Variables are by default – Case Sensitive Upper Case Sensitive Lower Case Sensitive Not Case Sensitive discuss The answer is: D. Not Case Sensitive
PL/SQL Variable needs to be declared in the – PL/SQL Variable needs to be declared in the – Variable Section Declaration Section Initialization Section None of the above discuss The answer is: B. Declaration Section
The correct syntax to declare PL/SQL variable is – The correct syntax to declare PL/SQL variable is – variable_name [CONSTANT] datatype [NOT NULL] [:= \| DEFAULT initial_value] datatype [CONSTANT] variable_name [NOT NULL] [:= \| DEFAULT initial_value] variable_name [CONSTANT] datatype [NULL] [:= \| DEFAULT initial_value] datatype [CONSTANT] variable_name [NULL] [:= \| DEFAULT initial_value] discuss The answer is: A. variable_name [CONSTANT] datatype [NOT NULL] [:= \| DEFAULT initial_value]
The term ____ refers to a declaration with a size, scale, or precision limit The term ____ refers to a declaration with a size, scale, or precision limit. Constant declaration Constrained declaration Constant decision Constrained decision discuss The answer is: B. Constrained declaration
Which of the following is TRUE about Constrained Declaration? Which of the following is TRUE about Constrained Declaration? An unconstrained declaration requires more memory than a constrained declaration. An unconstrained declaration requires less memory than a constrained declaration. An unconstrained declaration requires equal memory to a constrained declaration. None of the above discuss The answer is: A. An unconstrained declaration requires more memory than a constrained declaration.
What is/are the Naming Rules for the PL/SQL Variables? What is/are the Naming Rules for the PL/SQL Variables? An ASCII letter must be the first letter in the variable name. 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 ($). Optionally, the variable can be specified as NOT NULL. All of the above discuss The answer is: D. All of the above
In order to initialize a variable with the value other than NULL, it can be done using which method? In order to initialize a variable with the value other than NULL, it can be done using which method? The Assignment Operator The DEFAULT Keyword Both A. and B. None of the above discuss The answer is: C. Both A. and B.
What is the name of the two variable scopes in PL/SQL? What is the name of the two variable scopes in PL/SQL? Local & Grind Variable Letter & Grind Variable Local & Global Variable Letter & Global Variable discuss The answer is: C. Local & Global Variable
What is the difference between Local & Global Variables? What is the difference between Local & Global Variables? 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. 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. 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. 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 The answer is: 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.

total MCQs: 16

MCQs

16

Views

95

Best Answers

299

Points

5