Answer / daid kumar

In The case of Very large transaction oracle gives the
Error:-ORA-01555 "snapshot too old"
in this case we have to increase the size of lback segment
and we can assign particular one segment for that
transaction.
before transaction we write
SET TRANSACTION USE ROLLBACK SEGMENT <seg name>

Describe a subquery.

0 Answers  

---

What is dbms language?

0 Answers  

---

What are the the different Data Manipulation Language statements are?

2 Answers  

---

How does index hunting help in improving query performance?

0 Answers  

---

In which format image is stored in database?

0 Answers  

---

---

What does rdbms stand for?

0 Answers  

---

Whats is an OLTP Database

0 Answers   Microsoft,

---

Explain the necessary techniques to control deadlocks?

0 Answers  

---

Define sub-query.

0 Answers  

---

explain about the critical recovery scenario you had experienced

0 Answers  

---

What are the types of distributed database?

0 Answers  

---

describe and contrast a trigger and a procedure.

0 Answers  

---