Chapter 7 DBMS functions correctly answered 2023

Chapter 7 DBMS functions correctly answered 2023What are the functions of a DBMS? -update and retrieve data -provide catalog services -support concurrent update -recover data -provide security services -provide data integrity features -support data independence -support data replication -provide utility services What is metadata? data about data What is a data dictionary? a super catalog What is a concurrent update? multiple users make updates to the same database at the same time What is the purpose of supporting concurrent updates? ensures accuracy when several users update database at the same time what is locking? deny other users access to data while one user's updates are being processed What is transaction? set of steps completed by a DBMS to accomplish a single user task What does the two-phase locking consist of and what is its purpose? purpose is to solve lost update problem and it consists of growing phase and shrinking phase What is the growing phase? DBMS locks more rows and releases none of the locks What is the shrinking phase? DBMS releases all the locks and acquires no new locks What is the purpose of providing catalog services? to store metadata and make it accessible to users What is deadlock or deadly embrace? when two users hold a lock and require a lock on the resource that the other already has What is recovery? returning database to a correct state from an incorrect state