Can you take Online Backups if the the database is running
in NOARCHIVELOG mode?
5. How do you bring the database in ARCHIVELOG mode from
NOARCHIVELOG mode?
6. You cannot shutdown the database for even some minutes,
then in which mode you should run
the database?
Answer Posted / guest
1.no
2.archive mode enable level.
Is This Answer Correct ? | 10 Yes | 6 No |
Post New Answer View All Answers
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What is the difference between clustered and non-clustered index? : 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 to start SQL Server in minimal configuration mode?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
what are the differences of where and if in SAS?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How would you extract DDL of a table without using a GUI tool?
What is a correlated sub-query? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
what is a user-defined lock?
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 are the types of connection load-balancing?
Where would you look for errors from the database engine?