Question
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?
More IT DBMS Questions
- A 'Dependent' entity (e.g., an employee's dependents) has no standalone primary key and always depends on 'Employee' for identification. When converting th...
- Given a table Employees(EmpID, ManagerID, Salary), which SQL statement correctly returns the EmpID of every employee who earns strictly more than their dir...
- A designer wants to remove a transitive dependency of a non-key attribute on a candidate key. Which normal form directly addresses this?
- Which type of join returns all rows from the left table and matching rows from the right table?
- An ER diagram has entity sets A, B and C. A and B are related by a 1:N relationship (B on the N side, with total participation of B), and B and C are relat...
- Which of the following schedules is serializable?
- Which SQL command is used to remove a table from the database?
- In relational algebra, the operation that combines tuples from two relations using common attribute values is:
- A transaction either executes all of its operations completely, or none of its operations take effect at all, leaving the database unchanged if any part of...
- Which SQL command permanently removes a table's entire structure along with all of its data from the database?
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)