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.

Can a table have no primary key?

0 Answers  

---

What does rownum mean in sql?

0 Answers  

---

Differentiate pl/sql and sql?

0 Answers  

---

Is left join faster than inner join?

0 Answers  

---

.  have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement. CUST         ACC a            dv b            fg b            bh c            mk c            cl c            so result:- A  B   c dv fg mk    bh cl       so

3 Answers  

---

---

Are stored procedures faster than dynamic sql?

0 Answers  

---

how to shutdown mysql server? : Sql dba

0 Answers  

---

how view used for security purposes?

3 Answers   Glam India,

---

Mention what problem one might face while writing log information to a data-base table in pl/sql?

0 Answers  

---

What is the use of prepared statement?

0 Answers  

---

What is meant by temporal data?

0 Answers  

---

Can we use loop in sql?

0 Answers  

---