Explain what partitioning is and what its benefit is.
- 2 Answers
- 6536 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
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What are the different authentication modes in sql server and how can you change authentication mode? : 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.
Where do you find the default index fill factor and how to change it? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
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
Which autogrowth database setting is good? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
Can you redefine a table online?
what is the use of recording information about current session?
What the different types of replication and why are they used? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
How would you best determine why your MVIEW couldn't FAST REFRESH?
How do you trace the traffic hitting a sql server? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
