Answer / Vicky Jaiswal

Asynchronous message processing can be achieved through various methods such as Oracle Advanced Queues (AQ), Database Direct, or third-party messaging middleware like RabbitMQ and Apache Kafka. These solutions allow for the ordering of messages, even when processing is not immediate.

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

1 Answers  

---

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

1 Answers  

---

Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

4 Answers  

---

Explain the concept of the DUAL table.

3 Answers  

---

wat is global index and local indes

1 Answers   Oracle,

---

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

1 Answers  

---

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

---

I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1 Answers  

---

What is the default fill factor value? : sql server DBA

1 Answers  

---

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

1 Answers  

---

What are the ways tablespaces can be managed and how do they differ?

2 Answers   IBM,

---

Hot backup procedure?

2 Answers  

---