Answer Posted / udaykumar

view is a virtual memory.it doesn't contain the data but it
has a structure.
simple
complex
materialized
snapshot
force
inline
parametric

how to rename an existing table in mysql? : Sql dba

577

---

What is pl/sql table? Why is it used?

561

---

What is the difference between Union and Union all. Which is faster.

844

---

What is data types in sql?

537

---

What is a data manipulation language?

573

---

---

Define concurrency control. : Transact sql

587

---

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

595

---

what is an alias command? : Sql dba

550

---

What information is needed to connect sql*plus an oracle server?

590

---

what is 'mysqldump'? : Sql dba

573

---

Can we use the cursor's to create the collection in PL/SQL?

522

---

What is a record in pl/sql?

551

---

what is a view? : Sql dba

638

---

what is the difference between where clause and having clause? : Sql dba

543

---

what is a unique key ? : Sql dba

547

---