Schemas Instances and Database State MCQ (Multiple Choice Questions) PDF - 2

MCQ 6: The state in database management system which satisfies the constraints and specified schema structure is classified as

1. valid state
2. extension state
3. intension state
4. attribution state

MCQ 7: The database system which supports the majority of concurrent users is classified as

1. multiuser system
2. multi-function system
3. multi transaction system
4. client and disk server system

MCQ 8: When the primary key is null of the new tuple then the constraint violated is

1. null integrity constraint
2. primary integrity constraint
3. secondary integrity constraint
4. entity integrity constraint

MCQ 9: In the three-tier architecture, the intermediate layer between database and client servers is classified as

1. functional server
2. transaction server
3. application server
4. disk server

MCQ 10: The software whose main function is to provide the access the database from remote location with the help of work stations, local PCs and computer terminals is called

1. module software
2. communications software
3. host software
4. client software