Answer / suman

we have 8 packages in our database that is
1.procedures
2.triggers
3.tables
4.indexes
5.synonyms
6.views

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

1 Answers   IBM,

---

how can you process messages in order asynchronously?

0 Answers   Oracle,

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

0 Answers  

---

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

---

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1 Answers  

---

how can you initialize log miner?

0 Answers   Oracle,

---

What is fill factor? : sql server DBA

0 Answers  

---

hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers   IBM,

---

Why does Oracle not permit the use of PCTUSED with indexes?

0 Answers  

---

Describe what redo logs are.

1 Answers  

---

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

2 Answers   TCS,

---

How can you enable a trace for a session?

1 Answers  

---