Question
In SQL, which clause is used to filter groups of rows after aggregate functions (such as SUM, COUNT, or AV
- G have been applied?
More IT DBMS Questions
- In an Object-Oriented program, which control flow construct is primarily used to handle unexpected events or errors that occur during program execution, su...
- In a relational schema, which normal form eliminates transitive dependencies (i.e., non-prime attribute depends on another non-prime attribute)?
- Which of the following correctly describes a 'primary key' in a relational database?
- Which type of SQL JOIN returns all records from both tables, filling unmatched fields with NULL?
- Which query correctly finds department IDs where the average salary exceeds the overall average salary across all employees?
- A designer wants to remove a transitive dependency of a non-key attribute on a candidate key. Which normal form directly addresses this?
- Which of the following is used to remove all records from a table without removing the table structure?
- Which join should be used when you want to list all customers and any orders they may have placed, including customers who haven’t placed any orders?
- Which type of join returns only matching records from both tables?
- A relation R(P, Q, R, S) has functional dependencies PQ -> R, R -> S, and S -> P. How many candidate keys does this relation have?
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)