Transaction Processing

What is the main purpose of a client-server database?

• To provide a local copy of a database to each client
• To provide simultaneous access to a database for several clients
• To store data in a centralized location
• To allow clients to update the server software

Where is the database stored in a client-server architecture?

• On each client machine
• On a central server
• In the cloud
• On a USB drive

What software runs on the server in a client-server database architecture?

• Operating System
• Database Management Software (DBMS)
• Anti-virus software
• File Management System

Which CRUD operation is mapped to the SQL command 'Insert'?

• Create
• Retrieve
• Update
• Delete

What does the Consistency property of ACID ensure?

• Transactions are completed in a timely manner
• Transactions follow all established rules of the database
• Transactions are performed in isolation
• Transactions are durable

Which of the following best describes the Isolation property of ACID?

• Transactions are dependent on each other
• Transactions can modify other transactions
• Transactions are independent and do not manipulate other transactions
• Transactions are always successful

What does the Durability property of ACID ensure?

• Transactions are completed quickly
• Transactions are not lost even after a system failure
• Transactions do not interfere with each other
• Transactions follow all rules

What is the purpose of record locking in databases?

• To prevent unauthorized access
• To ensure data is backed up
• To prevent simultaneous access to objects in a database
• To speed up transaction processing

How does HTTP 'Get' map to SQL commands in CRUD operations?

• Create
• Retrieve
• Update
• Delete

What problem can arise if multiple clients try to access the same item in a client-server database simultaneously?

• Increased data security
• Data redundancy
• Network speed increases
• Traffic congestion / lag