Explain: a.) Integrity Constraints

It can be called as a declarative way in order to define a business rule for a table's column

b.) Index

- It can be called as an optional structure which is associated with a table for direct access to the rows
- Index can be created for one or more columns in a table

c.) Extent

- It can be defined as a specific number of contiguous data blocks in single allocation.
- It is used to store a specific type of information.

Posted in: 500 Oracle interview questions and answers