Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  

---

how will you see when the database was started using sql prompt?

2 Answers   IBM,

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

0 Answers  

---

How can you gather statistics on a table?

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,

---

What type of index should you use on a fact table?

1 Answers  

---

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

---

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

4 Answers   DELL, TCS,

---

now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,

---

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

0 Answers  

---

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

0 Answers  

---

What is a correlated sub-query? : sql server DBA

0 Answers  

---