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;

by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers   CSC, Logica CMG,

---

what are the benefits of flashback feature?

0 Answers   Oracle,

---

Where would you look for errors from the database engine?

0 Answers   IBM,

---

Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

1 Answers  

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  

---

How can we see the database version in os level

6 Answers   Oracle,

---

What is the importance of a recovery model? : sql server DBA

0 Answers  

---

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

0 Answers  

---

What are the operating modes in which database mirroring runs? : sql server DBA

0 Answers  

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

0 Answers  

---

Explain materialized views and how they are used.

0 Answers  

---

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  

---