Databases-Database Design [GATE (Graduate Aptitude Test in Engineering) Computer Science & IT (CS)]: Questions 35 - 38 of 48

Choose Programs:

🎓 Study Material (1190 Notes): 2024-2025 Syllabus

Rs. 1000.00 -OR-

3 Year Validity (Multiple Devices)

Topic-wise Notes & SampleDetails

🎯 302 Numeric, 2894 MCQs (& PYQs) with Full Explanations (2024-2025 Exam)

Rs. 650.00 -OR-

3 Year Validity (Multiple Devices)

CoverageDetailsSample Explanation

Help me Choose & Register (Watch Video) Already Subscribed?

Question 35

Question MCQ▾

Consider the relation R (ABCDE) together with the functional dependencies:

The highest normal form of the above relation is

Choices

Choice (4)Response

a.

BCNF

b.

3NF

c.

1 NF

d.

2NF

Edit

Question 36

Question MCQ▾

Given the relations employee (name, salary, dept-no) , and department (dept-no, dept-name, address) which of the following queries cannot be expressed using the basic relational algebra operations ()

Choices

Choice (4)Response

a.

Department address of every employee

b.

Employees whose name is the same as their department name

c.

The sum of all employees salaries

d.

All employees of a given department

Edit

Question 37

Appeared in Year: 2015

Question MCQ▾

A file is organized so that the ordering of data records is the same as or close to the ordering of data entries in some index. Then that index is called

Choices

Choice (4)Response

a.

Dense

b.

Clustered

c.

Sparse

d.

Unflustered

Edit

Question 38

Appeared in Year: 2020

Question MCQ▾

Consider a relational table R that is in 3 NF, but not in BCNF. Which one of the following statements is TRUE?

Choices

Choice (4)Response

a.

R has a nontrivial functional dependency X ⇾ A, where X is not a superkey and A is a non-prime attribute and X is not a proper subset of any key

b.

R has a nontrivial functional dependency X ⇾ A, where X is not a superkey and A is a prime attribute

c.

A cell in R holds a set instead of an atomic value

d.

R has a nontrivial functional dependency X ⇾ A, where X is not a superkey and A is a non-prime attribute and X is a proper subset of some key

Edit