Oracle Database 12c: Implement Partitioning Quiz Questions and Answers

While designing the database for one of your online transaction processing (OLTP) applications, you want to achieve the following: a) High availability of data b) Faster primary key access to the table data c) Compact storage for the table Which type of tables would you use to achieve these objectives?

Answer :
  • Partitioned tables

What is used to store all data in a database including user data and the Data Dictionary Data?

Answer :
  • Tables

To create which partitions you specify the following? Partition description identifying partition bounds.

Answer :
  • Range Partition

In which partition this form of composite partitioning is well suited for historical data, but lets you further group the rows of data based on unordered or unrelated column values?

Answer :
  • Range-List Partition

How many partitioning keys columns are specified for range-and-hash-partitioning tables?

Answer :
  • 16

Which partitioning methods we can use for index-organized tables?

Answer :
  • All of them

In the following example the index-organized table, sales, is partitioned by which method? CREATE TABLE sales(acct_no NUMBER(5), acct_name CHAR(30), amount_of_sale NUMBER(6), week_no INTEGER, sale_details VARCHAR2(1000), PRIMARY KEY (acct_no, acct_name, week_no)) ORGANIZATION INDEX INCLUDING week_no OVERFLOW PARTITION BY HASH (week_no) PARTITIONS 16 STORE IN (ts1, ts2, ts3, ts4) OVERFLOW STORE IN (ts3, ts6, ts9);

Answer :
  • Hash

In ALTER TABLE Maintenance Operations for Table Partitions which maintenance operation partition is used by range,hash,list,composite (range/hash),composite(range/list) from the following?

Answer :
  • Adding partitions

Indexes may be marked UNUSABLE for which table type the index behaviour for adding partition is? 1) For local indexes, the behaviour is the same as for heap tables. 2) All global indexes remain usable.

Answer :
  • Both A & B

You cannot drop the only partition in a table. Instead, you must drop the table?

Answer :
  • TRUE