Name a tablespace automatically created when you create a database.

5 Answers  

---

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

0 Answers  

---

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers   TCS,

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  

---

what is the use of recording information about current session?

0 Answers   Oracle,

---

Which autogrowth database setting is good? : sql server DBA

0 Answers  

---

What is blocking and how would you troubleshoot it?

1 Answers  

---

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  

---

How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers  

---

How can you enable a trace for a session?

1 Answers  

---

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   STC,

---

Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

1 Answers  

---