Free H13-922 Exam braindumps download (H13-922 exam dumps Free)

Any user can create table spaces.

Answer(s): B

Which of the following advantages does a partitioned table have over an ordinary table?

Improve query performance; queries on partitioned objects can search only the partitions that they care about to improve retrieval efficiency.
Enhance availability; if one partition of a partitioned table fails, the table data is still available in other partitions.
Easy maintenance; if a partition of the partition table fails. Need to repair the data, just repair the partition.
Balance I / O; you can map different partitions to different disks to balance I / O and improve the overall system performance.

Answer(s): A,B,C,D

Which of the following is incorrect about the partition design?

Partition the existing table, it is best to build the index after the data is migrated
If you want to take full advantage of the query of a partitioned table, you must use the field when partitioning as a condition
Global uniqueness before and after partitioning
VACUUM or ANALYZE will only play a main role on the main table

Answer(s): A