Fayoum University
Faculty of Computers & Information
Mid-Term Exam 2022/2023
Course Name: Database management system Course Code:IS312 Department: IS
Marks: 20 Exam duration : 1 Hours
No of Questions: 2 No of Pages: 2 Exam Date: 29/11/2022
Answer the Following Questions:
Question (1)(A) Select the best answer (10 Marks)
1. ____ is a collection of programs that enables users to create and maintain a database.
a) RTS b) DBMS c) IS d) AI
2. The logical design, and the snapshot of the data at a given instant in time is known as?
a) Instance & Relation b) Schema & Instance c) Relation & Schema d) Non
3. The ability to query data, as well as insert, delete, and alter tuples, is offered by----
a) VDL b) SDL c) DDL d) DML
4. A state that satisfies the structure and constraints of a scheme is called ______ state.
a) invalid b) true c) real d) valid
5. The database state is called _______ of the schema.
a) intension b) extension c) expansion d) definition
6. ________ is the basic object of ER model which is a thing in real world.
a) relation b) domain c) attribute d) entity
7. _______ attributes can have more than one value.
a) composite b) simple c) multi-valued d) single valued
8. The entity is represented in ER-diagrams by ______.
a) oval b) rectangle c) double oval d) diamond
9. A weak entity type always has a ______ participation constraint with respect to its identifying
relationships.
a) partial b) total c) overlap d) disjoint
10. The values appearing in given attributes of any tuple in the referencing relation must likewise
occur in specified attributes of at least one tuple in the referenced relation, according to
________ integrity constraint.
a) Referential b) Primary c) Referencing d) Specific
11. __indicates the maximum number of entities that can be involved in a relationship.
a) Greater Entity b) Minimum cardinality c) Maximum cardinality d) ERD
12. Which of the following is not the utility of DBMS?
1) Backup 2) Loading 3) Process Organization 4) File organization
a) 1, 2, and 4 only b)1, 2and 3 only c) 1, 3 and 4 only d) All
13. Rows of a relation are known as the _______.
a) Degree b) Tuples c) Entity d) All of the above
14. Which of the following is a top-down approach in which the entity's higher level can be
divided into two lower sub-entities?
a) Aggregation b) Generalization c) Specialization d) All of the above
1
Faculty of Computers & Information
Mid-Term Exam 2022/2023
Course Name: Database management system Course Code:IS312 Department: IS
Marks: 20 Exam duration : 1 Hours
No of Questions: 2 No of Pages: 2 Exam Date: 29/11/2022
Answer the Following Questions:
Question (1)(A) Select the best answer (10 Marks)
1. ____ is a collection of programs that enables users to create and maintain a database.
a) RTS b) DBMS c) IS d) AI
2. The logical design, and the snapshot of the data at a given instant in time is known as?
a) Instance & Relation b) Schema & Instance c) Relation & Schema d) Non
3. The ability to query data, as well as insert, delete, and alter tuples, is offered by----
a) VDL b) SDL c) DDL d) DML
4. A state that satisfies the structure and constraints of a scheme is called ______ state.
a) invalid b) true c) real d) valid
5. The database state is called _______ of the schema.
a) intension b) extension c) expansion d) definition
6. ________ is the basic object of ER model which is a thing in real world.
a) relation b) domain c) attribute d) entity
7. _______ attributes can have more than one value.
a) composite b) simple c) multi-valued d) single valued
8. The entity is represented in ER-diagrams by ______.
a) oval b) rectangle c) double oval d) diamond
9. A weak entity type always has a ______ participation constraint with respect to its identifying
relationships.
a) partial b) total c) overlap d) disjoint
10. The values appearing in given attributes of any tuple in the referencing relation must likewise
occur in specified attributes of at least one tuple in the referenced relation, according to
________ integrity constraint.
a) Referential b) Primary c) Referencing d) Specific
11. __indicates the maximum number of entities that can be involved in a relationship.
a) Greater Entity b) Minimum cardinality c) Maximum cardinality d) ERD
12. Which of the following is not the utility of DBMS?
1) Backup 2) Loading 3) Process Organization 4) File organization
a) 1, 2, and 4 only b)1, 2and 3 only c) 1, 3 and 4 only d) All
13. Rows of a relation are known as the _______.
a) Degree b) Tuples c) Entity d) All of the above
14. Which of the following is a top-down approach in which the entity's higher level can be
divided into two lower sub-entities?
a) Aggregation b) Generalization c) Specialization d) All of the above
1
