Answer / guest

Partitioning is a method of taking large tables and indexes
and then splitting them into smaller and more manageable
pieces.


Regards
Abhinav Phadnis

Answer / ramesh

And the Advantage are
1.Maintaincace :-Can Take Partioned tables's tablespace
offline for recovery
while other partitions are still avialable to users
Hence the Avialability

2.Performace :As the Objects are plcaed in Diffrent
Tablespaces of Diffrent Servers/locations

What is the default fill factor value? : sql server DBA

1 Answers  

---

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

---

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  

---

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

1 Answers  

---

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

2 Answers   IBM,

---

Give two examples of referential integrity constraints.

2 Answers  

---

When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers  

---

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

1 Answers  

---

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

1 Answers  

---

How would you determine what sessions are connected and what resources they are waiting for?

2 Answers  

---

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

1 Answers  

---

Where would you look for errors from the database engine?

1 Answers   IBM,

---