EXPORT_TABLE_STATS procedure is used to export statistics of an existing table ?

The primary goal of logging is to ensure that if your PL/SQL block has performance problems once deployed to production you should be able to identify the exact SQL or other PL/SQL component (eg a loop) that is causing the issue.

If parallelism is used in a DML then PX COORDINATOR should be below DML operation in the EXPLAIN PLAN ?

Comment lines contain about the parallelism used ?

BITMAP INDEX is used in situations where the index is created after the table or partition is populated ?

If we are using UNION or UNION ALL then comment is necessary ?

UNION or UNION ALL should be avoided ?

As per BT security guide lines, account sharing is legal ?

Reading and writing data in datawarehouse should be maximized ?

In case of any deployment you if we need to backup data anywhere there must be a clear plan to remove this later. ?

For creating a table named T1 do we need to check whether that table exist or not ?

Make sure that every SQL that will run in your PL/SQL writes it’s elapsed time to your log file?

Business Logic comments is required for any SQL