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

3 Answers  

---

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

---

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

1 Answers  

---

what is the difference between off-line back up and on-line back up in ibm db2 udb?

2 Answers   Zenith,

---

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

1 Answers   IBM,

---

Why would you call update statistics? : sql server DBA

0 Answers  

---

What is the difference between LMT & DLT?

1 Answers   CTS,

---

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

0 Answers  

---

What is dbcc? : sql server DBA

0 Answers  

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

0 Answers  

---

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

2 Answers   CTS,

---

How do you add a data file to a tablespace?

3 Answers  

---