Interview Questions Answers in SQL PLSQL, Oracle Forms Reports

shishu

{ City } hoshiarpur
< Country > india
* Profession * software engineer
User No # 4504

Total Questions Posted # 0
Total Answers Posted # 2

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 19
Users Marked my Answers as Wrong # 4

Questions / { shishu }

Questions Answers Category Views Company eMail

Answers / { shishu }

Question { TCS, 51621 }

What is the result, when NULL is compared with NULL?

Answer

In oracle the below eg will help you to clear this:

DECLARE
D INTEGER :=NULL;
E INTEGER :=NULL;
BEGIN
IF (D = E) THEN
dbms_output.put_line('PASS);
ELSE
dbms_output.put_line('FAIL');
END IF;
END;

It will alwayz return FAIL.

Is This Answer Correct ?

12 Yes

3 No

Question { 6731 }

how do u run sql loader

Answer

sql loader wil run through DOS prompt,please find below
syntax for the same:

sqlldr /@ control = XXX.ctl
DIRECT=FALSE

Is This Answer Correct ?

7 Yes

1 No