Managing Partitioned Tables And Indexes MCQs
Managing Partitioned Tables And Indexes MCQs
Answer these Managing Partitioned Tables And Indexes MCQs and see how sharp is your knowledge of Managing Partitioned Tables And Indexes.
Scroll down and let's start!
1:
Which of the following operations support the UPDATE INDEXES clause?
A)The following operations support the UPDATE INDEXES clause:
A.
DROP PARTITION | SUBPARTITION, SPLIT PARTITION | SUBPARTITION
B.
COALESCE PARTITION | SUBPARTITION, MOVE PARTITION | SUBPARTITION
C.
ADD PARTITION | SUBPARTITION, MERGE PARTITION | SUBPARTITION
D.
EXCHANGE PARTITION | SUBPARTITION, TRUNCATE PARTITION | SUBPARTITION
E.
All
2: While Using the MOVE PARTITION clause of the ALTER TABLE statement to?
A. Move a partition to another tablespace
B. Store the data in compressed format using table compression
C. All
D. Modify create-time attributes
E. Re-cluster data and reduce fragmentation
3: To create which partitions you specify the following?
A. Hash Partition
B. Partition description identifying partition bounds
C. List Partition
D. Range Partition
4: 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?
A. None
B. Dropping Partitions
C. Coalescing Partitions
D. Adding partitions
5: How many partitioning keys columns are specified for range-and-hash-partitioning tables?
A. 17
B. 18
C. 16
D. 15
6: The rules for creating range-partitioned global indexes are similar to those for creating range-partitioned tables?
A. True
B. False
7:
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);
A.
Range
B.
None
C.
List
D.
Hash
8: You can compress some or all partitions of a B-tree index using key compression. Key compression is applicable only to B-tree indexes?
A. False
B. True
9: You cannot drop the only partition in a table. Instead, you must drop the table?
A. True
B. False
10: 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?
A. Range-Hash Partition And Range-List Partition
B. None
C. Range-Hash Partition
D. Range-List Partition
List of Managing Partitioned T...
Available in:
Managing Partitioned Tables And Indexes MCQs
