Explain different types of Views ?

Categories >> Software >> Databases >> Database Management
Suggest New Category

Question Posted / guest

5 Answers
36579 Views
HCL, Inbound Solutions, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Explain different types of Views ?..

Answer / 9742108000(venu gopal reddy)

The views are Mainly 2 types .
1-> SIMPLE VIEW
2-> COMPLEX VIEW

Simple view:
- It is created by selecting only one table.
- It does not contains functions.
- it can perform DML (SELECT,INSERT,UPDATE,DELETE,MERGE, CALL,LOCK TABLE) operations through simple view.
Complex view :

-It is created by selecting more than one table.
-It can performs functions.
-You can not perform always DML operations through Complex views.

Is This Answer Correct ?

22 Yes

2 No

Explain different types of Views ?..

Answer / vivekanand

basically there are five type of view
1-simple view
2-complex view
3-read only view
4-check option view
5-force view

Is This Answer Correct ?

16 Yes

11 No

Explain different types of Views ?..

Answer / sweta

There are two types of view-
1.Simple view(does not contain function, only one table exists,allow DML operation)
2.Complex View (Allow function,multiple table,did not allow DML operations all time)

Attributes of view --
1.with check option
2.read only
3.Force|Noforce

Is This Answer Correct ?

6 Yes

4 No

Explain different types of Views ?..

Answer / kishan j vasoya

There are two types of view.
1. Read only view:
which is created by using more then one table.

2. Updatable view:
Which is created by using one table so it's updatable.

Is This Answer Correct ?

0 Yes

1 No

Explain different types of Views ?..

Answer / aarthigha

data abstraction
data models
instance and schemas
definition languages

Is This Answer Correct ?

12 Yes

20 No

Post New Answer

More Database Management Interview Questions

What are the types of database?

0 Answers

What is database implementation?

0 Answers

IF Statements BLOCK 1 . IF a >= b THEN do_this …..; ELSE do_that….; END IF BLOCK 2 . IF a < b THEN do_that …..; ELSE do_this….; END IF; • Given any pair of non-NULL values for “a” and”b”, will Block 1 and Block 2 do the same thing? • What if either “a” or”b” (or both) is NULL?

0 Answers

i want to know real time experience on oracle dba anybody help me please mail me aniltelkar50@gmail.com

1 Answers IBM,

What are the two main functions of queries in databases?

0 Answers

What are the parts of a table?

0 Answers

What is use of dbms?

0 Answers

What is a logical backup ?

3 Answers Wipro,

What is the difference between a MESSAGEBOX and an ALERT ?