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

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

Post New Answer

More DB Administration Interview Questions

how can you record information about current session?

0 Answers   Oracle,


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

0 Answers  


What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  


What would you do with an "in-doubt" distributed transaction?

0 Answers  


Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

0 Answers  






what is ora 600?

1 Answers  


What is checkpoint?

3 Answers   Accenture,


What are the different types of upgrades that can be performed in sql server? : sql server DBA

0 Answers  


Explain the difference between a data block, an extent and a segment.

2 Answers  


Explain how you would restore a database using RMAN to Point in Time?

1 Answers  


WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,


Where do you find the default index fill factor and how to change it? : sql server DBA

0 Answers  


Categories