If we issue alter database begin backup. What happens to database?
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
How do you open a cluster administrator? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What are the different sql server versions you have worked on? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
how to restore files with rman?
what is grd?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
how can a session indicate its interest in receiving alerts?
What is transparent data encryption? : sql server DBA
What is the default fill factor value? : sql server DBA
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
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.
how can you schedule a job in database?
What are the different ways you can create databases in sql server? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA