Answer Posted / ravi

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

What is error ora-01000: maximum open cursors exceeded

604

---

Is sql port 1433 encrypted?

578

---

What is union and union all keyword in sql?

568

---

what are the differences among rownum, rank and dense_rank? : Sql dba

540

---

Why plvtab is considered as the easiest way to access the pl/sql table?

621

---

---

What is raw datatype in sql?

558

---

What is duration in sql profiler trace?

556

---

Explain what is rdbms?

584

---

What is the command used to fetch the first 5 characters of a string?

710

---

What is a database event trigger?

597

---

Can we call dml statement in function?

542

---

Define concurrency control. : Transact sql

587

---

Can we use ddl statements in stored procedure sql server?

520

---

Is sqlite good enough for production?

535

---

Can we perform dml in function?

598

---