Answer Posted / ravin

Yes we can..
Hey guys.. don't be confused with the values and nulls.
Unique key conforms only the values to be unique. Since the
nulls are not any kind of value, they can occur as many
times as they can.. nulls are nothing..

Is sql pronounced sequel or sql?

1340

---

Is primary key clustered index?

993

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

1012

---

What are the steps for performance tuning.

1395

---

Is left join and outer join same?

1118

---

What programs use sql?

1088

---

Why do we create stored procedures & functions in pl/sql and how are they different?

995

---

Can there be more than one function with a similar name in a pl/sql block?

1045

---

What are the events on which a database trigger can be based?

1246

---

Enlist some predefined exceptions?

1115

---

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2553

---

what are string data types? : Sql dba

1093

---

What is primary key and foreign key?

1014

---

what are dynamic queries in t-sql? : Transact sql

1070

---

What are the 3 modes of parameter?

1209

---