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 …
43. What are the possible threads a thread can have? Ready Standby Running Waiting Transition Terminated
37. List out some reasons for process termination. Normal completion Time limit exceeded Memory unavailable Bounds violation Protection error Arithmetic error
31. What is SMP? To achieve maximum efficiency and reliability a mode of operation known as symmetric multiprocessing is used. In essence, with SMP any process or threads can be …
25. In loading programs into memory, what is the difference between load-time dynamic linking and run-time dynamic linking? For load-time dynamic linking: Load module to be loaded is read into …
19. What are local and global page replacements? Local replacement means that an incoming page is brought in only to the relevant process address space. Global replacement policy allows any …
