CS403 Midterm MCQs 2024 by Miss Mehwish

CS403 (Live Quiz0 · Mid Term · Past Papers for Mids./Finals are also Available

1. In natural join the common attribute in the output table appears:

❌ Twice ✅ Once ❌ Three times

Q2. In your opinion, why relational database is widely acceptable?

❌ Due to its complexity ❌ Due to its approach ✅ Due to its strength ❌ Due to its dependencies

Q3. Suppose we have two entities department and University. Which type of dependency exists between these two entities?

❌ Identifier ❌ Existence ✅ Referential

4. Suppose a relation has five columns and ten rows, select the correct option to identify the degree of relation. ❌ Ten ❌ Twenty ✅ Five

5. In Relational Data model, the values of the attributes come from the:

✅ Universal ❌ Heterogeneous ❌ Unique ❌ Same

6. The ______ determines that the link between two entities is optional or mandatory. ❌ Maximum degree ❌ Maximum cardinality ✅ Minimum cardinality ❌ Minimum degree

7. RDM is simple, there is just one structure and that is:

❌ Data model ✅ A relation or a table ❌ Attributes ❌ E-R model

8. A____ entity has a primary key that is partially or totally derived from the parent entity in the

❌ Business ✅ Weak

9. Binary relationships are those, which are established between:

❌ One entity type ❌ Three entity type ✅ Two entity type ❌ Unlimited entities

Q10. Which of the following is true regarding foreign keys?

❌ Each table in database must have a foreign key ✅ Foreign key is not a super key ❌ There can only be one foreign key in a relation ❌ There can be as many foreign keys as needed

Q1. Consider an employee is allotted an organization vehicle, which might solely be driven by that employee. What kind of relationship exists between employee and company?

Many-to-many One-to-one ✔ One-to-many Many-to-one

Q2. Which of the following tool is used to design conceptual database design?

Oracle SQL This model is independent of any tool ✔ MS Access

3. An example of --------------------- relationship can be seen between project and employee because an

One-to-many Many-to-many ✔ One-to-one Many-to-one

4. Suppose a relation has five columns and ten rows, select the correct option to identify the degree of relation. Fifteen Ten Twenty Five ✔