Answer Posted / thanigesan.m

view is a virtual table that doesn't exist in rdbms,it is
associated with the SELECT statement materialized is also same
like the view but it exist in rdbms.
we use materialized view
e.g if we r having a table with 4 columns
empno ename sal comm
33 xxxy 1000 234
we can create a materialized view as totalsal by sum that 2
columns....

Does inner join remove duplicates?

930

---

What is percent sign in sql?

1265

---

Mention what is the plv (pl/vision) package offers?

1091

---

What is the use of non clustered index?

977

---

What is a null value?

1125

---

Are subqueries better than joins?

957

---

What are the types of keys?

981

---

How can I make sql query run faster?

996

---

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1166

---

What is bulk compiling in pl/sql.?

1109

---

what are date and time functions in mysql? : Sql dba

964

---

In a distributed database system, can we execute two queries simultaneously?

1060

---

Explain raise_application_error.

1077

---

How do you clear the screen in sql?

1053

---

What is the purpose of my sql?

937

---