Answer / kittu

in two ways we can check
1) archive log list
2) select log_mode from v$database;

Answer / krishna

archive log list
select log_mode from v$database;

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers  

---

What view would you use to look at the size of a data file?

3 Answers  

---

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

0 Answers   EDS,

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,

---

What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

3 Answers  

---

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers  

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 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  

---

How do you troubleshoot errors in a sql server agent job? : sql server DBA

0 Answers  

---

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

1 Answers  

---

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

0 Answers  

---

How would you go about increasing the buffer cache hit ratio?

2 Answers  

---