Review

[Previous] [Next]

The following questions are intended to reinforce key information presented in the chapter. If you are unable to answer a question, review the appropriate lesson and then try the question again. Answers to the questions can be found in Appendix A, "Questions and Answers."

1. You want to view metadata about objects in a SQL Server database. What methods would you use?

Answer

2. What tool can be used to register remote SQL Servers in the Enterprise Manager?

Answer

3. Is it possible to have two tables named "Authors" in a database?

Answer

4. Which system stored procedure can be used to retrieve information about a particular database?

Answer

5. Which system table has a row for each database object?

Answer