DBMS MCQ QUESTIONS MODEL PAPER – 4

 ===========================================

DBMS MCQ QUESTIONS MODEL PAPER – 4

====================================================================

 

1.    Which of the following is a merit of the Sequential File Organization?

   a. Efficient for range queries 

   b. Fast access for individual record retrieval 

   c. No need for an index table 

   d. Suitable for dynamic data updates 

 

   Answer: a. Efficient for range queries

 

2.    What is a merit of the Hashed File Organization?

   a. Efficient for range queries 

   b. Fast access for individual record retrieval 

   c. Reduced storage space requirements 

   d. Suitable for applications with frequent data inserts and deletes 

 

   Answer: d. Suitable for applications with frequent data inserts and deletes

 

3.    Which is a merit of the Indexed Sequential File Organization?

   a. No need for an index table 

   b. Efficient for range queries 

   c. Random arrangement of records 

   d. Reduced storage space requirements 

 

   Answer: b. Efficient for range queries

 

 Demerits:

 

4.    What is a demerit of the Heap (Unordered) File Organization?

   a. Efficient for range queries 

   b. Slow access for individual record retrieval 

   c. Requires a complex indexing structure 

   d. Suitable for applications with constant data inserts and deletes 

 

   Answer: b. Slow access for individual record retrieval

 

5.    Which of the following is a demerit of the Sequential File Organization?

   a. Efficient for range queries 

   b. Requires additional space for the index 

   c. Fast access for individual record retrieval 

   d. Suitable for dynamic data updates 

 

   Answer: b. Requires additional space for the index

 

6.    What is a demerit of the Clustering File Organization?

   a. Faster access for individual record retrieval 

   b. Increased complexity in addressing and storage management 

   c. No need for an index table 

   d. Efficient for range queries 

 

   Answer: b. Increased complexity in addressing and storage management

 

 7.    Which is both a merit and a demerit of the Dynamic File Organization?

   a. Improved efficiency for range queries 

   b. Increased complexity in addressing and storage management 

   c. Reduced storage space requirements 

   d. Faster access for individual record retrieval 

 

   Answer: b. Increased complexity in addressing and storage management

 

 Merits:

 

8.    What is a merit of the B-tree Index Structure?

   a. Reduced storage space requirements 

   b. Improved efficiency for range queries 

   c. Increased complexity in addressing and storage management 

   d. Suitable for applications with constant data inserts and deletes 

 

   Answer: b. Improved efficiency for range queries

 

9.    Which is a merit of the Star Schema in data warehousing?

   a. Reduced storage space requirements 

   b. Improved efficiency for range queries 

   c. Simplified and efficient querying for analytical purposes 

   d. Increased complexity in addressing and storage management 

 

   Answer: c. Simplified and efficient querying for analytical purposes

 

 Demerits:

 

10.     What is a demerit of the Multiversion Concurrency Control in file organization?

    a. Faster access for individual record retrieval 

    b. Increased complexity in addressing and storage management 

    c. Suitable for applications with frequent data inserts and deletes 

    d. No need for an index table 

 

    Answer: b. Increased complexity in addressing and storage management

 

11.     Which of the following is a demerit of the Distributed Hashing in file organization?

    a. Efficient for range queries 

    b. Slow access for individual record retrieval 

    c. Increased complexity in addressing and storage management 

    d. Suitable for applications with constant data inserts and deletes 

 

    Answer: c. Increased complexity in addressing and storage management

 

 Mixed Merits and Demerits:

 

12.     Which is both a merit and a demerit of the Dynamic Clustering File Organization?

    a. Improved efficiency for range queries 

    b. Increased complexity in addressing and storage management 

    c. Reduced storage space requirements 

    d. Faster access for individual record retrieval 

 

    Answer: a. Improved efficiency for range queries

 

13.     What is both a merit and a demerit of the External Sorting process?

    a. Reduced storage space requirements 

    b. Increased complexity in addressing and storage management 

    c. Improved efficiency for range queries 

    d. Fast access for individual record retrieval 

 

    Answer: b. Increased complexity in addressing and storage management

 

14.     What is a merit of the Direct File Organization?

    a. Efficient for range queries 

    b. Fast access for individual record retrieval 

    c. Reduced storage space requirements 

    d. Suitable for applications with constant data inserts and deletes 

 

    Answer: b. Fast access for individual record retrieval

 

15.     Which is a merit of the Depth-First Search in file organization?

    a. Efficient for range queries 

    b. Increased complexity in addressing and storage management 

    c. Suitable for applications with frequent data inserts and deletes 

    d. Fast access for individual record retrieval 

 

    Answer: d. Fast access for individual record retrieval

 

16.     What is a demerit of the Radix Tree in file organization?

    a. Faster access for individual record retrieval 

    b. Increased complexity in addressing and storage management 

    c. Suitable for applications with constant data inserts and deletes 

    d. No need for an index table 

 

    Answer: b. Increased complexity in addressing and storage management

 

17.     Which of the following is a demerit of the Data Replication in a distributed database system?

    a. Efficient for range queries 

    b. Slow access for individual record retrieval 

    c. Increased complexity in addressing and storage management 

    d. Suitable for applications with constant data inserts and deletes 

 

    Answer: c. Increased complexity in addressing and storage management

 

 18.     Which is both a merit and a demerit of the Linear Probing in hashing for collision resolution?

    a. Increased complexity in addressing and storage management 

    b. Efficient for range queries 

    c. Suitable for applications with constant data inserts and deletes 

    d. Reduced storage space requirements 

 

    Answer: a. Increased complexity in addressing and storage management

 

19.     What is both a merit and a demerit of the External Sorting process?

    a. Reduced storage space requirements 

    b. Increased complexity in addressing and storage management 

    c. Improved efficiency for range queries 

    d. Fast access for individual record retrieval 

 

    Answer: b. Increased complexity in addressing and storage management

 

 20.     What is a merit of the Master File in a database system?

    a. Efficient for range queries 

    b. Fast access for individual record retrieval 

    c. Reduced storage space requirements 

    d. Suitable for applications with constant data inserts and deletes 

 

    Answer: b. Fast access for individual record retrieval

 

21.     Which is a merit of the Multilevel Index in file organization?

    a. No need for an index table 

    b. Increased complexity in addressing and storage management 

    c. Reduced storage space requirements 

    d. Improved efficiency for range queries 

 

    Answer: d. Improved efficiency for range queries

 

22.     What is a demerit of the Distributed Database in file organization?

    a. Efficient for range queries 

    b. Slow access for individual record retrieval 

    c. Increased complexity in addressing and storage management 

    d. Suitable for applications with constant data inserts and deletes 

 

    Answer: c. Increased complexity in addressing and storage management

 

23.     Which of the following is a demerit of the Data Dictionary in a database system?

    a. Efficient for range queries 

    b. Slow access for individual record retrieval 

    c. Increased complexity in addressing and storage management 

    d. Suitable for applications with constant data inserts and deletes 

 

    Answer: c. Increased complexity in addressing and storage management

 

24.     Which is both a merit and a demerit of the Transaction Log in a database system?

    a. Improved efficiency for range queries 

    b. Increased complexity in addressing and storage management 

    c. Reduced storage space requirements 

    d. Fast access for individual record retrieval 

 

    Answer: b. Increased complexity in addressing and storage management

 

25.     What is both a merit and a demerit of the Free Space Management in a file organization?

    a. Reduced storage space requirements 

    b. Increased complexity in addressing and storage management 

    c. Improved efficiency for range queries 

    d. Fast access for individual record retrieval 

 

    Answer: b. Increased complexity in addressing and storage management

 

26.     What is a merit of the Radix Sort in external sorting?

    a. Reduced storage space requirements 

    b. Increased complexity in addressing and storage management 

    c. Efficient for range queries 

    d. Fast access for individual record retrieval 

 

    Answer: d. Fast access for individual record retrieval

 

27.     Which is a merit of the Hierarchical File Organization?

    a. Efficient for range queries 

    b. Fast access for individual record retrieval 

    c. Reduced storage space requirements 

    d. Suitable for applications with constant data inserts and deletes 

 

    Answer: b. Fast access for individual record retrieval

 

 28.     What is a demerit of the Random File Organization?

    a. Efficient for range queries 

    b. Slow access for individual record retrieval 

    c. No need for an index table 

    d. Suitable for dynamic data updates 

 

    Answer: b. Slow access for individual record retrieval

 

29.     Which of the following is a demerit of the Inverted File Organization?

    a. Efficient for range queries 

    b. Increased complexity in addressing and storage management 

    c. Fast access for individual record retrieval 

    d. Suitable for applications with constant data inserts and deletes 

 

    Answer: d. Suitable for applications with constant data inserts and deletes

 

30.     Which is both a merit and a demerit of the Multiversion Concurrency Control in file organization?

    a. Faster access for individual record retrieval 

    b. Increased complexity in addressing and storage management 

    c. Suitable for applications with frequent data inserts and deletes 

    d. No need for an index table 

 

    Answer: b. Increased complexity in addressing and storage management

 

31.     What is a merit of the Direct File Organization?

    a. Efficient for range queries 

    b. Fast access for individual record retrieval 

    c. Reduced storage space requirements 

    d. Suitable for applications with constant data inserts and deletes 

 

    Answer: b. Fast access for individual record retrieval

 

32.     Which is a merit of the Bitmap Index in file organization?

    a. Efficient for range queries 

    b. Increased complexity in addressing and storage management 

    c. Reduced storage space requirements 

    d. Fast access for individual record retrieval 

 

    Answer: a. Efficient for range queries

 

 33.     What is a demerit of the Multilevel Index in file organization?

    a. Efficient for range queries 

    b. Slow access for individual record retrieval 

    c. Increased complexity in addressing and storage management 

    d. Suitable for applications with constant data inserts and deletes 

 

    Answer: c. Increased complexity in addressing and storage management

 

34.     Which of the following is a demerit of the Log-Structured Merge Tree (LSM Tree) in file organization?

    a. Efficient for range queries 

    b. Increased complexity in addressing and storage management 

    c. Fast access for individual record retrieval 

    d. Suitable for applications with constant data inserts and deletes 

 

    Answer: b. Increased complexity in addressing and storage management

 

35.     Which is both a merit and a demerit of the Distributed Database in file organization?

    a. Efficient for range queries 

    b. Increased complexity in addressing and storage management 

    c. Reduced storage space requirements 

    d. Suitable for applications with constant data inserts and deletes 

 

    Answer: b. Increased complexity in addressing and storage management

 

36.     What is both a merit and a demerit of the Hierarchical File Organization?

    a. Efficient for range queries 

    b. Fast access for individual record retrieval 

    c. Increased complexity in addressing and storage management 

    d. Suitable for applications with constant data inserts and deletes 

 

    Answer: c. Increased complexity in addressing and storage management

 

37.     What is a merit of the Extensible Hashing in file organization?

    a. Efficient for range queries 

    b. Increased complexity in addressing and storage management 

    c. Reduced storage space requirements 

    d. Fast access for individual record retrieval 

 

    Answer: d. Fast access for individual record retrieval

 

38.     Which is a merit of the Replication in distributed databases?

    a. Improved efficiency for range queries 

    b. Increased complexity in addressing and storage management 

    c. Enhanced fault tolerance and availability 

    d. Reduced storage space requirements 

 

    Answer: c. Enhanced fault tolerance and availability

 

39.     What is a demerit of the Trie Data Structure in file organization?

    a. Suitable for applications with constant data inserts and deletes 

    b. Increased complexity in addressing and storage management 

    c. Fast access for individual record retrieval 

    d. Efficient for range queries 

 

    Answer: b. Increased complexity in addressing and storage management

 

40.     Which of the following is a demerit of the Linear Hashing in file organization?

    a. Fast access for individual record retrieval 

    b. Increased complexity in addressing and storage management 

    c. Efficient for range queries 

    d. Suitable for applications with constant data inserts and deletes 

 

    Answer: b. Increased complexity in addressing and storage management

 

41.     Which is both a merit and a demerit of the Dynamic Clustering File Organization?

    a. Improved efficiency for range queries 

    b. Increased complexity in addressing and storage management 

    c. Reduced storage space requirements 

    d. Faster access for individual record retrieval 

 

    Answer: a. Improved efficiency for range queries

 

42.     What is both a merit and a demerit of the Cyclic Redundancy Check (CRC) in file organization?

    a. Increased complexity in addressing and storage management 

    b. Efficient for range queries 

    c. Reduced storage space requirements 

    d. Fast access for individual record retrieval 

 

    Answer: a. Increased complexity in addressing and storage management

 

=========================================================== ===============

Post a Comment

0 Comments