Conceptual Data Models Multiple Choice Questions (MCQs) PDF Download - 36

The schema which specifies that all the database users requirements have been met is called

1. high level conceptual schema
2. high level logical schema
3. high level structural schema
4. high level detailed schema

The type of data independence in which the schema can be altered on conceptual level without altering external level is classified as

1. conceptual level independence
2. external level independence
3. logical data independence
4. physical data independence

The files used for speedy disk search by providing the specialized structures of data are classified as

1. indexes
2. glossaries
3. content specification
4. listing documents

For a relationship type, the participation constraints and cardinality ratio are considered together to make

1. intensive constraints
2. recursive constraints
3. composite constraints
4. structural constraints

The middle computer system which is accessed to access database server is classified as

1. host server
2. application server
3. database server
4. client server