Gaurav Taneja

Question no

Marks

a

b

c

d

e

Answer

1

X

2

X

3

Get , Post and Soap

4

“saveAs”

5

<ASP:TemplateColumn>

6

ServicedComponent, System.EnterpriseServices

7

X

8

X

9

X

10

X

11

X

12

X

X

13

X

14

X

15

@Register

16

X

17

Snapshot, transactional, merge

18

Sysobjects,sysreferences, sysconstraints

19

X

20

X

21

This error occurs, when the length of the value entered by you into a char, varchar, nchar, nvarchar column is longer than the maximum length of the column. For example, inserting 'FAQ' into a char(2) column would result in this error.

22

We have to use the CONVERT function to strip the time off the date. Any of the following commands will do this:

SELECT CONVERT(char,GETDATE(),101)

SELECT CONVERT(char,GETDATE(),102)

SELECT CONVERT(char,GETDATE(),103)

SELECT CONVERT(char,GETDATE(),1)

23

You just have to qualify the table names in your SELECT queries with database name, followed by table owner name. In  the following example, Table1 from pubs database and Table2 from northwind database are being joined on the column i. Both tables are owned by dbo

SELECT a.i, a.j

FROM pubs.dbo.Table1 a

INNER JOIN

northwind.dbo.Table2 b

ON a.i = b.i

GO

24

X

25

X

26

X

27

X

28

X

29

X

X

30

X

31

X

32

X

33

X

34

X

  Total Questions Attempted

                    Correct answers

                    Marks Obtained