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 modify a column in sql?

977

---

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

1167

---

what is a control file ? : Sql dba

1022

---

What are the types of records?

981

---

What do you mean by table in sql?

977

---

What will you get by the cursor attribute sql%notfound?

1042

---

What is clustered index in sql?

1040

---

Explain isolation levels. : Transact sql

1050

---

What is union?

1143

---

what tools available for managing mysql server? : Sql dba

1066

---

how tsql statements can be written and submitted to the database engine? : Transact sql

967

---

how to include numeric values in sql statements? : Sql dba

1086

---

Which one is better subquery or joins?

1042

---

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

950

---

Which data type is a composite type?

976

---