Sql Server Simple Queries and Answers

1). SELECT 15
output of this query would be.
A). Throw error
B). 15
C). 0
D). 1


2).SELECT $
output of this query would be.
A). Throw error
B). $
C). 1
D). 0.00


3). SELECT COUNT(*)
output of this query would be.
A). Throw error
B). 0
C). 1
D). *


4). SELECT COUNT('7')
output of this query would be.
A). Throw error
B). 7
C). 0
D). 1


5). SELECT 'VIKAS' + 1
output of this query would be.
A). Throw error
B). 'VIKAS'
C). VIKAS
D). VIKAS1


6).SELECT 'VIKAS' + '1'
output of this query would be.
A). Throw error
B). 'VIKAS'
C). VIKAS
D). VIKAS1


7).SELECT (SELECT 'VIKAS')
output of this query would be.
A). Throw error
B). 'VIKAS'
C). VIKAS
D). VIKAS1


8).SELECT SELECT 'VIKAS'
output of this query would be.
A). Throw error
B). 'VIKAS'
C). VIKAS
D). VIKAS1


9). SELECT * FROM 'Country'
output of this query would be.
A). Throw error
B). Select all data from country table
C). Country
D). Throw error


10). SELECT * FROM Country , EmployeeDetail
output of this query would be.
A). Throw error
B). Output will be cross join of both tables
C). Output will be inner join
D). Output will be only Country table data



11). SELECT COUNT(*) + COUNT(*)
output of this query would be.
A). Throw error
B). 0
C). 1
D). 2


12). SELECT 'VIKAS' FROM Country
output of this query would be.
A). Throw error
B). Display one time "VIKAS"
C). Display "VIKAS" as many rows in Country table
D). Will select country table data


13).SELECT SUM(1+2*3)
output of this query would be.
A). Throw error
B). 9
C). 7
D). 6


14). SELECT MAX(1+2*3)
output of this query would be.
A). Throw error
B). 3
C). 7
D). 6


15).SELECT MAX(1,3,4)
output of this query would be.
A).Throw error
B). 1
C). 3
D). 4


16).SELECT MAX('VIKAS')
output of this query would be.
A).Throw error
B). 1
C). 2
D). VIKAS


17).Select Count(SELECT CountryID FROM Country)
output of this query would be.
A).Throw error
B). Will display count of country table
C). 0
D). 1



Answers
17) A 16) D 15) A 14) C
13) C 12) C 11) D 10) B
09) A 08) A 07) C 06) D
05) A 04) D 03) C 02) D 01) B