How do you troubleshoot errors in a sql server agent job? : sql server DBA

0 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  

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers  

---

which background process invoke at the time of upgradation tell me???

0 Answers   iGate,

---

WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,

---

Explain an ORA-01555

2 Answers  

---

What purpose does the model database server? : sql server DBA

0 Answers  

---

What would you do with an "in-doubt" distributed transaction?

0 Answers  

---

How can you rebuild an index?

6 Answers  

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers  

---

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,

---

orra 1555 what is this error,why it is occur?

2 Answers   Mphasis,

---