Question

Updating the value of the view

a.

Will affect the relation from which it is defined

b.

Will not change the view definition

c.

Will not affect the relation from which it is defined

d.

Cannot determine

Posted under DBMS

Answer: (a).Will affect the relation from which it is defined

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Updating the value of the view

Add Comment

Similar Questions

Discover Related MCQs

Q. 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?

View solution

Q. Which of the following is used at the end of the view to reject the tuples which do not satisfy the condition in where clause ?

View solution

Q. A relational database system needs to maintain data about the relations, such as the schema of the relations. This is called

View solution

Q. Relational schema and other metadata about relations are stored in a structure called the ____________ .

View solution

Q. ___________ is the collection of memory structures and Oracle background processes that operates against an Oracle database.

View solution

Q. A ________ is a logical grouping of database objects, usually to facilitate security, performance, or the availability of database objects such as tables and indexes.

View solution

Q. A tablespace is further broken down into ________

View solution

Q. __________ is a contiguous group of blocks allocated for use as part of a table, index, and so forth.

View solution

Q. ________ is the smallest unit of allocation in an Oracle database.

View solution

Q. DML is provided for

View solution

Q. The language used in application programs to request data from the DBMS is referred to as the

View solution

Q. The way a particular application views the data from the database that the application uses is a

View solution

Q. The DBMS language component which can be embedded in a program is

View solution

Q. A DBMS query language is designed to

View solution

Q. The full form of DDL is

View solution

Q. DDL Stands for ___________.

View solution

Q. DML Stands for _____________.

View solution

Q. Which of the following language is used to specify database Schema ?

View solution

Q. Set of definitions that are used to specify schema are expressed using __________.

View solution

Q. Result of Compilation of DDL statement is stored in special file called as _________.

View solution

View All MCQs on DBMS

Suggested Topics

Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

UNIX

Become proficient with the Unix operating system using our UNIX MCQs. Learn about...

Python

Dive into one of the most popular languages with our Python MCQs. Understand...

Object Oriented Programming Using C++

Enhance your programming skills with our MCQs on Object Oriented Programming using...

MySQL Database

Enhance your knowledge of relational databases with our MySQL MCQs. Understand...

Systems Analysis and Design Methods

Get familiar with the process of designing and improving business systems with our...

Object Oriented Programming

Enhance your coding skills with our Object Oriented Programming MCQs. Understand...

Hadoop

Dive into the world of big data with our Hadoop MCQs. Cover key concepts including...

MS Office

Master the suite of productivity tools with our MS Office MCQs. From Word and Excel...

Java Spring Framework

Enhance your Java development skills with our Spring Framework MCQs. Learn about...