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 do you tune the slow running queries in oracle db , explain the methodology

3204

---

Is primary key always clustered index?

1062

---

What is trigger and stored procedure in sql?

1089

---

Can two tables have same primary key?

1018

---

how to install mysql? : Sql dba

1154

---

Explain what is a field in a database and record in a database?

1175

---

What can sql server reporting services do?

1160

---

Can we use having without group by in sql?

1043

---

What is foreign key in sql with example?

973

---

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

1008

---

Is sql database free?

1021

---

How can you load microsoft excel data into oracle? : aql loader

1213

---

In pl/sql, what is bulk binding, and when/how would it help performance?

1030

---

How can one get sql*loader to commit only at the end of the load file? : aql loader

1112

---

What are the different sql languages?

1088

---