Which two methods will provide the total number of partitions on a table?

Oracle 1z0-888 Question Answer

Which two methods will provide the total number of partitions on a table? (Choose two.)

Query the INFORMATION_SCHEMA.PARTITIONS table

Use the command: SHOW TABLE STATUS

Query the performance_schema.objects_summary_global_by_type table

Query the INFORMATION_SCHEMA.TABLES table for the partition_count

Use the command: SHOW CREATE TABLE

1z0-888 PDF/Engine

Get 65% Discount on All Products, Use Coupon: "ac4s65"