Answer / raj

it locks the header #SCN number of the datafiles and
datafiles will be updated continuously.
If the db is coming out from begin backup mode it updates
the header #SCN number.

Answer / kittu_chintu2005

It freezes the entire database and it won’t take any transaction to datafile then excessive redologs generates.

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers   Oracle,

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  

---

What is blocking and how would you troubleshoot it?

1 Answers  

---

Datapump backup steps?

1 Answers  

---

Explain about your sql server dba experience? : sql server DBA

0 Answers  

---

---

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 Answers  

---

What command would you use to encrypt a PL/SQL application?

1 Answers  

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers   Patni,

---

what is rebuild index??

2 Answers   IBM, Sapient,

---

What are the different ways you can create databases in sql server? : sql server DBA

0 Answers  

---

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers  

---