Answer Posted / banti

Jyothsna,

you are correct too.

Regards,
Bunty

Does group by remove duplicates?

658

---

Can we rollback truncate?

619

---

Can instead of triggers be used to fire once for each statement on a view?

623

---

how to add a new column to an existing table in mysql? : Sql dba

677

---

What is difference between hql and sql?

594

---

---

What is the difference between local and global temporary table?

649

---

What is a record in a database?

660

---

what is oltp (online transaction processing)? : Sql dba

631

---

Is not null in sql?

646

---

Does sql backup shrink transaction log?

645

---

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?

762

---

What are the advantages of sql?

671

---

How do you optimize a stored procedure in sql?

582

---

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

670

---

What is the usage of nvl function?

690

---