Interested to Buy Any Domain ? << Click Here >> for more details...
Explain what partitioning is and what its benefit is.
- 2 Answers
- 7368 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
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What is dcl? : sql server DBA
what is a crs resource?
How do you open a cluster administrator? : sql server DBA
What is transparent data encryption? : sql server DBA
What purpose does the model database server? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
how can you record information about current session?
What is the importance of a recovery model? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
how can you implement fine-grained auditing?
