Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the difference between ARCHIVELOG mode and
NOARCHIVELOG mode and the benefits and disadvantages to each.
- 5 Answers
- 24199 Views
- I also Faced
- E-Mail Answers
Answer Posted / neha
in nonarchivelog mode the online redo log file are
overwritten each time a log switch occurs.LGWR does not
overwrite an online redo file group until the checkpoint
for that group is completed.ex-operating system crash
causes an instance crash.
| Is This Answer Correct ? | 12 Yes | 5 No |
Post New Answer View All Answers
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 commands used in dcl? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
How to start SQL Server in minimal configuration mode?
what are the benefits of flashback feature?
what are the differences of where and if in SAS?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
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.
Why would you call update statistics? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
