Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 11 Answers
- 27936 Views
- FA, GE, Wipro, I also Faced
- E-Mail Answers
Answer Posted / ramakrishna
no we can't take a backup while in no archive log mode to
enable archive log: alter database archivelog;
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Can you redefine a table online?
what do you understand by fine-grained auditing?
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.
How would you extract DDL of a table without using a GUI tool?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
How would you go about verifying the network name that the local_listener is currently using?
how does an oracle clusterware manage crs resources?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
how can you communicate with operating system files from oracle?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
Explain materialized views and how they are used.
