Interested to Buy Any Domain ? << Click Here >> for more details...
Explain what partitioning is and what its benefit is.
- 2 Answers
- 7528 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
Partitioning is a method of taking large tables and indexes
and then splitting them into smaller and more manageable
pieces.
Regards
Abhinav Phadnis
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is dbcc? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
What is replication? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
What is the default fill factor value? : sql server DBA
What is transparent data encryption? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
Where would you look for errors from the database engine?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
how to restore files with rman?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
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
What is the difference between dropping a database and taking a database offline? : sql server DBA
