Which operator works like an OUTER JOIN?
Minus
Except
Intersect
Union
Which function return NULL when X = Y and X when it does not?
NULLIF(X,Y)
COALESCE(X,Y)
ZEROIFNULL(X,Y)
NULLIFZERO(X,Y)
1)Which function is used to get the Current System Date and Time
GetSystemDate()
GetDate()
GetCurrentDateTime()
None
What will be the Output for the Below Query Select * from Retailer where rtrid = (select top 3 Rtrid from retailer)
Return Top 3 Row in the Retailer Table
Return Error
Return No Record
Return all Records from Retailer Table
Which function is used to get the Current System Date and Time
What will be the Output for the Below Query
How many Primary Key can be set for an table
10
1
2
Infinite
What will be the Output for Select Abs(25-45)
Abs is not a recognized function name
-20
20
Which of the joins are available in SQL i) Inner Join ii) Left Outer Join iii) Cross Join iv) Self Join
All the Above
i) and ii)
i), ii) and iii)
How many Output Parameters can be set for an Stored Procedure
One
More than One
Stored Procedure Does not support Output Parameter