Answer / thanga prabu.n

Unique Key creates Non-Cluster index in default,
But in Primary Key creates Cluster index in default

Answer / swapna

The concept of adding an unique key and not null constraint
to a column as well as adding as unique index to it , you
will assume to get the benefits of adding an primary key
to that column.

But use it for the purpose of referential integrity will
not allow to do so.

That's what PK is so useful. You will use it for
normalization purpose.

what are the tunnig tables you used for tuning a query and tell me some of coloumns in that tuning tables?

1 Answers   Metric Stream,

---

How many columns should be in an index?

0 Answers  

---

what are the different type of normalization? : Sql dba

0 Answers  

---

What is the difference between nvl function, ifnull function, and isnull function?

0 Answers  

---

i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87964579,156678,678900876) that means if i select phone no from table i want to get total count of phone numbers i.e 6

8 Answers   Satyam,

---

Define the select into statement.

0 Answers  

---

What is a field in a database?

0 Answers  

---

How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,

---

what is difference between decode and case function?

2 Answers  

---

what is msql? : Sql dba

0 Answers  

---

How is sql used in oracle?

0 Answers  

---

How will you distinguish a global variable with a local variable in pl/sql?

0 Answers  

---