how will u see whether the dabase is in archive log mode or not?
Answer Posted / 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 |
Post New Answer View All Answers
what is the use of recording information about current session?
Explain about your sql server dba experience? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How do you open a cluster administrator? : sql server DBA
what is the use of ocr?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
What the different components in replication and what is their use? : sql server DBA
Which autogrowth database setting is good? : sql server DBA
What is fill factor? : sql server DBA
What are the recovery models for a database? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.