Aptitude

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

79. The range of database applications can be divided into five categories. Explain the five different categories. Databases can support

61. Why is XML a better markup language than HTML? XML is a better markup language than HTML, primarily because

43. What is deadlock? How can it be avoided? How can it be resolved once it occurs? Deadlock occurs when

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,