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 a record in a database?

0 Answers  

---

Is like operator in sql case sensitive?

0 Answers  

---

Why plvtab is considered as the easiest way to access the pl/sql table?

0 Answers  

---

Give the structure of the function ?

2 Answers  

---

What are sql procedures?

0 Answers  

---

I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.

4 Answers   GE,

---

how to create temparary sequence

2 Answers   TCS,

---

what is the use of double ampersand (&&) in sql queries?

0 Answers  

---

How to execute multiple sql statements in a single annonymous block irrespective of the sql statement result?

2 Answers  

---

What are functions in sql?

0 Answers  

---

What is dcl in sql?

0 Answers  

---

What is the difference between SQL table and the PLSQL table?

3 Answers   Mastek,

---