Questions and Answers

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 …

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 …

13. What is meant by arm-stickiness? If one or a few processes have a high access rate to data on one track of a storage disk, then they may monopolize …