Placement Papers - Microsoft

Microsoft Corporation
Microsoft Interview Questions Paper (Set-6)
Posted by :
Soumya rath
(9)
MICROSOFT COLLEGE CAMPUS PREVIOUS YEARS QUESTION PAPERS AND HR INTERVIEW QUESTIONS



DATABASES QUES N ANS

What are two methods of retrieving SQL?

(Avg. of 588 ) : What cursor type do you use to retrieve multiple recordsets?

(Avg. of 35 ) : What action do you have to perform before retrieving data from the next result set of a stored procedure?

(Avg. of 36 ) : What is the basic form of a SQL statement to read data out of a table?

(Avg. of 29 ) : What structure can you have the database make to speed up table reads?

(Avg. of 16 ) : What is a "join"?

(Avg. of 17 ) : What is a "constraint"?

(Avg. of 11 ) : What is a "primary key"?

(Avg. of 11 ) : What is a "functional dependency"? How does it relate to database table design?

(Avg. of 15 ) : What is a "trigger"?

(Avg. of 7 ) : What is "index covering" of a query?

(Avg. of 42 ) : What is a SQL view?