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....

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

676

---

Explain the difference in execution of triggers and stored procedures?

559

---

How many types of primary keys are there?

517

---

What do you mean by table in sql?

516

---

Could you please provide oca (oracle 10g) dumps for my certification ?

4498

---

---

What is substitution variable?

565

---

What is the maximum rows in csv?

479

---

What is compute?

550

---

What is the most common sql injection tool?

535

---

What are all ddl commands?

540

---

What is pl sql and why it is used for?

561

---

Can we enter data in a table in design view?

512

---

What does cursor do in sql?

512

---

Why is partition used in sql?

537

---

What is the use of double ampersand (&&) in sql queries? Give an example

598

---