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
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What the different components in replication and what is their use? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
when does an alert gets signaled?
how can a session indicate its interest in receiving alerts?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What are the commands you'd issue to show the explain plan for "select * from dual"?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
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
How to start SQL Server in minimal configuration mode?
What the different types of replication and why are they used? : sql server DBA
How do you open a cluster administrator? : sql server DBA
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.