Modifying Oracle Partitions - Quiz

Each question is worth one point. Select the best answer or answers for each question.

1.	Which of the following modifications can you completely perform with a single ALTER TABLE command? Please select all the correct answers.
	A.	Add a partition
	B.	Merge a partition
	C.	Split a partition
	D.	Dump data with a partition

2.	Which of the following types of indexes or index partitions are marked as UNUSABLE when you truncate a partition in a table? Please select all the correct answers.
	A.	Local indexes
	B.	Global partitioned indexes with a reference to the truncated table partition
	C.	All partitions in a global partitioned indexes
	D.	All global non-partitioned indexes

3.	Which of the following statements best describes the difference between truncating a partition and dropping the partition? Please select the best answer.
	A.	Dropping a partition deletes the data from the partition, while truncating a partition drops the data and the partition structure.
	B.	Truncating a partition deletes the data from the partition, while dropping a partition drops the data and the partition structure.
	C.	Truncating a partition forces a local index partition to be rebuilt, while dropping a partition does not.
	D.	There is no difference.