Answer Posted / ravi

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

What is query syntax?

980

---

What are sql functions? Describe the different types of sql functions?

1150

---

Why is sql*loader direct path so fast?

1112

---

Is sql a programming?

982

---

What is indexing in sql and its types?

1089

---

Is subquery faster than join?

1019

---

What is a data manipulation language?

1029

---

What is flag in sql?

1040

---

what are the nonstandard string types? : Sql dba

1148

---

What does over partition by mean in sql?

989

---

What is sql analyzer?

1027

---

What is the difference between unique and primary key constraints?

1081

---

What does (+) mean in sql joins?

1073

---

Why truncate is used in sql?

1012

---

How do I view tables in sql developer?

960

---