3i Infotech Placement: Sample Questions 591 - 593 of 1245
Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.
Question 591
Explanation
- A procedure which is not enclosed in a package is called Stand Alone Procedure.
- A standalone procedure is a procedure (a subprogram that performs a specific action) that is stored in the database.
- Ex- one written in a SQL ⚹ Forms application.
- Limitation: Not available for reference from other Oracle tools.
- Limitation: Are compiled at run time, which slows execution.
Question 592
Question MCQ▾
Declare
a number := 5;
b number := null;
c number := 10;
Begin
if
a >b AND a <c
then
a := c ⚹a;
end if;
End;
What will be the value of ‘a’ after execution?
Choices
Choice (4) | |
---|---|
a. | 5 |
b. | 50 |
c. | NULL |
d. | None of the above |
Answer
a.Explanation
NULL values cannot be compared like normal values, a comparison with null always returns false and hence the value of ‘a’ remains unmodified.
Question 593
Write in Short Short Answer▾
What is the output of the following program?
main()
{
int i =0;
while (+(+i--)! =0)
i=i ++;
printf (“%d”,i);
}
Explanation
In the program
int i = 0 |
|
while (+ (+ i-) ! = 0) |
|
printf ( “% d” , i) ; |
|