NSCT – Database System Architecture MCQs

20 min Score: 0 Attempted: 0/20

1. . Database System Architecture defines:
(A) How to compress data
(B) How to delete old files
(C) The structure, components, and design of a database system
(D) CPU management only

2. . The three levels of database architecture are:
(A) User, Admin, Superuser
(B) Primary, Secondary, Tertiary
(C) Internal, Conceptual, External
(D) Hardware, Software, Network

3. . The internal level of database architecture deals with:
(A) User queries
(B) Physical storage of data
(C) Views of the data
(D) Backup policies

4. . The conceptual level of database architecture describes:
(A) Encryption methods
(B) Storage hardware
(C) Network speed
(D) Logical structure of the entire database

5. . The external level (or view level) defines:
(A) Compression techniques
(B) Physical storage
(C) Encryption algorithms
(D) How individual users see the data

6. . DBMS architecture separates:
(A) Physical, logical, and user views of data
(B) Backup and recovery
(C) Only queries and reports
(D) Network and CPU

7. . The main advantage of three-level architecture is:
(A) Faster queries only
(B) Data independence and abstraction
(C) Data compression
(D) Physical storage reduction

8. . Physical data independence means:
(A) Compression does not affect storage
(B) Deleting files does not affect queries
(C) Encryption does not affect performance
(D) Changes in internal storage do not affect conceptual schema

9. . Logical data independence means:
(A) Compression does not affect files
(B) Changes in user queries do not affect storage
(C) Changes in conceptual schema do not affect external views
(D) Encryption does not affect CPU

10. . DBMS components include:
(A) DB Engine, Query Processor, Storage Manager, Transaction Manager
(B) CPU, RAM, Hard Disk
(C) Antivirus, Firewall, VPN
(D) User, Admin, Network

11. . The DB Engine is responsible for:
(A) Increasing CPU speed
(B) Encrypting files automatically
(C) Compressing logs
(D) Managing storage, retrieval, and manipulation of data

12. . The Query Processor:
(A) Encrypts data
(B) Compresses files automatically
(C) Deletes old records
(D) Interprets and executes SQL queries

13. . Storage Manager handles:
(A) Compression
(B) Only backups
(C) Data storage structures, file management, and indexing
(D) CPU scheduling

14. . Transaction Manager ensures:
(A) Compressing tables
(B) Deleting unnecessary files
(C) ACID properties of database transactions
(D) Encrypting logs

15. . Metadata in DBMS refers to:
(A) Compressed tables
(B) Encrypted data
(C) Data about data, including schema, constraints, and structure
(D) Backup files

16. . Client-Server architecture in DBMS means:
(A) Client compresses server data
(B) Server deletes client files
(C) Clients send requests to the server which manages the database
(D) Only local storage is used

17. . Multi-tier architecture in DBMS adds:
(A) Backup layer
(B) Compression layer
(C) Application layer between client and database for better scalability
(D) Encryption layer only

18. . Data independence in DBMS helps to:
(A) Modify storage or schema without affecting applications
(B) Compress files automatically
(C) Delete old data
(D) Encrypt tables

19. . The catalog or data dictionary stores:
(A) Compressed logs
(B) Encrypted backups
(C) Metadata and information about database objects
(D) CPU usage

20. . The main purpose of Database System Architecture is to:
(A) Increase CPU speed only
(B) Compress files
(C) Delete old records
(D) Provide a framework for data storage, retrieval, manipulation, and security

Exit mobile version