0

databases Online Quiz - 70

Description: databases Online Quiz - 70
Number of Questions: 19
Created by:
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.

  1. True

  2. False


Correct Option: B

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

  1. True

  2. False


Correct Option: B

Comment lines contain about the parallelism used ?

  1. True

  2. False


Correct Option: B

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

  1. True

  2. False


Correct Option: B

UNION or UNION ALL should be avoided ?

  1. True

  2. False


Correct Option: B

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

  1. True

  2. False


Correct Option: B
- Hide questions