Total Pageviews

Saturday, December 3, 2011

Databases : Microsoft Examination Papers

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?

No comments:

Post a Comment