Answer / rajkumar

please don't give oracle answers in sqlserver

Answer / leena

clustered index physically store data orderly in a
table,but non-clustered index store data logically not
physically.
primary key is by default clustered index,and unique key is
by default non-clustered index.
A table can contain only one cluster index.

Answer / amit

A clustered index are those which created by user manually
and non clustered are automatically created by oracle server
when we create a primary key or a unique key on a column.

and as many as indexes can be created on table but it will
reduces the performance of the database.

What is cursor and why it is required?

0 Answers  

---

What are the two virtual tables available at the time of database trigger execution?

0 Answers  

---

What does trigger mean in psychology?

0 Answers  

---

can we call a procedure into another procedure?If yes means how you can pass the perameters for the two procedures?

2 Answers   Fujitsu,

---

How do I run a sql script?

0 Answers  

---

What is Data Concarency and Consistency?

1 Answers  

---

How do you declare a constant?

0 Answers  

---

Can primary key be changed?

0 Answers  

---

if a string is there like s1,s2,s3,s4.How to find count of commas in this.

4 Answers  

---

Which sql statement is used to return only different values?

0 Answers  

---

What is using in sql?

0 Answers  

---

Can a trigger call a stored procedure?

0 Answers  

---