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

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

  1. True

  2. False


Correct Option: B

If the serial code runs in less than 50% window time than parallelism should be considered ?

  1. True

  2. False


Correct Option: B

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

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

  1. True

  2. False


Correct Option: B

Reading and writing data in datawarehouse should be maximized ?

  1. True

  2. False


Correct Option: B
- Hide questions