Question
A relation Employee(EmpID, Skill, Language) records that an employee can have multiple independent skills and can speak multiple independent languages, with no relationship between which specific skill pairs with which specific language. If every Skill-Language combination for each employee is stored as a separate row, which normal form is violated?
More IT DBMS Questions
- A relational database management system needs to store millions of employee records on disk and support fast search, insertion, deletion, and range queries...
- 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?
- MVCC (Multi-Version Concurrency Control) ensures:
- A relation R(A, B, C, D) has the composite candidate key {A, B}, and the functional dependencies AB→C and C→D hold, where C fully depends on the entire key...
- Which type of relationship exists when a record in one table can relate to multiple records in another table, and vice versa?
- In a database with a foreign key constraint defined using "ON DELETE CASCADE," what happens when a row in the parent (referenced) table is deleted?
- Given the following Python-like code snippet: ```python class Counter: def __init__(self): self.count = 0 def in...
- Which of the following is not part of the process control block (PCB)?
- Which SQL command removes all rows from a table quickly while preserving the table's structure for future use?
- Which SQL keyword is used to combine the result sets of two or more SELECT statements, automatically removing duplicate rows from the combined result?
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)