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

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

0 Answers  

---

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

1 Answers   IBM,

---

In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers   Value Labs,

---

How would you extract DDL of a table without using a GUI tool?

0 Answers  

---

What are the different ways you can create databases in sql server? : sql server DBA

0 Answers  

---

---

Hot backup procedure?

2 Answers  

---

what is asm?

0 Answers   Oracle,

---

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.

0 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,

---

What is transparent data encryption? : sql server DBA

0 Answers  

---

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

0 Answers  

---

who owns the operating system files created by the utl_file package?

0 Answers   Oracle,

---