how will u see whether the dabase is in archive log mode or not?
Answers were Sorted based on User's Feedback
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 |
Answer / krishna
archive log list
select log_mode from v$database;
| Is This Answer Correct ? | 1 Yes | 0 No |
Describe what redo logs are.
what is the difference between hot backup n rman backup?
how can you enable flashback feature?
what is incremental checkpoint?
What types of replication are supported in sql server? : sql server DBA
what is the purpose of catlaog in oracle rman?
What are the different ways of moving data or databases between servers and databases in SQL Server?
If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
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
which background process invoke at the time of upgradation tell me???
What purpose does the model database server? : sql server DBA
What view would you use to look at the size of a data file?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)