What is the difference between dropping a database and taking a database offline? : sql server DBA

0 Answers  

---

what is the diffrence between core dba and apps dba?

0 Answers   Cap Gemini,

---

Which autogrowth database setting is good? : sql server DBA

0 Answers  

---

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  

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers   Infosys,

---

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

2 Answers  

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers   Patni,

---

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

2 Answers  

---

hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers   IBM,

---

how can you find out if a table can be redefined?

0 Answers   Oracle,

---

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

2 Answers   IBM,

---

What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

3 Answers  

---