-
When creating a system-partitioned table, what do you specify?
The partitions you want to define, but not a partitioning key
-
What is the impact on memory usage when using table compression?
Memory usage is lower.
-
Which clause should you include with the CREATE TABLE statement to create a system-partitioned table?
The PARTITION BY SYSTEM clause
-
In 11g, which type of partitioning expands the functionality of range partitioning by automatically creating range partitions?
Interval partitioning
-
At which three levels can compression be enabled?
The table, tablespace, and partition levels
-
Which clause of the ALTER TABLE statement shrinks the EMP table and its dependent segments to release the unused space below and above the High Water Mark (HWM) of the segments?
The SHRINK SPACE CASCADE clause
-
When using interval partitioning, when are partitions for an interval automatically created?
When the inserted data exceeds all of the table's existing range partitions
-
Which two clauses should you include with the CREATE TABLE statement to create an interval-partitioned table?
The PARTITION BY RANGE and INTERVAL clauses
-
When using interval partitioning, what is the maximum number of partitioning key columns you can specify?
One
-
If you specify the COMPRESS clause of the ALTER TABLE statement but do not specify a FOR option, are rows inserted with an INSERT statement compressed?
No, only those inserted during bulk load operations
-
Which type of partitioning involves logically partitioning two tables that have a parent-child relationship?
Reference partitioning
-
When using reference partitioning and partition pruning and partitionwise joins, must query predicates be identical?
No, they can be different.
-
What are the three levels at which the Segment Advisor can be invoked?
The segment level, the tablespace level, or the object level
-
What is the impact on disk space when using table compression?
It reduces the disk space used.
-
When using interval partitioning, which requirement must partitions meet if you want to merge them using the ALTER TABLE...MERGE PARTITIONS statement?
The partitions must be adjacent.
-
What is the clause of the ALTER TABLE statement used to shrink a table?
The SHRINK SPACE clause
-
Which type of partitioning does not support partition pruning and partitionwise joins?
System partitioning
-
For which type of tables is interval partitioning not supported?
Index-organized tables
-
What is the result on an existing table's rows if you issue an ALTER TABLE...COMPRESS FOR ALL OPERATIONS; statement?
Existing rows are not compressed, but future inserted and updated rows will be.
-
When using interval partitioning, what must be the data type of the partitioning key column you specify?
NUMBER or DATE
-
Which type of tablespaces do not support the alerts based on the default threshold limits and the use of the DBMS_SERVER_ALERT package?
Dictionary-managed tablespaces
-
When using table compression, is more or less CPU used when performing DML and direct loading?
More
-
With a system-partitioned table, which DML statement requires special partition extended syntax?
An INSERT statement
-
Which type of partitioning allows you to partition a table into a specific number of partitions without using a partitioning key?
System partitioning
|
|
