Question

A view is created by joining two tables using an INNER JOIN and includes a GROUP BY with an aggregate function. Which statement about this view is correct?

Q: Answer-A view is created by joining two tables using an INNER JOIN and includes a GROUP BY with an aggregat...

Updatable views require a clear, unambiguous mapping from each view row back to exactly one base table row. GROUP BY and aggregate functions collapse multiple base rows into one summarized row, breaking that mapping, so such views are inherently non-updatable unless an INSTEAD OF trigger is explicitly defined to handle it.

A The view is fully updatable since views always inherit update privileges from base tables regardless of their definition

B The view becomes updatable automatically if an INSTEAD OF trigger is never defined

C Views with joins and aggregates are always materialized and hence trivially updatable

D The view is not updatable because it contains aggregate functions and GROUP BY

E The view is updatable only for DELETE operations, not INSERT or UPDATE

Practice Next

More IT DBMS Questions

What will be the value of `x` after the following pseudo-code execution? ``` x = 0 data = [10, 20, 30] for item in data: if item ...
During transaction before commit which of the following statements is done automatically in case of shutdown?
Which of these ensures referential integrity?
In the context of debugging an Object-Oriented program, what does "stepping over" a method call typically do in a debugger?
A data warehouse is primarily characterized by which of the following properties?
Which SQL clause is used to group rows based on one or more columns?
A B-tree index has an order of 100 (up to 100 children per node) and stores 1,000,000 records. Approximately what is the height of this B-tree?
Which normal form eliminates transitive dependencies?
In a relational schema, which normal form eliminates transitive dependencies (i.e., non-prime attribute depends on another non-prime attribute)?
In SQL, which clause is used to filter groups of rows after aggregate functions (such as SUM, COUNT, or AVG) have been applied?

Hey! Ask a query

🎓

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)

Download Now 100% Free PDF

A view is created by joining two tables using an INNER JOIN and includes a GROUP BY with an aggregate function. Which statement about this view is correct?

Detailed Solution

More IT DBMS Questions

Hey! Ask a query

Please Register/Login

RBI Grade B 2026 Phase 1 Memory Based Paper