Geeks With Blogs
Gaurav Taneja Great dreams... never even get out of the box. It takes an uncommon amount of guts to put your dreams on the line, to hold them up and say, "How good or how bad am I?" That's where courage comes in.
 

Answer Sheet

Paper Code: EBXI-1004-DNT-003

 

Name: -                                                                                               Date:

 

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

 

 

 

 

 

 

For Official use: -

  Total Questions Attempted

 

                    Correct answers

 

                    Marks Obtained

 




Remarks: -

Name and signature of reviewer

Posted on Sunday, May 20, 2007 11:26 PM | Back to top


Comments on this post: DotNet Answers

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © Gaurav Taneja | Powered by: GeeksWithBlogs.net