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 difference between CHAR and VARCHAR2?What is the maximum SIZE allowed for each type?

6 Answers   Saama Tech,

---

How much does sql cost?

0 Answers  

---

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers   Tech Mahindra,

---

What is the difference between the sql*loader and import utilities? : aql loader

0 Answers  

---

How does left join work in sql?

0 Answers  

---

---

What do you understand by exception handling in pl/sql?

0 Answers  

---

Difference between table function and pipelined function?

0 Answers  

---

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

0 Answers  

---

how to drop an existing view in mysql? : Sql dba

0 Answers  

---

How do you use join?

0 Answers  

---

What do you know by pl/sql cursors?

0 Answers  

---

How to fetch common records from two tables?

1 Answers  

---