Answer Posted / ravi

constraints are two types
1.Rule based constraint
2.cost based constraint

What is execution plan in sql?

1092

---

how to extract a unit value from a date and time? : Sql dba

1040

---

what is the difference between nested subquery and correlated subquery?

1093

---

Name the different types of indexes in sql and define them.

1223

---

define data blocks ? : Sql dba

1047

---

How much ram can sql express use?

1041

---

What is loop in pl sql?

1078

---

Is like operator in sql case sensitive?

1077

---

What is package in pl sql with an examples?

1087

---

Why do we need cursor in pl sql?

1187

---

What is sql trigger example?

1115

---

Can we join 3 tables in sql?

1108

---

How many sql core licenses do I need?

995

---

What is plpgsql language?

1142

---

What is file based approach?

1000

---