Answer / Manu

The 'snap$' script creates a snapshot control file, which is used by Oracle to manage snapshots of datafiles. It is created during the creation or alteration of a database.nnThe 'scott/tiger' schema is part of the standard distribution of the Oracle database and is created automatically when you create a new database.

What is a system database and what is a user database? : sql server DBA

1 Answers  

---

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

4 Answers   DELL, TCS,

---

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

1 Answers  

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

1 Answers  

---

Give two examples of referential integrity constraints.

2 Answers  

---

what is the differnce between process and thread ?

1 Answers   IBM,

---

What's the benefit of "dbms_stats" over "analyze"?

1 Answers  

---

Can you redefine a table online?

1 Answers   Oracle,

---

Give the reasoning behind using an index.

2 Answers  

---

What are the recovery models for a database? : sql server DBA

1 Answers  

---

Explain the difference between a data block, an extent and a segment.

2 Answers  

---

Explain about your sql server dba experience? : sql server DBA

1 Answers  

---