Match List I with List II
| List I | List II |
|---|---|
| A. Project Join Normal Form | I. Concurrency |
| B. The lost update problem | II. Fifth Normal Form |
| C. Discretionary Access Control | III. SQL |
| D. Data Manipulation Language | IV. Security |
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: A. A-II, B-I, C-IV, D-III
Explanation
Project-Join Normal Form is another name for Fifth Normal Form (A-II). The lost update problem is a concurrency problem (B-I). Discretionary access control is a security mechanism (C-IV). DML is part of SQL (D-III).More Database Management Systems questions
- In a schema R(A, B, C, D, E, F, G, H), each field of R contains only atomic values. F = {CH → G, A → BC, B → CFH, E → A, F → EG} is a set o…
- Consider a relation schema R = (U, V, W, X, Y, Z), on which the following functional dependencies hold: {U → V, VW → X, Y → W, X → U}. The…
- Consider a schema R(P, Q, R, S) and the functional dependencies P → Q, Q → R, R → S, S → Q. Then the decomposition of R into R₁(P, Q), R₂(Q…
- What is SQL primarily used for in the context of relational databases?
- How does a relational database ensure data integrity?
- Fifth normal form is concerned with: