29 Dec 2017

Mock interview questions for sql server

 

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>


No comments:
Write comments

Contact Form

Name

Email *

Message *

© 2014 Rock Programmer . Designed by Bloggertheme9
Powered by Rock Programmer.