Purpose of Database Systems Multiple Choice Questions with Answers – PDF Download

MCQ 1: The data values stored in the database must satisfy certain types of:

1. Data constraints
2. Consistency constraints
3. Type constraints
4. Format constraints

MCQ 2: To allow users to manipulate the information, the system has a number of:

1. Application programs
2. Application files
3. Manipulation program
4. Manipulation files

MCQ 3: Data redundancy and Data Inconsistency is one of the major drawbacks of:

1. File processing system
2. File retrieval system
3. File storage system
4. File updation system

MCQ 4: The problem that occurs while writing new application programs to retrieve the appropriate data, is known as:

1. Difficult to access data
2. Data Inconsistency
3. Data Isolation
4. Atomicity problems

MCQ 5: The problem of conventional file-processing, not allowing needed data to be retrieved efficiently, is the known problem of:

1. Data Inconsistency
2. Difficult to access data
3. Data Isolation
4. Data redundancy