Question
A relation is decomposed into R1(A,
- B and R2(B,
- C . Which condition guarantees a lossless join for a binary decomposition?
More IT DBMS Questions
- What does the SQL COMMIT statement do?
- Which of the following is NOT a type of database model?
- In a relational schema, which normal form eliminates transitive dependencies (i.e., non-prime attribute depends on another non-prime attribute)?
- What is a 'foreign key' in a relational database?
- Which normal form ensures a table has no transitive dependency between its non-key attributes?
- Which type of join returns only matching records from both tables?
- 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?
- Deadlock occurs when:
- Given a table Employees(EmpID, ManagerID, Salary), which SQL statement correctly returns the EmpID of every employee who earns strictly more than their dir...
- What is a 'transaction' in DBMS and what does 'COMMIT' do?
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)