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.

List and explain the different types of join clauses supported in ansi-standard sql?

0 Answers  

---

What is difference between inner join and cross join?

0 Answers  

---

Can you sum a count in sql?

0 Answers  

---

Difference between truncate, delete and drop commands?

0 Answers  

---

Display the total debit counts, total credit counts, sum of total debits, sum of total credits from an employee's transaction table (a single table) containing the following columns. Transaction_number Transaction_amount Transaction_date Transaction_type --> tells if the amount is a credit or a debit. As the query alone is important, the table is left with specifying just the field's name. Pls help me with this query.

3 Answers   iNautix, Oracle,

---

Whate is use of MOD function in pl/sql.

3 Answers   Oracle,

---

What is count * in sql?

0 Answers  

---

I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.

4 Answers   Cap Gemini, MTS,

---

write a procedure to find top second no from a list of numbers

1 Answers   ABC,

---

What does 0 mean in sql?

0 Answers  

---

What is an Integrity Constraint?

4 Answers  

---

What is the example of procedure?

0 Answers  

---