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.

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

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

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.

Answer / aarthigha

data abstraction
data models
instance and schemas
definition languages

How do I check my drivers?

0 Answers  

---

What is second normal form?

0 Answers  

---

I have 2 tables with 1 million rows each. I have updated 1 row in first and 1 million update on second table. Now I commit both the updates. Which one will commit fast and Why?

0 Answers  

---

What is tuple in rdbms?

0 Answers  

---

How many columns are in a database table?

0 Answers  

---

---

What is the license for clipper?

0 Answers  

---

Define entity set.

0 Answers  

---

what is database

2 Answers   IBM,

---

What is database host?

0 Answers  

---

Write a query to create a duplicate table with and without data present?

0 Answers  

---

Is it possible to determine clients ip address?

0 Answers  

---

How to drop all foreign keys in database?

0 Answers  

---