how will u see whether the dabase is in archive log mode or not?

Question Posted / kittu

Answers were Sorted based on User's Feedback

how will u see whether the dabase is in archive log mode or not?..

Answer / 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

how will u see whether the dabase is in archive log mode or not?..

Answer / krishna

archive log list
select log_mode from v$database;

Is This Answer Correct ?

1 Yes

0 No

More DB Administration Interview Questions

What authentication modes does sql server support? : sql server DBA

What are the steps you will take to improve performance of a poor performing query?

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

now one user in online.now i want drop him..how do u drop him?

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1)how to Take Backup in sql server 2005 from Flash Drive

Explain CREATE DATABASE syntax?

From the database level, how can you tell under which time zone a database is operating?

What are the operating modes in which database mirroring runs? : sql server DBA

what is the difference between off-line back up and on-line back up in ibm db2 udb?

What view would you use to determine free space in a tablespace?

How would you go about increasing the buffer cache hit ratio?

For more DB Administration Interview Questions Click Here