MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following is not true about PL/SQL constants and literals?
A
A constant holds a value that oncedeclared, does not change in the program.
B
The CONSTANT declaration cannot impose the NOT NULLconstraint.
C
A constant is declared using the CONSTANTkeyword.
D
A CONSTANT declaration requires aninitial value.
Explanation: 

Detailed explanation-1: -Which of the following is not true about PL/SQL constants and literals? A constant holds a value that once declared, does not change in the program. The CONSTANT declaration cannot impose the NOT NULL constraint. A constant is declared using the CONSTANT keyword.

Detailed explanation-2: -Which of the following is not true about the PL/SQL data structure VARRAY? Answer : The elements can of various data types.

Detailed explanation-3: -Which of the following is true about PL/SQL programs? PL/SQL programs can exist with or without any SQL statements.

There is 1 question to complete.