Answer Posted / tulsi

Primary key will avoid duplicate and null values in a table
which the combination of unique+not null will do.But the
advantage is,if a table has primary key we can create
relation to child tables.

what is collation? : Sql dba

617

---

Is sql procedural language?

554

---

Explain ddl statements in pl/sql?

579

---

What are the differences between in and exists clause?

571

---

What is cursor in pl sql?

580

---

---

what is rdbms? : Sql dba

583

---

What is pls_integer in pl sql?

541

---

what is the difference between clustered and non clustered index in sql? : Sql dba

552

---

What is pragma in pl sql?

602

---

What are records give examples?

566

---

what is data control language? : Sql dba

588

---

what is try_catch block in procedure

1194

---

Where do we use pl sql?

555

---

which tcp/ip port does sql server run on? : Sql dba

519

---

what are wild cards used in database for pattern matching ? : Sql dba

552

---