131. Describe the difference between data and database administration. Data administration is responsible for the overall management of data resources. Some of the core roles include the creation of data …
121. Describe middleware applications that ease the connection of databases to Web applications. Both ASP and ColdFusion are middleware that ease the connection of databases to Web applications. Both require …
111. Explain a join between tables A join allows tables to be linked to other tables when a relationship between the tables exists. The relationships are established by using a …
101. What are the four objectives of the selection of a data type? A data type should be selected so that all possible values are represented using minimal storage space. …
91. Explain the difference between total specialization and partial specialization. Total specialization exists when every instance of a supertype must also be an instance of a subtype. Partial specialization exists …
81. Briefly explain the five components of an Information Systems Architecture and their relationship to data. Processes that manipulate the data. Networks that transport the data. People who process and …
71. What is a data mart? A data mart is a collection of data smaller in scope and size than a data warehouse. It is dedicated to data from a …
61. Why is XML a better markup language than HTML? XML is a better markup language than HTML, primarily because XML provides a clear separation between document structure, content, and …
51. What is the difference between SQL Server 2000 complete and differential backups? A complete backup makes a copy of the entire database. A differential backup makes a copy of …
41. Explain the difference between an exclusive lock and a shared lock. An exclusive lock prohibits other users from reading the locked resource; a shared lock allows other users to …
