Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

If we issue alter database begin backup. What happens to database?

Question Posted / kittu_chintu2005

Answers were Sorted based on User's Feedback



If we issue alter database begin backup. What happens to database?..

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.

Is This Answer Correct ?    16 Yes 1 No

If we issue alter database begin backup. What happens to database?..

Answer / kittu_chintu2005

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

Is This Answer Correct ?    5 Yes 2 No

Post New Answer

More DB Administration Interview Questions

suppose you want to audit specific activities on sensitive data. How can you achieve that?

0 Answers   Oracle,

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

0 Answers  

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

0 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

0 Answers  

How would you force a log switch?

4 Answers  

I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1 Answers  

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

0 Answers   Oracle,

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,

What are the recovery models for a database? : sql server DBA

0 Answers  

How does Oracle guarantee data integrity of data changes?

1 Answers   SoftSol,

What is the difference between online backup & offline backup?

3 Answers   CSC,

How to make a replica of existing oracle server to another server?

3 Answers  

For more DB Administration Interview Questions Click Here
Categories