Answer / ashokram s

Using view you can restrict the data and thus granting privilege on the view instead of base table can ensure security that all data cant be accessible by a particular user

Answer / madhusudhan.madireddy

limit access and view to required fields only

Answer / santosh kumar

Hi,

Advantages of views:

1. View the data without storing the data into the object.

2. Restict the view of a table i.e. can hide some of columns in the tables.

3. Join two or more tables and show it as one object to user.

4. Restict the access of a table so that nobody can insert the rows into the table.

Disadvatages:

1. Can not use DML operations on this.

2. When table is dropped view becomes inactive.. it depends on the table objects.

3. It is an object, so it occupies space.

What is the difference between jpql and sql?

0 Answers  

---

What is a full join sql?

0 Answers  

---

What are the query optimization techniques?

0 Answers  

---

What is referential integrity ?

3 Answers   BirlaSoft,

---

What is sql prepared statement?

0 Answers  

---

Explain what is a column in a table?

0 Answers  

---

Does truncate free space?

0 Answers  

---

Explain the PL/SQL compilation process.

3 Answers  

---

How will you make performance better for application including front end and back

2 Answers   Metric Stream,

---

What can I use instead of union in sql?

0 Answers  

---

How many rows will return from dual table?

4 Answers   Fujitsu,

---

does sql support programming? : Sql dba

0 Answers  

---