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 |
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 |
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 |
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 |