1.

What will be the result of the following SQL query:


 
 
Select a case when null = null then 'Yes' else 'No' end as Result;
2.

In SQL, which of the following queries will print the serial number (SNo) of the rows that contain 'Square' in any columns (C1, C2, and C3):
 

1. SELECT SNo from table WHERE C1 IN ('Square');
2. SELECT SNo from table WHERE C1 = 'Square' or C2 =’Square’ or C3=’Square’;
3. SELECT SNo IN table WHERE C2 = 'Square';
4. SELECT Sno FROM table WHERE 'Square' IN (C1, C2, C3)

 
 
SNo C1 C2 C3
1 Triangle Square Rectangle
2 NULL Triangle Hexagon
3 Square NULL Pentagon