MICROSOFT PLACEMENT PAPER 6

DOWNLOAD 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?