Database Architecture

Q1. The two-tier architecture in databases consists of:

1. A.Three layer tiers
2. B.Client and Server✓ Correct
3. C.Only Client tier
4. D.Only Server tier

Report an error in this question

Q2. In a client-server architecture, the database resides on the:

1. A.Client side
2. B.Neither side
3. C.Both equally
4. D.Server side✓ Correct

Report an error in this question

Q3. What is a centralized database system?

1. A.A system designed to operate without any DBMS software layer
2. B.A system that runs exclusively on cloud computing platforms
3. C.A system with data distributed across multiple remote locations
4. D.A system where data is stored and managed at a single location✓ Correct

Report an error in this question

Q4. Which tier in three-tier architecture handles the user interface?

1. A.Presentation tier✓ Correct
2. B.Database data tier
3. C.None of these tiers
4. D.Business logic tier

Report an error in this question

Q5. What does a query processor do?

1. A.Backs up data to external storage
2. B.Interprets and executes database queries✓ Correct
3. C.Stores data on physical disk drives
4. D.Manages user accounts and profiles

Report an error in this question

Q6. The storage manager in a DBMS is responsible for:

1. A.Creating graphical user interfaces
2. B.Managing how data is stored on disk✓ Correct
3. C.Writing and executing SQL queries
4. D.Configuring network communication

Report an error in this question

Q7. Which component of DBMS translates high-level queries into low-level operations?

1. A.Transaction manager
2. B.Query compiler module✓ Correct
3. C.Buffer manager module
4. D.File manager module

Report an error in this question

Q8. In a three-tier architecture, the middle tier is called:

1. A.Data warehouse store
2. B.Application server✓ Correct
3. C.Database server
4. D.Web browser client

Report an error in this question

Q9. What is the role of the buffer manager?

1. A.Creates and maintains database schemas and table structures
2. B.Manages the transfer of data between disk and main memory✓ Correct
3. C.Manages user authentication and role-based access control
4. D.Processes and optimizes SQL queries for efficient execution

Report an error in this question

Q10. A database engine is also known as:

1. A.Query language
2. B.Storage engine✓ Correct
3. C.Front-end application
4. D.Report generator

Report an error in this question

Q11. In the three-schema architecture, which schema defines the user's view?

1. A.External schema✓ Correct
2. B.Internal schema
3. C.Conceptual schema
4. D.Physical schema

Report an error in this question

Q12. Which DBMS component ensures that the database remains in a consistent state after a failure?

1. A.Authorization manager
2. B.Buffer manager
3. C.Recovery manager✓ Correct
4. D.Query optimizer

Report an error in this question

Q13. The data definition language (DDL) compiler processes:

1. A.Application programs written in the host language
2. B.Schema definitions and stores metadata in the catalog✓ Correct
3. C.User-submitted queries for data retrieval operations
4. D.Data insertion commands for populating new tables

Report an error in this question

Q14. In a two-tier architecture, the application logic resides:

1. A.Exclusively on the client tier
2. B.Exclusively on the server tier
3. C.On a separate dedicated middle tier
4. D.On the client side or server side✓ Correct

Report an error in this question

Q15. What is a database catalog?

1. A.A system database containing metadata about the database structure✓ Correct
2. B.A comprehensive list of all users who have database access rights
3. C.An index structure built on primary keys of all related tables
4. D.A sequential log file that records all committed transactions

Report an error in this question

Q16. Which architecture is most suitable for web-based database applications?

1. A.Peer-to-peer architecture
2. B.Two-tier architecture
3. C.Single-tier architecture
4. D.Three-tier architecture✓ Correct

Report an error in this question

Q17. The runtime database processor executes:

1. A.Backup and recovery operations only
2. B.Data definition language statements only
3. C.Schema compilation processes only
4. D.Privileged commands and query plans at runtime✓ Correct

Report an error in this question

Q18. What is the purpose of the DML precompiler?

1. A.To compile DDL commands and update the system catalog
2. B.To extract DML commands embedded in application programs✓ Correct
3. C.To manage concurrency control among active transactions
4. D.To optimize queries by selecting the best execution plan

Report an error in this question

Q19. In a parallel database system, the main goal is:

1. A.Reduced overall storage cost on disk
2. B.Simplified query writing for users
3. C.Eliminating the need for any backups
4. D.Improved performance through parallelism✓ Correct

Report an error in this question

Q20. Shared-nothing architecture means:

1. A.All processors share the memory and disk
2. B.Only disk is shared among all processors
3. C.Each processor has its own memory and disk✓ Correct
4. D.Only memory is shared among processors

Report an error in this question

Q21. In a shared-disk parallel architecture, the potential bottleneck is:

1. A.The interconnection network to the shared disk✓ Correct
2. B.The CPU processing speed of each processor
3. C.Query parsing and syntax validation steps
4. D.Memory allocation among running transactions

Report an error in this question

Q22. The query optimizer in a DBMS uses which approach to find the best execution plan?

1. A.Cost-based optimization✓ Correct
2. B.Random selection method
3. C.User preference settings
4. D.Alphabetical table ordering

Report an error in this question

Q23. Which type of parallelism involves executing different operations of a query simultaneously?

1. A.Inter-query parallelism✓ Correct
2. B.None of these types
3. C.Intra-query parallelism
4. D.Pipeline parallelism

Report an error in this question

Q24. In a DBMS architecture, the catalog manager is responsible for:

1. A.Managing user connections and authentication sessions
2. B.Handling network protocols and data transmission tasks
3. C.Processing application logic and business rule validation
4. D.Storing and retrieving schema information and statistics✓ Correct

Report an error in this question

Q25. The concept of data independence is directly supported by:

1. A.Using only a single schema without any additional views
2. B.Storing all data exclusively in flat file format on disk
3. C.Avoiding the use of views or external schema definitions
4. D.The three-level architecture with mappings between levels✓ Correct

Report an error in this question

Q26. In a DBMS, the lock manager is part of which subsystem?

1. A.Storage management subsystem
2. B.Communication layer subsystem
3. C.Concurrency control subsystem✓ Correct
4. D.Query processing subsystem

Report an error in this question

Q27. What is the main advantage of shared-memory parallel architecture?

1. A.Lower hardware costs compared to other parallel architectures
2. B.Fast communication between processors through shared memory✓ Correct
3. C.No synchronization needed between the concurrent processors
4. D.No need for an operating system to coordinate the processes

Report an error in this question

Q28. The DBMS buffer replacement strategy LRU stands for:

1. A.Least Recently Used✓ Correct
2. B.Last Record Updated
3. C.Latest Read Utility
4. D.Least Required Update

Report an error in this question

Q29. Which DBMS component is responsible for enforcing authorization and integrity constraints?

1. A.Network manager and router module
2. B.Query parser and syntax analyzer
3. C.Storage manager and file handler
4. D.Authorization and integrity manager✓ Correct

Report an error in this question

Q30. In a multi-tier architecture, which tier contains the business rules?

1. A.Data tier (bottom tier)
2. B.Application tier (middle tier)✓ Correct
3. C.Client tier (front tier)
4. D.Presentation tier (top tier)

Report an error in this question