CS403 Quiz 1 Set 2

Q1. Which of the following is the correct abbreviation of ERD?

1. Entity real distance
2. Entity reality diagram
3. Entity relationship diagram
4. Entity relation diagram

Correct answer: Entity relationship diagram

Q2. In a three-level DBMS architecture, the ______ level interacts directly with the users.

1. conceptual
2. physical
3. internal
4. external

Correct answer: external

Q3. Free standing data dictionary is created by Using ______.

1. CASE tools
2. DFD
3. Cross Reference Matrix
4. Database

Correct answer: CASE tools

Q4. Consider an example XYZ university might need to record which teachers taught which subject in which courses. It is an example of ------------------ relationship.

1. N-ary
2. Unary
3. Binary
4. Ternary

Correct answer: Ternary

Q5. Data inconsistency leads to a number of problems such as ___________.

1. loss of information and incorrect results
2. Slow database development
3. Data isolation
4. less secure data

Correct answer: loss of information and incorrect results

Q6. In Cross Reference Matrix attributes are specified on _______.

1. None of the above
2. Y axis
3. X axis
4. Z axis

Correct answer: X axis

Q7. Database system saves lots of efforts and finances, this advantage provides ________.

1. Economy of scale
2. Faster Application Development
3. Batter concurrency control
4. Time saving structure

Correct answer: Economy of scale

Q8. In which phase of database development process, logical design of the database is created?

1. Implementation
2. Design phase
3. Physical design
4. Requirement analysis

Correct answer: Design phase

Q9. Which of the following is correct about Database modeling?

1. Process of creating the schemas of the database.
2. Process of creating the data dictionary of the database.
3. Process of creating the physical structure of the database.
4. Process of creating the logical structure of the database.

Correct answer: Process of creating the logical structure of the database.

Q10. A Database System is designed to meet the information needs of __________in an organization.

1. Database administrator
2. Multiple users
3. Single user
4. Application user

Correct answer: Multiple users