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 …
31. What is a SQL view? Briefly explain the use of views. A SQL view is a virtual table built from other tables or views. Views are used to (1) …
21. Explain the relationship between entity, entity class, and entity instance. An entity is something that can be identified in the users’ work environment, something that the users want to …
11. Discuss the alternative terminology that is used in the relational model. Relations are also called tables, and sometimes by the older data processing term files. A row is known …
1. What are data and information, and how are they related in a database? Data is recorded facts and figures, and information is knowledge derived from data. A database stores …
81. What is File Manager? It is a program module, which manages the allocation of space on disk storage and data structure used to represent information stored on a disk. …
71. Which part of the RDBMS takes care of the data dictionary? How? Data dictionary is a set of tables and database objects that is stored in a special area …
61. What do you mean by flat file database? It is a database in which there are no programs or user access languages. It has no cross-file capabilities but is …
51. What is Domain-Key Normal Form? A relation is said to be in DKNF if all constraints and dependencies that should hold on the the constraint can be enforced by …
