is popular for applications such as storage of log files in a database system since it offers the best write performance.

Related MCQs

• A special redo-only log record < Ti, Xj, V1> is written to the log, where V1 is the value being restored to data item Xj during the rollback. These log records are sometimes called
• Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.
• Database __________ , which is the logical design of the database, and the database _______,which is a snapshot of the data in the database at a given instant in time.
•                          using a log record sets the data item specified in the log record to the old value.
• Writing the buffered log to                      is sometimes referred to as a log force.
• A                  is a logical grouping of database objects, usually to facilitate security, performance, or the availability of database objects such as tables and indexes.
• A ________ is a logical grouping of database objects, usually to facilitate security, performance, or the availability of database objects such as tables and indexes.
•                              which increases the number of I/O operations needed to write a single logical block, pays a significant time penalty in terms of write performance.
•                      is increasingly being used in server systems to improve performance by caching frequently used data, since it provides faster access than disk, with larger storage capacity than main memory.
• A concurrency-control policy such as this one leads to              performance since it forces transactions to wait for preceding transactions to finish before they can start.