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  

---

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 Answers  

---

What is replication? : sql server DBA

0 Answers  

---

What is the recommended interval at which to run statspack snapshots, and why?

1 Answers  

---

how can you communicate with operating system files from oracle?

0 Answers   Oracle,

---

how can you process messages in order asynchronously?

0 Answers   Oracle,

---

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

0 Answers  

---

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   STC,

---

Explain about your sql server dba experience? : sql server DBA

0 Answers  

---

How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers  

---

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers  

---

how to restore files with rman?

0 Answers  

---