Question Discussion & Solution

MCQ

SQL view is said to be updatable (that is, inserts, updates or deletes can be applied on the view) if which of the following conditions are satisfied by the query defining the view?

The from clause has only one database relation

The query does not have a group by or having clause

The select clause contains only attribute names of the relation and does not have any expressions, aggregates, or distinct specification

All of the mentioned

Community Discussion

No discussions yet. Be the first to start!

You must be logged in to participate in the discussion.

Banking

Engineering

General

Medical

Question Discussion & Solution

Report Error

Community Discussion

Similar Questions

Report Error

Report Error

Report Error

Report Error

Report Error

More Database Management System Topics

Miscellaneous or General

Relational Algebra

Database Systems

Data Models

The Relational Database Model

Entity Relationship (ER) Modeling

Advanced Data Modeling

Normalization

Structured Query Language (SQL)

Advanced SQL

Database Design

Transaction and Concurrency

Data Warehouses

Database Administration

Mixed

Banking

Engineering

General

Medical

Question Discussion & Solution

report Report Error

forum Community Discussion

auto_awesome Similar Questions

report Report Error

report Report Error

report Report Error

report Report Error

report Report Error

category More Database Management System Topics

Miscellaneous or General

Relational Algebra

Database Systems

Data Models

The Relational Database Model

Entity Relationship (ER) Modeling

Advanced Data Modeling

Normalization

Structured Query Language (SQL)

Advanced SQL

Database Design

Transaction and Concurrency

Data Warehouses

Database Administration

Mixed

Report Error

Community Discussion

Similar Questions

Report Error

Report Error

Report Error

Report Error

Report Error

More Database Management System Topics