What do you understand by a view, Database Management System

What do you understand by a view? What does WITH CHECK OPTION clause for a view do?

- A view is a virtual table which comprises fields from one or more real tables.

- It is generally used to join multiple tables and get the data.

- WITH CHECK OPTION for a view prevents any modification to the data that doesn't confirm to WHERE clause of the view definition.

- This allows data belonging to the view to be updated through view.

Related Discussions:- What do you understand by a view

Production management, create an er diagram for production management in fi...

create an er diagram for production management in film industry

Human resource management system, cardnality ratio for humanresource mange...

cardnality ratio for humanresource mangement system

Illustrate the state model for the atm class, Illustrate the State model fo...

Illustrate the State model for the ATM class let us take state model for the ATM class given below in Figure showing state model of the ATM class and the pseudo code derived fr

Memory components of sga, Problem 1. Describe the Oracle Architecture w...

Problem 1. Describe the Oracle Architecture with a neat labeled diagram, Also explain the individual components of the Architecture. 2. Write about the following Oracle 9i o

What is an entity relationship model, What is an entity relationship model?...

What is an entity relationship model? The entity relationship model is a collection of basic objects known as entities and relationship between those objects. An

Define page, Define page. The database is partitioned into some number ...

Define page. The database is partitioned into some number of fixed-length blocks, which are referred to as pages.

NORRMALIZATION, Home based assignment Consider an ORDER table with the foll...

Home based assignment Consider an ORDER table with the following attributes: • Order Number (ONo),Customer Number (CNo),Customer Name (CNa),Item Number (INo),Unit Price (UP), Quant

Explain retrieval in qbe, Explain retrieval in QBE? Retrieval in QBE : ...

Explain retrieval in QBE? Retrieval in QBE : A "GUI" for expressing queries. Based on the Domain Relational Calculus (DRC) Actually invented before GUIs. Very co

Data manipulation language, Question 1 Discuss about second normal form an...

Question 1 Discuss about second normal form and third normal form Question 2 Write short note on 1) Data Manipulation Language 2) Data Definition La

Primary interface between a visual basic application, Question (a) Visu...

Question (a) Visual Basic is governed by an event processor. Explain the meaning of this phrase. (b) Differentiate between an general procedure and event procedure. (c)

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages