Oracle Database 12c: Implement Partitioning Quiz Questions and Answers

What is the purpose of partition maintenance?

Answer :
  • To improve data integrity

What is the purpose of partition-wise joins?

Answer :
  • To improve query performance

What is the purpose of partition-wise aggregation?

Answer :
  • To improve query performance

What is the purpose of partition-wise export and import?

Answer :
  • To improve data storage

What is the purpose of partition-wise backup and recovery?

Answer :
  • To improve data security

What is the purpose of partition-wise replication?

Answer :
  • To improve data integrity

What is the purpose of partition-wise parallelism?

Answer :
  • To improve query performance

What is the purpose of the ALTER TABLE … EXCHANGE PARTITION statement?

Answer :
  • To exchange the contents of two partitions

What is the purpose of the ALTER TABLE … SPLIT PARTITION statement?

Answer :
  • To split a single partition into multiple partitions

What is the purpose of the ALTER TABLE … MERGE PARTITIONS statement?

Answer :
  • To merge multiple partitions into a single partition