CS8492 - DATABASE MANAGEMENT SYSTEMS (UNIT 3)

UNIT 3 - TRANSACTIONS

10 flashcards · Computer Science · by Poongothai K

1. In the ___________ normal form, a composite attribute is converted to individual attributes.

   First

2. A table on the many side of a one to many or many to many relationship must: A) Be in Second Normal Form (2NF) B) Be in Third Normal Form (3NF) C) Have a single attribute key D) Have a composite key

   D) Have a composite key

3. Functional dependencies are the types of constraints that are based on ________

   Key

4. Which is a bottom-up approach to database design that design by examining the relationship between attributes? A) Functional dependency B) Database Modeling C) Normalization D) Decomposition

   C) Normalization

5. Which of the following object types below cannot be replicated? A) Data B) Trigger C) View D) Sequence

   D) Sequence

6. Which of the following is a physical storage media? A) Tape storage B) Optical storage C) Flash memory D) All of the mentioned

   D) All of the mentioned

7. A __________ is the smallest unit of information that can be read from or written to the disk.

   Sector

8. _________ is the time from when a read or write request is issued to when data transfer begins

   Access time

9. ____________ is around one-half of the maximum seek time.

   Average seek time

10. Once the head has reached the desired track, the time spent waiting for the sector to be accessed to appear under the head is called the ___________

    Rotational latency time