Page 85 of 95
b] VIK RAM
c] VIKRAM
d] NULL
Ans : C
66. 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 ?
a] 50
b] NULL
c] 5
d] None of the above
Ans : C
67. Does the Database trigger will fire when the table is TRUNCATED ?
a] Yes
b] No
Ans : B
68. SUBSTR(SQUARE ANS ALWAYS WORK HARD,14,6) will return
a] ALWAY
b} S ALWA
c] ALWAYS
Ans : C
69. REPLACE('JACK AND JUE','J','BL') will return
a] JACK AND BLUE
b] BLACK AND JACK
c] BLACK AND BLUE
d] None of the above
Ans : C
70.
TRANSLATE('333SQD234','0123456789ABCDPQRST','0123456789')
will
return
a] 333234
b] 333333
c] 234333
d] None of the above
Ans : A
71. EMPNO ENAME SAL
A822 RAMASWAMY 3500
A812 NARAYAN 5000
A973 UMESH 2850
A500 BALAJI 5750
Use these data for the following Questions
|
|