CS403 Quiz 1

Q1. The database system deals with large amount of data, this property is called ___________.

1. Concurrency
2. Scalability
3. Database design
4. Robustness

Correct answer: Scalability

Q2. A candidate key that does not have a null value and is selected to uniquely identify all other attribute values in any given row is called a ____.

1. Alternate key
2. superkey
3. primary key
4. secondary key

Correct answer: primary key

Q3. Which model operates at the lowest level of abstraction?

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

Correct answer: physical

Q4. _________ is the first computer-based approach for handling the commercial or business applications.

1. Database system
2. Scientific systems
3. Record base system
4. File processing system

Correct answer: File processing system

Q5. Consider the key “CNIC, Name” and choose the best option that describes the key most effectively.

1. The given key is not a super key but a candidate key.
2. The given key is a super key and candidate key as well.
3. The given key is a super key and alternate key.
4. The given key is a super key but not a candidate key.

Correct answer: The given key is a super key but not a candidate key.

Q6. The entity that is NOT dependent on any other entity for its existence is known as _________ entity.

1. Strong
2. Dependent
3. Weak
4. Derived

Correct answer: Strong

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

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

Correct answer: loss of information and incorrect results

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

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

Correct answer: Design phase

Q9. When data stored onto a magnetic media, it is stored in________.

1. Binary format
2. Text format
3. Encrypted form
4. Numeric from

Correct answer: Binary format

Q10. A relationship is an association between two entities, or between an entity and itself. The diamond symbol for a relationship is …………. if one of the participants is dependent on the other.

1. Doubled
2. Filled
3. Single
4. Dotted

Correct answer: Doubled