> > Oracle MCQs > Managing Partitioned Tables And Indexes MCQs

Managing Partitioned Tables And Indexes MCQ

1. 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

2. 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

3. 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

4.
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

5. 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

6. 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

7. 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

8. 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

9. 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

10.
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

Oracle MCQs | Topic-wise

MCQ on Basic Oracle	MCQ on Managing Archived Redo Logs
MCQ on Managing Clusters	MCQ on Managing Control Files
MCQ on Managing Data-files And Temp-files	MCQ on Managing Hash Clusters
MCQ on Managing Indexes	MCQ on Managing Oracle Database Processes
MCQ on Managing Oracle Distributed Transactions	MCQ on Managing Partitioned Tables And Indexes
MCQ on Managing Space For Schema Objects	MCQ on Managing Tables
MCQ on Managing Tablespaces	MCQ on Managing The Redo Log
MCQ on Managing The Undo Tablespace	MCQ on Managing Views, Sequences, And Synonyms
MCQ on Oracle Distributed Transactions Concepts	MCQ on Oracle WebLogic
General Oracle MCQs

Managing Partitioned Tables And Indexes MCQ

1. 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?

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

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

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

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

7. 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?

8. To create which partitions you specify the following?

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

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

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