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 …
41. What is normalization? It is a process of analysing the given relation schemas based on their Functional Dependencies (FDs) and primary key to achieve the properties (1).Minimizing redundancy, (2). …
30. What is SDL (Storage Definition Language)? This language is to specify the internal schema. This language may specify the mapping between two schemas.
19. What is an Extension of entity type? The collections of entities of a particular entity type are grouped together into an entity set. 20. What is Weak Entity set? …
7. Define the “integrity rules”? There are two Integrity rules. Entity Integrity: States that “Primary key cannot have NULL value” Referential Integrity: States that “Foreign Key can be either a …
1. What is database? A database is a logically coherent collection of data with some inherent meaning, representing some aspect of real world and which is designed, built and populated …
