What will be the output for the below Query Select 'High' from dual w

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

What will be the output for the below Query
Select 'High' from dual where null = null;

Question Posted / abhishek6555

12 Answers
30484 Views
Infosys, Satyam, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What will be the output for the below Query Select 'High' from dual where null = null;..

Answer / shijo

The Answer will always be null, since you never can equate a
NULL to another NULL. if the query was "Select 'High' from
dual where null IS null;" The answer would have been "High"

Is This Answer Correct ?

61 Yes

19 No

What will be the output for the below Query Select 'High' from dual where null = null;..

Answer / binita

No rows selected

Is This Answer Correct ?

23 Yes

4 No

What will be the output for the below Query Select 'High' from dual where null = null;..

Answer / abhishek6555

The answer will be no rows selected as null = null will be
false condition and the where condition will become false.

Is This Answer Correct ?

14 Yes

7 No

What will be the output for the below Query Select 'High' from dual where null = null;..

Answer / amedela chandra sekhar

The correct answer is

SQL> Select 'High' from dual where null = null;

no rows selected

Chandu
chandumba2005@gmai.com

Is This Answer Correct ?

9 Yes

5 No

What will be the output for the below Query Select 'High' from dual where null = null;..

Answer / kart

since the query is syntaxically correct
the output will be

no rows selected;

Is This Answer Correct ?

3 Yes

3 No

What will be the output for the below Query Select 'High' from dual where null = null;..

Answer / ashok

no rows selected

Is This Answer Correct ?

0 Yes

0 No

What will be the output for the below Query Select 'High' from dual where null = null;..

Answer / vijay repe

Query will give o/p as 'High' if condition u put as null is
null insteat of null = null.

It considers as false where condition same as 1=2;

Is This Answer Correct ?

0 Yes

0 No

What will be the output for the below Query Select 'High' from dual where null = null;..

Answer / sri

two nulls are not equal
so the answer is no rows selected.

Is This Answer Correct ?

0 Yes

0 No

What will be the output for the below Query Select 'High' from dual where null = null;..

Answer / prashant yadav

No row select

Is This Answer Correct ?

2 Yes

3 No

What will be the output for the below Query Select 'High' from dual where null = null;..

Answer / zia

Syntax is correct, but result will show only column heading without data as 'HIGH'.

Is This Answer Correct ?

2 Yes

3 No

Post New Answer

More SQL PLSQL Interview Questions

How to order siblings in oracle hierarchy queries?

0 Answers

Is not null in sql?

0 Answers

What is normalisation and its types?

0 Answers

define sql delete statement ? : Sql dba

0 Answers

Are views faster than queries?

0 Answers

What is bulk collect in pl sql?

0 Answers

How do you use collections in procedure to return the resultset?

0 Answers

What is trigger and stored procedure in sql?

0 Answers

How many types of triggers are there in pl sql?

0 Answers

What is foreign key and example?

0 Answers

What is the difference between the conventional and direct path loader? : aql loader

0 Answers

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers Tech Mahindra,

For more SQL PLSQL Interview Questions Click Here