Answer / steve

in $ORACLE_HOME/rdbms/audit/

How would you extract DDL of a table without using a GUI tool?

0 Answers  

---

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

2 Answers   TCS,

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers  

---

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  

---

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers  

---

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

---

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  

---

What is transparent data encryption? : sql server DBA

0 Answers  

---

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

1 Answers   IBM,

---

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,

---

How would you go about increasing the buffer cache hit ratio?

2 Answers  

---

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers   Cognizant,

---