GATE (Graduate Aptitude Test in Engineering) Computer Science: Questions 1798 - 1803 of 2080

Access detailed explanations (illustrated with images and videos) to 2080 questions. Access all new questions- tracking exam pattern and syllabus. View the complete topic-wise distribution of questions. Unlimited Access, Unlimited Time, on Unlimited Devices!

View Sample Explanation or View Features.

Rs. 550.00 -OR-

How to register? Already Subscribed?

Question 1798

Appeared in Year: 2019 (UGC-NET)

Question

MCQ▾

Which of the following is not needed by an encryption algorithm used in Cryptography? (December)

Choices

Choice (4)Response

a.

User details

b.

Cipher text

c.

Message

d.

Both b. and a. are correct

Passage

Answer based on the problem statement given below:

An organization needs to maintain database having five attributes . These attributes are functionally dependent on each other which functionally dependency set is given as: . Consider a universal relation with functional dependency set . Also all attributes are simple and take atomic values only.

Question 1799 (1 of 5 Based on Passage)

Appeared in Year: 2019 (UGC-NET)

Question

MCQ▾

Identify the normal form in which relation belongs to (December)

Choices

Choice (4)Response

a.

b.

c.

d.

Question 1800 (2 of 5 Based on Passage)

Appeared in Year: 2019 (UGC-NET)

Question

MCQ▾

Assume that given table is decomposed in two tables

with functional dependency set and

with FD set

Which of the following options is true w. r. t. given decomposition?

(December)

Choices

Choice (4)Response

a.

is in and is in

b.

and are both in

c.

Dependency preservation property is followed

d.

is in and is in

Question 1801 (3 of 5 Based on Passage)

Appeared in Year: 2019 (UGC-NET)

Question

MCQ▾

Minimal cover of functional dependency set is (December)

Choices

Choice (4)Response

a.

b.

c.

d.

Question 1802 (4 of 5 Based on Passage)

Appeared in Year: 2019 (UGC-NET)

Question

MCQ▾

Identify the redundant functional dependency in (December)

Choices

Choice (4)Response

a.

b.

c.

d.

Question 1803 (5 of 5 Based on Passage)

Appeared in Year: 2019 (UGC-NET)

Question

MCQ▾

Identify primary key of table with functional dependency set

Choices

Choice (4)Response

a.

A

b.

c.

d.

Developed by: