> > Oracle MCQs > Managing Partitioned Tables And Indexes MCQs

Managing Partitioned Tables And Indexes MCQ

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?

Range-Hash Partition And Range-List Partition

None

Range-Hash Partition

Range-List Partition

Answer

Correct Answer: Range-List Partition

Note: This Question is unanswered, help us to find answer for this one

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

True

False

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

You can compress some or all partitions of a B-tree index using key compression. Key compression is applicable only to B-tree indexes?

False

True

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

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);

Range

None

List

Hash

Answer

Correct Answer:

Hash

Note: This Question is unanswered, help us to find answer for this one

The rules for creating range-partitioned global indexes are similar to those for creating range-partitioned tables?

True

False

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: 16

Note: This Question is unanswered, help us to find answer for this one

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?

None

Dropping Partitions

Coalescing Partitions

Adding partitions

Answer

Correct Answer: Adding partitions

Note: This Question is unanswered, help us to find answer for this one

To create which partitions you specify the following?

Hash Partition

Partition description identifying partition bounds

List Partition

Range Partition

Answer

Correct Answer: Partition description identifying partition bounds

Note: This Question is unanswered, help us to find answer for this one

While Using the MOVE PARTITION clause of the ALTER TABLE statement to?

Move a partition to another tablespace

Store the data in compressed format using table compression

All

Modify create-time attributes

Re-cluster data and reduce fragmentation

Answer

Correct Answer: All

Note: This Question is unanswered, help us to find answer for this one

Which of the following operations support the UPDATE INDEXES clause?
A)The following operations support the UPDATE INDEXES clause:

DROP PARTITION | SUBPARTITION, SPLIT PARTITION | SUBPARTITION

COALESCE PARTITION | SUBPARTITION, MOVE PARTITION | SUBPARTITION

ADD PARTITION | SUBPARTITION, MERGE PARTITION | SUBPARTITION

EXCHANGE PARTITION | SUBPARTITION, TRUNCATE PARTITION | SUBPARTITION

All

Answer

Correct Answer:

All

Note: This Question is unanswered, help us to find answer for this one

Managing Partitioned Tables And Indexes MCQ

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?

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

You can compress some or all partitions of a B-tree index using key compression. Key compression is applicable only to B-tree indexes?

The rules for creating range-partitioned global indexes are similar to those for creating range-partitioned tables?

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

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?

To create which partitions you specify the following?

While Using the MOVE PARTITION clause of the ALTER TABLE statement to?

Which of the following operations support the UPDATE INDEXES clause?A)The following operations support the UPDATE INDEXES clause:

Which of the following operations support the UPDATE INDEXES clause?
A)The following operations support the UPDATE INDEXES clause: