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
- In the context of database transactions, which isolation level allows "non-repeatable reads" but prevents "dirty reads"?
- Which property of a transaction ensures that either all operations within the transaction are completed successfully, or none of them are?
- Phantom Reads occur when:
- Transaction T1 updates a row but has not yet committed. Transaction T2 reads this same row's uncommitted new value. T1 then rolls back, meaning T2 has read...
- Which of the following SQL queries would return the total number of employees in each department, but only for departments with more than 10 employees?
- Given the `SinglyLinkedList` and its `delete_node` method as provided, what will be the output of `my_list.print_list()` after the following sequence of op...
- Which type of SQL JOIN returns all rows from both tables involved, placing NULLs in columns where there is no matching row on the other side?
- A B+ tree index is built on an attribute used mainly for range queries. Why is a B+ tree generally preferable to a hash index for this workload?
- A transaction T1 updates a row and then waits for a lock held by T2. T2 is waiting for a lock held by T1. What condition has occurred?
- In a relational schema, which normal form eliminates transitive dependencies (i.e., non-prime attribute depends on another non-prime attribute)?
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)