Answer Posted / 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.

who owns the operating system files created by the utl_file package?

1125

---

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.

2220

---

what is the role of dip user in our database?

2461

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2784

---

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

2152

---

What are the different sql server versions you have worked on? : sql server DBA

1071

---

what is the use of recording information about current session?

1109

---

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1092

---

Where would you look for errors from the database engine?

2897

---

how can you schedule a job in database?

1192

---

what do you understand by fine-grained auditing?

1104

---

Which autogrowth database setting is good? : sql server DBA

1242

---

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

1133

---

what are the benefits of flashback feature?

1092

---

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

2044

---