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
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What is fill factor? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What happens on checkpoint? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
how does an oracle clusterware manage crs resources?
how can you communicate with operating system files from oracle?
How do you open a cluster administrator? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What is a correlated sub-query? : sql server DBA
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
What purpose does the model database server? : sql server DBA
how can you create a user-defined lock?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.