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 …
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 …
