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 the largest value that can be stored in a byte data field?

978

---

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1040

---

What is the difference between cluster and non-cluster index?

1071

---

How many types of privileges are available in sql?

1307

---

Can I call a procedure inside a function?

969

---

how can we destroy the session, how can we unset the variable of a session? : Sql dba

958

---

What is sql in oracle?

1022

---

How do I sort a table in sql?

995

---

when is the use of update_statistics command? : Sql dba

996

---

what is the command line end user interface - mysql? : Sql dba

941

---

Does truncate require commit?

932

---

what are the limitations of identity column? : Transact sql

1066

---

How do rank () and dense_rank () differ?

993

---

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1176

---

What are the 3 types of behavioral triggers?

1207

---