Answer / gogune suresh kumar

All data changes to the database are stored in redo-log
buffers.

Explain the concept of the DUAL table.

3 Answers  

---

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  

---

What are statistics, under what circumstances they go out of date, how do you update them?

1 Answers  

---

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

1 Answers  

---

Hot backup procedure?

2 Answers  

---

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1 Answers  

---

What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,

---

How would you determine what sessions are connected and what resources they are waiting for?

2 Answers  

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers  

---

how can you create a user-defined lock?

1 Answers   Oracle,

---

how to restore files with rman?

1 Answers  

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

1 Answers  

---