Question
Computer Science Question on Database Concepts
Match LIST I with LIST IILIST I
Mineral| LIST II
States
---|---
A| UNIQUE | I| The column which refers to value of an attributes defined primary key in another table
B| Primary key | II| A value specified for the column if no value is specified
C| Default | III| The column which can uniquely identify each row/record in a table
D| Foreign key| IV| Ensures that all the values in a column are distinct
Choose the Correct answer from the options given below
A
(A)-(III), (B)-(IV), (C)-(II), (D)-(I)
B
(A)-(IV), (B)-(III), (C)-(II), (D)-(I)
C
(A)-(II), (B)-(III), (C)-(I), (D)-(IV)
D
(A)-(IV), (B)-(I), (C)-(II), (D)-(III)
Answer
(A)-(IV), (B)-(III), (C)-(II), (D)-(I)
Explanation
Solution
The correct option is (B) : (A)-(IV), (B)-(III), (C)-(II), (D)-(I)