Posts in the [ T-SQL ] Category

Querying Microsoft SQL Server 2012 (70-461) – Exam Preparation Questions – Part 3

On 01 Jul, 2015
T-SQL
By : Charith Silva
No Comments

Click...

Read More

Querying Microsoft SQL Server 2012 (70-461) – Exam Preparation Questions – Part 2

On 29 Jun, 2015
T-SQL
By : Charith Silva
No Comments

Click...

Read More

Querying Microsoft SQL Server 2012 (70-461) – Exam Preparation Questions – Part 1

On 28 Jun, 2015
T-SQL
By : Charith Silva
No Comments

Click...

Read More

T-SQL Exam questions and answers – Part 10

On 21 May, 2015
T-SQL
By : Charith Silva
No Comments

 

Questions

  Q1. Which of the following function would you consider using to get the day (day of the month) of the specified date?

A. DAY()

B. DATE()

C. YEAR()

D. GETDATE()

    Q2. Which of the following function would...

Read More

T-SQL Exam questions and answers – Part 9

On 21 May, 2015
T-SQL
By : Charith Silva
No Comments

 

Questions

  What will be the correct output of following T-SQL statements?   Q1. [crayon-6709bf4bd53df506102821/]

A. 199.0099

B. 199

C. 199.01

D. 199.0009

  Q2. [crayon-6709bf4bd53e7678809544/]

A. 10

B. 20

C. 40

D. 8

    Q3. [crayon-6709bf4bd53ea533779631/]

A. 0

B. -1

Read More

T-SQL Exam questions and answers – Part 8

On 01 May, 2015
T-SQL
By : Charith Silva
No Comments

Questions

  What will be the correct output of following T-SQL statements?     Q1. [crayon-6709bf4bd5e77037006323/]

A. NULL

B. 29

C. 22

D. 0

      Q2. [crayon-6709bf4bd5e7c166051886/]

A. 1

B. Fales

C. 0

D. NULL

        Q3. [crayon-6709bf4bd5e7e071345605/]

A. 0.999

B. 69999

Read More

T-SQL Exam questions and answers – Part 7

On 30 Apr, 2015
T-SQL
By : Charith Silva
No Comments

Questions

  What will be the correct output of following T-SQL statements ?   Q1. [crayon-6709bf4bd6381336246481/]

A. 1

B. 2

C. 3

D. 7

    Q2. [crayon-6709bf4bd6385497143659/]

A. $123456789.00

B. 123456789

C. $123,456,789.00

D. 123,456,789.00

    Q3. [crayon-6709bf4bd6388668505739/]

A. 1

B....

Read More

T-SQL Exam questions and answers – Part 6

On 29 Apr, 2015
T-SQL
By : Charith Silva
No Comments

   

Questions

    Q1. Which of the following function would you consider using to converts an expression of one data type to another ?

A. CAST()

B. RANK()

C. NTILE()

D. CHOOSE()

      Q2. What will be the correct output of...

Read More

T-SQL Exam questions and answers – Part 5

On 29 Apr, 2015
T-SQL
By : Charith Silva
No Comments

Questions

 

What will be the correct output of following T-SQL statements?

  Q1. [crayon-6709bf4bd6c28739122498/]

A. 24

B. 36

C. 47

D. 48

    Q2. [crayon-6709bf4bd6c2d797440438/]

A. 0

B. 1

C. 21

D. 2012

    Q3. [crayon-6709bf4bd6c2f336420481/]

A. 1

B....

Read More

T-SQL Exam questions and answers – Part 4

On 19 Apr, 2015
T-SQL
By : Charith Silva
No Comments

 

Questions

What will be the correct output of following T-SQL statements?   Q1. [crayon-6709bf4bd7068851899043/]

A. 0

B. 1

C. -1

D. 1.33

    Q2. [crayon-6709bf4bd706c118144110/]

A. 0

B. 1

C. Q

D. 38

    Q3. [crayon-6709bf4bd706f563114176/]

A. 1

B. 2

Read More