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
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
25. What is a recursive relationship? Give an example not used in the text. A recursive relationship is a relationship
19. Why is the multivalue, multicolumn problem another form of the multivalued dependency problem? Both problems try to store multiple
13. What is a foreign key, and what is it used for? A foreign key is used to establish relationships
7. Write an SQL SELECT statement to display all the columns of the STUDENT table but only those rows where
1. What are data and information, and how are they related in a database? Data is recorded facts and figures,
85. What is cold backup and hot backup (in case of Oracle)? Cold Backup: It is copying the three sets
79. What is Buffer Manager? It is a program module, which is responsible for fetching data from disk storage into
73. How do you communicate with an RDBMS? You communicate with an RDBMS using Structured Query Language (SQL). 74. Define
