Answer Posted / thiyagarajan

We cant rename a column in 8i.but in 9i we can do.
thse datatype of large object in oracle 8i is long but in
9i.it is LOB(large objects)

What is sql*plus?

1019

---

What is nosql db?

926

---

What is procedure explain with program?

952

---

How do you modify a trigger?

876

---

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2172

---

Can a composite key be null?

912

---

what are the join types in tsql? : Transact sql

983

---

What is difference between inner join and cross join?

912

---

How can you get sql*loader to commit only at the end of the load file? : aql loader

967

---

What is a sql schema used for?

1031

---

What is bulk collect in pl sql?

1021

---

How can you fetch common records from two tables?

1004

---

what is a trigger in mysql? Define different types of trigger. : Sql dba

1012

---

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

1074

---

What is foreign key in sql with example?

892

---