Answer Posted / guest

explicit cursor

Does truncate require commit?

638

---

what is transaction? : Sql dba

613

---

What are the types of queries in sql?

626

---

Enlist some predefined exceptions?

693

---

what is data integrity? : Sql dba

679

---

---

What are pl/sql packages?

647

---

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

667

---

give the syntax of grant and revoke commands? : Sql dba

707

---

Can we use joins in subquery?

659

---

What is a record in pl/sql?

655

---

Define join and name different types of joins?

621

---

What is the meaning of disabling a trigger?

724

---

In a distributed database system, can we execute two queries simultaneously?

658

---

What is transaction control language (tcl)?

747

---

How does sql store data?

568

---