31. Which layer links the network support layers and user support layers? The Transport layer links the network support layers […]
25. What is WDM? WDM is conceptually the same as FDM, except that the multiplexing and demultiplexing involve light signals
19. What is semantic gap? Defining a useful channel involves both understanding the applications requirements and recognizing the limitations of
13. What are the key elements of protocols? The key elements of protocols are a. Syntax It refers to the
. Define Network? A network is a set of devices connected by physical media links. A network is recursively is
. Define Network? A network is a set of devices connected by physical media links. A network is recursively is
139. Explain concurrency transparency. Concurrency transparency is where each transaction in a distributed database is treated as if it is
133. Describe concurrency control. Concurrency control is the process managing simultaneous operations against a database so that database integrity is
127. Describe why operational and informational systems are separate. Operational systems are used to run the business in real time
121. Describe middleware applications that ease the connection of databases to Web applications. Both ASP and ColdFusion are middleware that
115. Describe the difference between embedded and dynamic SQL. Embedded SQL is the process of including hard coded SQL statements.
109. What are the steps to follow when preparing to create a table? 1. Identify the data type, length, and
103. What is denormalization and why would someone consider doing so? Denormalization is the process of taking normalized relations and
97. List some of the properties of a relation. Relations in a database have a unique name and no multivalued
91. Explain the difference between total specialization and partial specialization. Total specialization exists when every instance of a supertype must
85. Briefly describe the six database activities that occur during the systems development life cycle. The enterprise modeling that analyzes
79. The range of database applications can be divided into five categories. Explain the five different categories. Databases can support
73. What are the functions of a reporting system? A reporting system has three functions: 1. Report authoring — connecting
67. What is the difference between a Java servlet and a Java applet? An applet is a compiled Java bytecode
61. Why is XML a better markup language than HTML? XML is a better markup language than HTML, primarily because
55. What triggers does SQL Server 2000 support? SQL Server 2000 supports INSTEAD OF and AFTER triggers only. There is
49. Explain the three levels of transaction isolation supported by Oracle. Oracle supports read committed, serializable, and read-only transaction isolation
43. What is deadlock? How can it be avoided? How can it be resolved once it occurs? Deadlock occurs when
37. What is the difference between a correlated subquery and a regular subquery? A correlated subquery appears deceptively similar to
31. What is a SQL view? Briefly explain the use of views. A SQL view is a virtual table built
