Answer Posted / nivedita

view is a virtual table.view does not contain any data
while material view has its own data.material views are the
local copies of remote data.

What is sql trigger example?

543

---

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

607

---

How do you write a complex sql query?

589

---

How to create a menu in sqlplus or pl/sql?

613

---

What is the current version of sql?

540

---

---

Can a trigger call a stored procedure?

539

---

What are operators available in sql?

590

---

what is log shipping? : Sql dba

613

---

How do I create a sql database?

526

---

What is schema in sql example?

599

---

What is pl/sql language case sensitive?

635

---

Why use triggers in sql?

505

---

What do you understand by case manipulation functions?

547

---

Which is better join or subquery?

608

---

how to shut down the server with 'mysqladmin'? : Sql dba

549

---