We provide IT Services

Register Now Click On

Read More Tutorials Click On

Post Page Advertisement [Top]

 

Q1. WHICH OF THE SYSTEM DATABASES IS LOADED FIRST?

Ans. RESOURCE

Q2. WHAT IS THE SIZE OF TDS PACKETS?

Ans. 4096 BYTES

Q3. WHAT IS THE DEFAULT DRIVER FOR SQL SERVER?

Ans. SQL NATIVE CLIENT (SNAC)

Q4. CREATE TABLE tblprodcts
(
PrdID int,
PrdName varchar(30),
PrdDesc char(8000)
)

FROM ABOVE TABLE, WHAT IS THE MAXIMUM POSSIBLE SIZE OF A ROW?

Ans. 8034 BYTES

Q5.FROM ABOVE TABLE, HOW MANY ROWS CAN BE INSERTED?

Ans. UNLIMITTED ROWS

Q6. WHICH COMES FIRST? SERVICE OR AUTHENTICATION?

Ans.  SERVICE

Q7. AUTHENTICATION IS COMMUNICATION BETWEEN.

USER AND _ SQL SERVER_____________

Q8. SERVER CONTAINS DATABASE. DATABASE CONTAINS PHYSICAL

Ans. FILES.

Q9. SIZE OF A DATA PAGE .

Ans. 8 KB.

Q10. GIVEN A TABLE WITH 3 COLUMNS. HOW TO ADD 4TH COLUMN? WRITE THE SYNTAX.

Ans.ALTER TABLE TABLE-NAME ADD COL4 <TYPE>


1 comment:

Anonymous said...

diffrence between cast and convert
http://sqltutorials.blogspot.com/2007/06/sql-cast-and-convert.html

Post a Comment

| Designed by Rockprogrammer