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 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  

---

one datafile is lost in standy side how can you recover that??

2 Answers  

---

1)how to Take Backup in sql server 2005 from Flash Drive

1 Answers  

---

How do you open a cluster administrator? : sql server DBA

0 Answers  

---

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 view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers  

---

How would you determine the time zone under which a database was operating?

2 Answers  

---

Hot backup procedure?

2 Answers  

---

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?

0 Answers  

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers  

---

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers   Cognizant,

---

how can you get actual data change values from previous transactions in oracle?

0 Answers   Oracle,

---