Schemas Instances and Database State MCQs with Answers PDF Download – Test 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