Denormalization is never a good practice.
The purpose of concurrency control is:
preventing users from working on a database concurrently.
ensuring that one user’s work does not influence another user’s work
providing an opportunity for users to work on databases concurrently.
stopping all concurrent transactions.
Locks placed automatically by the DBMS are called:
Locks placed by the user for exclusive rights to the data are called:
A pointer into a set of rows that are the result set from an SQL SELECT statement is
Reprocessing is not typically the best method of recovery from a failure in a multiuser
"User-defined function” and “stored procedure” are
The standard developed in the early 90’s to provide a DBMS-independent means for
processing relational database data is:
A database system that has data, programs, and personnel specializing in the
preparation of data for BI processing is called:
a data mart.
an ETL system.
a data warehouse.
Dimensional database use which type of design:
Normalized database design
Operational database design
1. Describe the lost update problem.
It is a typical problem in the SQL transaction processing. It occurs when
two queries or transactions access and update the same data from the
database. Each tra...