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

Question Posted / kittu

2 Answers
4422 Views
CSC, I also Faced
E-Mail Answers

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

Explain CREATE DATABASE syntax?

2 Answers

what functionality does oracle provide to secure sensitive information?

0 Answers Oracle,

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers IBM,

How would you begin to troubleshoot an ORA-3113 error?

1 Answers

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

0 Answers

What is the default port no on which sql server listens? : sql server DBA

0 Answers

You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?

0 Answers

How would you determine what sessions are connected and what resources they are waiting for?

2 Answers

Explain the use of table functions.

1 Answers

how can you record information about current session?

0 Answers Oracle,

Why does Oracle not permit the use of PCTUSED with indexes?

0 Answers

How would you go about verifying the network name that the local_listener is currently using?

0 Answers

For more DB Administration Interview Questions Click Here