Answer Posted / kittu

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

What are the different ways you can create databases in sql server? : sql server DBA

1195

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

1108

---

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

1048

---

What is a system database and what is a user database? : sql server DBA

1315

---

What are the commands used in dcl? : sql server DBA

1131

---

What is replication? : sql server DBA

1230

---

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

2668

---

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

2016

---

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

1079

---

what is a user-defined lock?

1143

---

what are the differences of where and if in SAS?

2252

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

1123

---

How do you trace the traffic hitting a sql server? : sql server DBA

1631

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2392

---

What is the difference between clustered and non-clustered index? : sql server DBA

1143

---