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
What are the recovery models for a database? : sql server DBA
What is a system database and what is a user database? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
Why would you use sql agent? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
how can you enable flashback feature?
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.
How can you control the amount of free space in your index pages? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
internal architecture
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
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 is fill factor? : sql server DBA
Query processing is slow(eg select query)how will u solve that