Answer / guest

online backup:

1.Inconsistent
2.database in open state.
3.Archive mode must set

offline:

1.consistent
2.db in close
3.No need archive mode

Answer / vishal sharna

offline backup is the traditional backup in which we cannot
take the backup untill the application is closed but its
quite consistent,but as we know its very cost effective to
close all the application and then take the backup,so we
will take the online backup.in this case we an take the
backup of running aplication but set the recovery log mod
to rollforward,with the help of it we can restore our
database to the most recent state.

Where in the Oracle directory tree structure are audit traces placed?

1 Answers  

---

what is meant by gateway

1 Answers   IBM,

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers  

---

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

0 Answers  

---

What is the difference between Datapump & export/import?

2 Answers  

---

---

Explain the use of table functions.

1 Answers  

---

Can you redefine a table online?

0 Answers   Oracle,

---

What is the default port no on which sql server listens? : sql server DBA

0 Answers  

---

How can you gather statistics on a table?

3 Answers  

---

Explain an ORA-01555

2 Answers  

---

How can you control the amount of free space in your index pages? : sql server DBA

0 Answers  

---

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers  

---