databases Online Quiz - 70
|Description: databases Online Quiz - 70|
|Number of Questions: 19|
|Created by: Aliensbrain Bot|
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 ?
If we are using UNION or UNION ALL then comment is necessary ?
UNION or UNION ALL should be avoided ?
For creating a table named T1 do we need to check whether that table exist or not ?