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 is a user-defined lock?
Why does Oracle not permit the use of PCTUSED with indexes?
how can you record information about current session?
What is a system database and what is a user database? : 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 dcl? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What are the operating modes in which database mirroring runs? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
how can you communicate with operating system files from oracle?
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 can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What is the difference between dropping a database and taking a database offline? : sql server DBA