Answer / hr@tgksolutions.com

ACID stands for:
• Atomicity – Transactions are all-or-nothing.
• Consistency – Ensures database integrity before and after a transaction.
• Isolation – Ensures transactions don’t interfere with each other.
• Durability – Changes are permanent after a transaction is committed.

WHT ARE THE AGGREATE FUNCTIONS?

7 Answers   GEITC, TCS,

---

How to loop through data rows in the implicit cursor?

1 Answers  

---

Give the constructs of a package, function or a procedure.

1 Answers  

---

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers  

---

Write a trigger example in oracle?

1 Answers  

---

1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.

1 Answers   Wipro,

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

1 Answers  

---

what is primary key and foreign key when and where have to use

5 Answers  

---

Write a syntax for update query in oracle?

1 Answers  

---

What is materialized view in Oracle?

1 Answers   MCN Solutions,

---

What happens if recursive calls get out of control?

1 Answers  

---

How to create a new tablespace in oracle?

1 Answers  

---