Type of views-data control, Database Management System

Type of views:

 Simple views and Difficult Views

Feature

Simple Views

Complex Views

Number of tables

One

One or more

Contain Functions

No

Yes

Contain groups of data

No

Yes

Data Manipulation

IS allowed

Not always

Let us look into some of the examples. To see all the details about existing views in

Oracle:

SELECT* FROM USER_VIEWS;

 

Posted Date: 3/11/2013 1:21:33 AM | Location : United States







Related Discussions:- Type of views-data control, Assignment Help, Ask Question on Type of views-data control, Get Answer, Expert's Help, Type of views-data control Discussions

Write discussion on Type of views-data control
Your posts are moderated
Related Questions
What are the situations while DBMS should not be used? DBMS should not be used in situations like: (i) No need of security. (ii) Not difficulty to access the data (iii) N

Attribute Preservation This is a easy and obvious necessity that includes preserving all the attributes that were there in the relation that is being decomposed.

Explain the structure of well formed formulae in relational calculus. Ans: a. An atom is a formula b. If P1 is a formula, after that so are ¬P1 and (P1) c. If P1 and P2 a

brief history,definition,current trends and future trends if any of data fragmentation

To do the division operation R1 ÷ R2, R2 should be a correct subset of R1. In the following example R1 have attributes A and B and R2 have only attribute B so R2 is a correct subse

Describe the Composite Key Composite Key: Sometimes one key is not enough to uniquely recognize a row. E.g. in a single class Roll is enough to search a student, but in the w

What are the Requirements of algorithm designer Algorithm designer should: i) Select proper algorithm so as to minimize implementation cost ii) Find most appropriate d

What is object containment? References among objects can be used to model dissimilar real-world concepts.

tell me the functionality,advantages and disadvantages of student database

During the deletion of a tuple two cases can happen: Deletion of tuple in relation having the foreign key: In this type of case simply delete the desired tuple. For example, in