how will u see whether the dabase is in archive log mode or not?
Answer Posted / krishna
archive log list
select log_mode from v$database;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What is dcl? : sql server DBA
Where would you look for errors from the database engine?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
What happens on checkpoint? : sql server DBA
how can you record information about current session?
Explain about your sql server dba experience? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
how can you create a user-defined lock?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
Query processing is slow(eg select query)how will u solve that
What types of replication are supported in sql server? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?