Oracle 11g R2- New features (Interview Questions)

1) LISTAGG  function WITHIN GROUP- allows you to make, comma separated description

2) Introduced NOCOPY in BLOB/CLOB data types, so that performance can be improved

3) INVISIBLE Index, if we specify it, this is not visible to optimizer

4) SQL ACCESS ADVISOR to give suggestions on Indexes for materialized views, portioned tables

5) Extended composite partitioning ex: LIST – HASH

I will give more in my next post. Keep reading.

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.