DBMS_7th_ch25 Advanced Application Development

What is the thumb rule mentioned for choosing between RAID 1 and RAID 5?

• RAID 1 is always the best choice regardless of the workload

• RAID 5 is always the best choice regardless of the workload

• RAID 5 is fine when writes are rare and data is very large, but RAID 1 is preferable otherwise

• RAID 1 is fine when writes are rare and data is very large, but RAID 5 is preferable otherwise

What is the purpose of vertically partitioning relations in database schema tuning?

• To reduce the overall storage space required

• To combine all data into a single relation for faster access

• To isolate the data that is accessed most often and only fetch needed information

• To increase the complexity of the database schema

Which type of index is appropriate for most frequent types of queries?

• B-tree

• Hash

• Clustered

• Bitmap

What is the purpose of materialized views in database design?

• To speed up certain queries, particularly aggregate queries

• To increase the storage space required

• To complicate the database schema

• To reduce the overall performance of the database

What is the main drawback of long update transactions in a database system?

• Decrease the number of transactions processed

• Exhaust lock space and log space, leading to increased recovery time

• Improve overall system performance

• Reduce the workload on the database

What is the purpose of performance simulation using queuing models?

• To replace actual performance testing

• To increase the complexity of the system

• To slow down the system for testing purposes

• To predict bottlenecks and effects of tuning changes without access to real system

What are the common performance measures used in database system benchmarks?

• Error rate, Downtime, Security breaches

• Throughput, Response time, Availability

• Memory usage, CPU utilization, Network speed

• Latency, Bandwidth, Storage capacity

What is the purpose of TPC benchmarks in database system evaluation?

• To measure the physical size of databases

• To introduce new features in database systems

• To test the compatibility of different operating systems

• To quantify the performance of software systems and compare database systems

What is the main goal of standardization in database systems?

• To ensure compatibility and interoperability between systems

• To increase the complexity of systems

• To limit the features available in systems

• To slow down the progress of technology

What is the purpose of digital cash systems in e-commerce?

• To simplify the payment process for buyers

• To increase the risk of fraud in online payments

• To track buyers' identities for marketing purposes

• To provide anonymity similar to physical cash for online transactions