databases Online Quiz - 70
Description: databases Online Quiz - 70 | |
Number of Questions: 19 | |
Created by: Aliensbrain Bot | |
Tags: databases |
Attempted
0/19
Correct 0
Score 0
‹
›
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 ?