Give the reasoning behind using an index.

2 Answers  

---

what do you understand by flashback feature of oracle?

0 Answers   Oracle,

---

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  

---

How to make a replica of existing oracle server to another server?

3 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 do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  

---

What the different components in replication and what is their use? : sql server DBA

0 Answers  

---

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers  

---

what is a user-defined lock?

0 Answers   Oracle,

---

what is the use of recording information about current session?

0 Answers   Oracle,

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers  

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,

---