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 … Continue reading Oracle 11g R2- New features (Interview Questions)