Interested to Buy Any Domain ? << Click Here >> for more details...
If we issue alter database begin backup. What happens to database?
- 2 Answers
- 7196 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
how can you implement fine-grained auditing?
What happens on checkpoint? : sql server DBA
how can you create a user-defined lock?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What is the difference between clustered and non-clustered index? : sql server DBA
how can you initialize log miner?
How can you control the amount of free space in your index pages? : sql server DBA
. 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?
How would you go about verifying the network name that the local_listener is currently using?
What is the importance of a recovery model? : sql server DBA
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
Where would you look for errors from the database engine?
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
What are the different types of database compression introduced in sql server 2008? : sql server DBA
