Answer Posted / mani

5 types of locks in database
intent
shared
schema
update
bulk update

What is a ddl command?

1069

---

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

985

---

What are the two types of periodical indexes?

925

---

Which sql statement is used to delete data from a database?

940

---

What is linq to sql?

1120

---

what is table? : Sql dba

1041

---

Which one is better subquery or joins?

1039

---

What is the difference between delete and truncate commands?

1020

---

Explian rowid, rownum? What are the psoducolumns we have?

986

---

How many types of cursors supported in pl/sql?

1159

---

Explain alias in sql?

1027

---

Which is better join or inner query?

1019

---

How do I save the results of sql query in a file?

963

---

Can we create table inside stored procedure?

939

---

what is uncommittable transactions? : Transact sql

987

---