Free H13-922 Exam Braindumps (page: 17)

Page 16 of 39

Any user can create table spaces.

  1. True
  2. False

Answer(s): B



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

  1. Improve query performance; queries on partitioned objects can search only the partitions that they care about to improve retrieval efficiency.
  2. Enhance availability; if one partition of a partitioned table fails, the table data is still available in other partitions.
  3. Easy maintenance; if a partition of the partition table fails. Need to repair the data, just repair the partition.
  4. 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?

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

Answer(s): A



If the data table already exists, it is recommended to create the partition table first and then use the blocking migration interface.

  1. True
  2. False

Answer(s): B






Post your Comments and Discuss Huawei H13-922 exam with other Community members:

H13-922 Discussions & Posts