Match the LIST-I with LIST-II LIST-I LIST-II A. Project Join Normal Form I.…
2025
Match the 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 |
Choose the correct answer from the options given below:
- A.
A-II, B-I, C-IV, D-III
- B.
A-I, B-II, C-IV, D-III
- C.
A-I, B-II, C-III, D-IV
- D.
A-IV, B-II, C-III, D-I
Attempted by 95 students.
Show answer & explanation
Correct answer: A
Correct matching: Project Join Normal Form — Fifth Normal Form; The lost update problem — Concurrency; Discretionary Access Control — Security; Data Manipulation Language — SQL.
Project Join Normal Form → Fifth Normal Form: Project-join (or join) normal form is a level of database normalization dealing with join dependencies, which corresponds to Fifth Normal Form.
The lost update problem → Concurrency: The lost update is a classic concurrency control problem that arises when transactions interfere and overwrite each other.
Discretionary Access Control → Security: Discretionary access control is an authorization model used to enforce security policies by granting or restricting access to resources.
Data Manipulation Language → SQL: Data Manipulation Language refers to the subset of SQL used to retrieve and modify data (for example, SELECT, INSERT, UPDATE, DELETE).
Final answer: A-II, B-I, C-IV, D-III.
A video solution is available for this question — log in and enroll to watch it.