Solveeit Logo

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)