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;

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers   Patni,

---

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers  

---

how can you find out if a table can be redefined?

0 Answers   Oracle,

---

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers  

---

how do see how much space is used and free in a tablespace

2 Answers   Genpact,

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

0 Answers  

---

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

0 Answers  

---

Explain the concept of the DUAL table.

3 Answers  

---

suppose you want to audit specific activities on sensitive data. How can you achieve that?

0 Answers   Oracle,

---

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

3 Answers  

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  

---

when does an alert gets signaled?

0 Answers   Oracle,

---