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
55. What is meant by query optimization? The phase that identifies an efficient execution plan for evaluating a query that
43. What is Lossless join property? It guarantees that the spurious tuple generation does not occur with respect to relation
37. What is Set-at-a-time or Set-oriented? The High level or Non-procedural DML can specify and retrieve many records in a
31. What is Data Storage – Definition Language? The storage structures and access methods used by database system are specified
13. What is Data Model? A collection of conceptual tools for describing data, data relationships data semantics and constraints. 14.
157. What is a compilation unit? A compilation unit is a Java source code file. 158. What interface is extended
133. What is the difference between a field variable and a local variable? A field variable is a variable that
121. Which class is the immediate superclass of the Container class? Component. 122. If a method is declared as protected,
115. What is the purpose of the File class? The File class is used to create objects that provide access
109. How are the elements of a GridBagLayout organized? The elements of a GridBagLayout are organized according to a grid.
91. What is the Map interface? The Map interface replaces the JDK 1.1 Dictionary class and is used associate keys
