Database Reference
In-Depth Information
SQL database is limited to 1 GB. To expand the database size beyond the limit and to improve
performance, the federation technology can get the job done. his chapter discusses the concepts
of federations. It also includes some design strategies to fully take advantage of the federation tech-
nology. For creating and managing federations, this chapter introduces a set of SQL statements.
In the federation hands-on activity, we have created and managed a federation for the database
ClassDB. he hands-on activity illustrates how to query information from diferent federation
members.
Review Questions
1. What are the advantages of using views in database applications?
2. How can indexes be used to improve query performance?
3. In what situations will indexes not improve performance?
4. What are the restrictions when creating a view?
5. When can a view be updated?
6. What are the restrictions for modiication operations on a view?
7. In the New Query editor, create a view FACULTY_CLASS_VIEW, including all rows from
the single table FACULTY_CLASS. Perform the insert, delete, and update operations to
demonstrate the modiications on the table FACULTY_CLASS through the view.
8. What is a clustered index? What is the advantage of the clustered index?
9. What is a nonclustered index?
10. What is a composite index?
11. In the New Query editor, create an index called Faculty_Index on the Name column in
FACULTY the table.
12. Why do federations play an important role in database application development?
13. What is a federation?
14. Why do we need federations?
15. What is a federation key?
16. What command is used to split a federated table?
17. What is a federation member?
18. What is an atomic unit?
19. What is a federation table?
20. What types of data can be used to generate federation keys?
