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

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

1 Answers  


What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  


When a user process fails, what background process cleans up after it?

1 Answers  


when does an alert gets signaled?

1 Answers   Oracle,


orra 1555 what is this error,why it is occur?

2 Answers   Mphasis,


how does an oracle clusterware manage crs resources?

1 Answers   Oracle,


What does coalescing a tablespace do?

1 Answers  


Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1 Answers  


If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

1 Answers  


Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

1 Answers   Tech Mahindra,


what r the types of backup?

5 Answers   CSC,


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

1 Answers  


Categories