Transaction Management and Concurrency Control
What is a Transaction?
Any action that reads from and/or writes to a database may
Simple SELECT statement to generate list of table
Series of related UPDATE statements to cha
IT133 - ADVANCE DATABASE MANAGEMENT
Databaseshared, integrated computer structure that stores:
-End user data (raw facts)
-Metadata (data about data)
DBMS (database management system):
-Collection of programs that manages database structure and
1. A user-friendly interface is one of the DDBMS disadvantages. T/F
-2. An Integrated, subject-oriented, time-variant, nonvolatile collection of data that provides support for
decision making. *DATA WAREHOUSE
-3. Arrangement of computerized tools u
A_ 31. The SQL command that lets you insert row(s) into a table is _.
C_ 32. The SQL command that lets you permanently save data changes is _.
B_ 33. The SQL command that lets