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:
diffrence between cast and convert
http://sqltutorials.blogspot.com/2007/06/sql-cast-and-convert.html
Post a Comment