aliensbrain
  • Home
  • Study
  • Quizzes
  • 🎤AI Practicefree
  • Notebooks
  • Community
  • Sign in
  • DB2 Stored Procedures and Oracle Database Fundamentals
  • What will be the initial value of V_MAX in the declaratio...
Multiple choice technology databases

What will be the initial value of V_MAX in the declaration statement shown below? DECLARE v_max DECIMAL(9,2);

  1. 0.0

  2. 2

  3. 9

  4. Null

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In DB2 SQL PL, if a local variable is declared without an explicit default value using the DEFAULT clause, its initial value is automatically set to NULL.

Keep practicing — related questions

  • Suppose in the declaration section of a PL/SQL block, you create but do not initialize a NUMBER variable. W...
  • Suppose in the declaration section of a PL/SQL block, you create but do not initialize a NUMBER variable. W...
  • Suppose in the declaration section of a PL/SQL block, you create but do not initialize a NUMBER variable. W...
  • Declare a number := 5; b number := null; c number := 10; Begin if a > b AND a < c then a := c * a; end if; ...
  • Declare a number := 5; b number := null; c number := 10; Begin if a > b AND a < c then a := c * a; end if; ...
  • The ----- statement sets the value of operand(s) to null value or to initial value as defined in DEFINE DAT...
  • How to initialilze a variable irrespective of the data type
  • What will be the output of the following: void main() { float a=0.7; if(a<0.7) printf("c++"); else printf("...
Play the full quiz 🎤 Practise this topic out loud

Practice this topic

  • Database and SQL (3929 questions)
Advertisement
© Aliensbrain | all rights reserved
  • About
  • Contact
  • Terms and Condition
  • Privacy Policy