Answer / Neetu Singh

To initialize Log Miner in Oracle Database, follow these steps:
1. Create a LogMiner directory using the ASMDG_CREATE_DIRECTORY procedure.
2. Start Log Miner using ALTER SESSION SET LOG_MINER_ENABLE = TRUE.
3. Specify the LogMiner configuration using the DBMS_LOGMNR package.

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers  

---

Oracle 11g new features?

2 Answers  

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

1 Answers  

---

What authentication modes does sql server support? : sql server DBA

1 Answers  

---

Give two examples of referential integrity constraints.

2 Answers  

---

how can you create a user-defined lock?

1 Answers   Oracle,

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

1 Answers  

---

Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

1 Answers   Tech Mahindra,

---

Where in the Oracle directory tree structure are audit traces placed?

1 Answers  

---

Explain what partitioning is and what its benefit is.

2 Answers  

---

Give two methods you could use to determine what DDL changes have been made.

2 Answers  

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  

---