1Z0-074 · Question #26
You want to partition the SALES table on the CITY and SALE_DATE columns. Which three partitioning methods can you use? (Choose three.)
The correct answer is A. range C. hash D. list. Explanation/Reference: https://docs.oracle.com/database/121/VLDBG/GUID-6CE884AF-84A4-4E6A-A3EF- DCCEBCAB2DB2.htm#VLDBG00202
Question
You want to partition the SALES table on the CITY and SALE_DATE columns. Which three partitioning methods can you use? (Choose three.)
Options
- Arange
- Binterval
- Chash
- Dlist
- Evirtual column-based
How the community answered
(53 responses)- A77% (41)
- B8% (4)
- E15% (8)
Explanation
Explanation/Reference: https://docs.oracle.com/database/121/VLDBG/GUID-6CE884AF-84A4-4E6A-A3EF- DCCEBCAB2DB2.htm#VLDBG00202
Topics
Community Discussion
3
Otieno M.Dec 1, 2025A, C, D is right. Range, hash, and list are the three native methods that support composite (multi-column) partition keys directly, so you can partition on both CITY and SALE_DATE in a single partition clause. Interval (B) only works on a single numeric or date column and cannot be part of a composite key, and virtual column-based (E) is not a standalone partitioning method but rather a way to derive the partition key, not one of the core methods the question is testing.
Viktor S.Dec 18, 2025Correct. Range, hash, and list all support composite partition keys natively; interval does not.
Fatima Z.Nov 21, 2025Thought B fit but interval hates company, so RHL wins: Range, Hash, List.