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

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

Can we take incremental backups in datapump?

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

what is a crs resource?

Give the two types of tables involved in producing a star schema and the type of data theyhold.

What are the steps you will take, if you are tasked with securing an SQL Server?

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

Oracle 11g new features?

WHEN DOWN TIME WHAT CAN U DO?

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

What is the default fill factor value? : sql server DBA

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

For more DB Administration Interview Questions Click Here