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 Data Storage and Querying 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 Data Storage and Querying

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!

Cloud Computing

Stay on top of the biggest trend in IT with our Cloud Computing MCQs. These questions...

Discrete Mathematics

Refine your mathematical skills essential for computer science with our Discrete...

HTML

Start your journey in web development with our HTML MCQs. Learn the building blocks...

Systems Programming

Decode low-level programming with our Systems Programming MCQs. These questions delve...

MongoDB

Learn the leading NoSQL database with our MongoDB MCQs. Understand everything from...

Cryptography and Network Security

Secure your knowledge of information security with our Cryptography and Network...

CSS

Polish your web design skills with our CSS MCQs. Learn about selectors, properties,...

UNIX

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

PHP

Venture into server-side scripting with our PHP MCQs. Cover everything from syntax...