Answer / Kritishwar Pathak

In Oracle Database, you can use the Flashback Transaction Query (FTQ) to view the actual data change values from a specific transaction. This feature allows you to query the database as if it were at a particular point in time during that transaction.

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  

---

Which environment variables are absolutely critical in order to run the OUI?

2 Answers  

---

Why would you call update statistics? : sql server DBA

1 Answers  

---

How would you determine the time zone under which a database was operating?

2 Answers  

---

Name two files used for network connection to a database.

5 Answers  

---

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

1 Answers  

---

What view would you use to determine free space in a tablespace?

3 Answers  

---

Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?

11 Answers   FA, GE, Wipro,

---

the process of adding a cpu in sql server is called..?

2 Answers   TCS,

---

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 system database and what is a user database? : sql server DBA

1 Answers  

---

how can you process messages in order asynchronously?

1 Answers   Oracle,

---