CS8492 - DATABASE MANAGEMENT SYSTEMS (UNIT 4)

UNIT 4 - IMPLEMENTATION TECHNIQUES

15 flashcards · Computer Science · by Poongothai K

1. Which level of RAID refers to disk mirroring with block strips? A) RAID level 1 B) RAID level 2 C) RAID level 0 D) RAID level 3

   A) RAID level 1

2. Optical disk technology uses ___________

   RAID

3. With multiple disks, we can improve the transfer rate as well by _____________ data across multiple disks.

   Striping

4. Which one of the following is a striping technique? A) Byte level striping B) Raid level striping C) Disk level striping D) Block level striping

   D) Block level striping

5. Where performance and reliability are both important, RAID level ___________ is used. A) 0 B) 1 C) 2 D) 0+1

   D) 0+1

6. ________________ is popular for applications such as storage of log files in a database system since it offers the best write performance.

   RAID level 1

7. Tertiary storage is built with: A) a lot of money B) unremovable media C) Removable media D) Secondary storage

   D) Secondary storage

8. A magneto-optic disk is: A) Primary storage B) Secondary storage C) Tertiary storage D) None of the mentioned

   C) Tertiary storage

9. A unit of storage that can store one or more records in a hash file organization is denoted as ___________

   Buckets

10. The highest level in the hierarchy of data organization is called __________

    Database

11. One approach to standardization storing of data? A) MIS B) Structured programming C) CODASYL specification D) None of the mentioned

    C) CODASYL specification

12. Each tablespace in an Oracle database consists of one or more files called _________

    Datafiles

13. Large collection of files are called __________

    Database

14. Relational schemas and other metadata about relations are stored in a structure called the ______________

    Data Dictionary

15. An Oracle object type has two parts the ____________ and ____________

    Specification and body