Parallel & Distributed Database

A data block is?

• The place where all deleted records are persisted

• The smallest logical storage unit for a database object

• The largest logical storage unit ever available for any database block

• All of the above

The ____________ contains a set of tables and views that Oracle uses as a reference to the database?

• PGA

• Data Dictionary

• SGA

• Library cache

____________ is an area on disk which comprises of one or more disk files?

• A partition

• Heap

• A package

• A table space

What is the use of an index?

• Retrieve data more quickly and efficiently

• Simplify the user’s perception of data access

• Related data requires much less I/O overhead if accessed simultaneously

• All of them

Partition description identifying partition bounds.

• Range Partition

• Hash Partition

• List Partition

• Range-Hash Partition

Which partitioning methods can be used for index-organized tables?

• Range Partition

• Hash Partition

• List Partition

• All the above

Oracle instance can have following tablespaces

• System

• Temp

• Users

• Undo

• All the above

The table space used for keeping data dictionary and oracle data

• Temp

• Undo

• System

• None of these

The tablespace used for execution of query for keeping temporary data like intermediate data generated for sorting operation is

• System tablespace

• Undo tablespace

• Temp tablespace

• All the above

In case of _____ partitioning, partition key is defined and partition is defined using partition boundary in the ascending order.

• hash

• interval

• range

• list