how will u see whether the dabase is in archive log mode or not?
Answer Posted / kittu
in two ways we can check
1) archive log list
2) select log_mode from v$database;
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
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?
What are the different ways you can create databases in sql server? : sql server DBA
what is a crs resource?
What happens on checkpoint? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
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
what is asm?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
when does an alert gets signaled?
Can you redefine a table online?
what functionality does oracle provide to secure sensitive information?
Explain materialized views and how they are used.
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?