Oracle DBA Structure Interview Questions and Answers Pdf - 2

Question: 6

What is the control file?

Control file is a file that contains all the information about the physical structure of the database, such as number of log files and their location.

Oracle database server uses control file to find its physical component.

Question: 7

What is PCTINCREASE?

PCTINCREASE determines the size of next extent with respect to the current extent.

Question: 8

What happens when control file is damaged?

You cannot restore the database if control file is damaged.

Question: 9

How does row chaining affects the performance?

Chained rows do not affect the performance if we need to fetch data from the first block only.

It affects the performance only if we need to fetch data from any other block besides the first block.

Question: 10

What is Automatic Segment Space Management (ASSM)?

ASSM is a method used to Oracle to manage space inside data blocks.

It eliminates the need to specify parameters, such as PCTUSED, freelist and freelist groups, for objects created in the tablespace.