Oracle DBA Interview Questions and Answers for Experienced - 2

Question: 6

What is partitioning?

Partitioning is used to divide large tables into manageable partitions based on different criteria, such as list, hash, or range.

Question: 7

Can you build indexes online?

Yes, you can build indexes online.

Question: 8

What are the different types of indexes available in Oracle?

Oracle database provides several indexing schemes that provide complementary performance functionality, which are given as follows:

B-tree index – Retrieves a small amount of data from a very large table.

B-tree cluster index – Refers to the index that is defined specifically for cluster.

Hash cluster index – Refers to the index that is defined specifically for a hash cluster.

Global and local index- Relates to partitioned tables and indexes.

Reverse key index – Refers to the index that is most useful for Oracle Real Application Clusters applications.

Bitmap index – Uses a map of bits to represent the whole index. They are mostly used in data warehouses. These indexes work best for columns with a small set of values.

Function based index – Contains the pre computed value of a function or expression.

Domain index – Refers to an application or cartridge.

Question: 9

What is null?

Oracle has a specific value called null, which is neither equal nor not equal to any value. In addition, null is neither true nor false.

A value can be checked for null using special operator called IS NULL or IS NOT NULL.

Question: 10

Name two files used for network connection to a database?

The TNSNAMES.ORA and SQLNET.ORA files are used for network connection to a database.