DBMS_7th_ch20 Database System Architecture

What is the main characteristic of Centralized Database Systems?

• Run on multiple computer systems

• Run on a single computer system

• Run on a cloud-based system

• Run on a distributed network

Which type of server system is widely used in relational database systems?

• Parallel systems

• Distributed systems

• Data servers

• Transaction servers

What is the purpose of the log writer process in a transaction server?

• Add log records to log record buffer

• Perform periodic checkpoints

• Output modified buffer blocks to disks

• Execute user queries

What is the main drawback of a shared-memory architecture in parallel systems?

• High latency

• Bottleneck at interconnection to disk subsystem

• Non-scalable beyond a certain number of processor cores

• Complex programming requirements

Which network technology provides very low-latency networking compared to optimized Ethernet?

• Fiber Channel

• Infiniband

• Mesh

• Ethernet

What is the goal of integrating existing databases in heterogeneous distributed databases?

• Integrate different software/schema

• Improve system availability

• Share data among users

• Provide a view of a single database

What is the purpose of the two-phase commit protocol in distributed databases?

• Handle network partitioning

• Ensure atomicity of transactions

• Replicate data items

• Improve data availability

What is the main benefit of cloud computing services?

• High latency

• Non-scalable architecture

• Complex programming requirements

• On-demand provisioning and elasticity

Which application deployment architecture supports microservices?

• Virtual Machines

• Containers

• Individual Machines

• Services

What is the main drawback of a shared-nothing architecture in distributed systems?

• Complex programming requirements

• Cost of communication and non-local disk access

• High latency

• Bottleneck at interconnection to disk subsystem