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 sqlcommand?

0 Answers  

---

Can we use distinct and group by together?

0 Answers  

---

How many sql databases can you have on one server?

0 Answers  

---

What does sign mean sql?

0 Answers  

---

4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;

1 Answers   Fintellix,

---

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

0 Answers  

---

What is constant in pl sql?

0 Answers  

---

what are the differences between binary and varbinary? : Sql dba

0 Answers  

---

How many sql core licenses do I need?

0 Answers  

---

How do I install microsoft sql?

0 Answers  

---

what is a materialized view? : Sql dba

0 Answers  

---

Name three sql operations that perform a sort.

0 Answers  

---