SQL server Tricky questions

Below are some SQL basic but Tricky questions.

1.   SELECT 10
      Out of above Query
      A. Throw Error
      B. 10
      C.  0
      D. 1
2. SELECT $
    Output of Above Query
    A.Throw Error
    B. $
   C.1
   D. 0.00
3. SELECT COUNT(*)
    Output of Above Query
   A. Throw Error
   B. 0
  C. 1
  D. *
4. SELECT COUNT ('8')
 Output of Above Query
 A. Throw Error
 B. 8
C. 0
D.1
5. SELECT 'VASU'+1
   Output of Above Query
   A. Throw Error
   B. 'VASU'
   C.VASU
   D. VASU1
6. SELECT 'VASU'+'1'
   Output of Above Query
   A. Throw Error
   B. 'VASU'
   C.VASU
   D. VASU1
7. SELECT (SELECT 'VASU')
   Output of Above Query
   A. Throw Error
   B. 'VASU'
   C. VASU
    D. VASU1

8. SELECT SELECT 'VASU'
   Output of Above Query
   A. Throw Error
   B. 'VASU'
   C. VASU
    D. VASU1
9. SELECT * FROM 'EMP'
    Output of Above Query
   A.Throw Error
   B. Select all the data from EMP Table
   C.EMP
   D.'EMP'
10. SELECT * FROM EMP, DEPT
      Output of Above Query
     A. Throw Error
     B. Cross join of two Tables
     C. Inner Join of Two Tables
     D.Display only EMP Table Data
11. SELECT COUNT(*) + COUNT(*)
      Output of Above Query
    A.Throw Error
    B. 0
    C. 1
    D.2
12. SELECT 'VASU' FROM EMP
      Output of Above Query
      A. Throw Error
      B. Display one time 'VASU'
      C.Dispaly 'VASU' as many rows in the EMP Table
      D. will select EMP table Data
13. SELECT SUM(1+2*3)
      Output of Above Query
     A. Throw Error
     B. 9
     C. 7
     D. 6
14. SELECT  MAX(1+2*3)
      Output of Above Query
     A. Throw Error
     B.3
     C. 7
     D. 6
15.  SELECT MAX(1,3,4)
       Output of  Above Quey
      A. Throw Error
      B. 1
      C. 3
      D. 4
16.SELECT MAX('VASU')
    Output of Above Query
    A. Throw Error
    B. 1
    C. 2
    D. VASU
17.SELECT  Count(SELECT EMPID FROM EMP)
      Output of Above Query
    A. Throw Error
    B. Will Display Count of EMP Table
    C. 0
   D. 1

ANSWERS:

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

 Interview Questions on Temp Tables

1. Is it possible to create Trigger in TempTable?
     Yes
2. Is it possible to Create Primary key on Temp table?
    Yes
3. Is it Possible to Create Foreign Key on Temp Table.
    NO. Except Foreign Key Constrain, remain all constrains we can create on Temp Table.