Question
Relation R(Student, Course, Hobby) stores every course a student takes and every hobby they have, independently of each other, producing a full cross-product of rows per student (e.g., 2 courses × 3 hobbies = 6 rows). Which normal form is violated, and why?
More IT DBMS Questions
- Two transactions T1 and T2 both follow the Two-Phase Locking (2PL) protocol. T1 acquires an exclusive lock on row A and then requests a lock on row B, whil...
- Transaction T1 holds a lock on Row A and requests a lock on Row B. Transaction T2 holds a lock on Row B and requests a lock on Row A. Both use strict Two-P...
- A table contains 8,000,000 records, and a B+ tree index built on it has a fan-out (branching order) of exactly 200 at each internal node. What is the appro...
- R(StudentID, CourseID) records every course each student has taken. S(CourseID) lists all courses required for a certain certification. Which relational al...
- You have a Python list of fruits and want to extract a specific sub-list using slicing. Complete the missing part of the code to obtain the sub-list `['b...
- Which normal form ensures a table has no transitive dependency between its non-key attributes?
- Which SQL statement is used to remove all rows from a table without logging individual row deletions?
- Which normal form removes partial dependency?
- Relation R(A, B, C) has functional dependencies A→B and B→C, with A as the only candidate key. Is R in BCNF?
- Consider the following Java-like pseudo-code for inserting a node into a Binary Search Tree (BST): ```java class Node { int data; ...
Hey! Ask a query
Please enter email id
The email must be a valid email address.
Please enter Mobile Number
Please enter valid Mobile Number
Please enter your Doubt
Think You're Ready for RBI Grade B?
RBI Grade B 2026 Phase 1 Memory Based Paper
- 200 Questions with Detailed Solutions
- Section-wise Coverage (GA, English, Quant & Reasoning)