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

If the number of leaf blocks of index , scanned is less than 5000 then degree of parallelismis 2?

  1. True

  2. False


Correct Option: B

If the number of leaf blocks of index , scanned is 50000-250000 then what is the degree of parallelism is 16 ?

  1. True

  2. False


Correct Option: B

NOLOGGING is used to reduce redo log generation ?

  1. True

  2. False


Correct Option: B

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 purpose of comments is that someone that has never worked on the project before. They would need to underderstand precisely where changes has been done, why those changeswere made, and exactly what the change was.

  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

HINTS should be used to parallelise an operation if the operation is FULL TABLE SCAN ?

  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

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

  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

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

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

  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

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

  1. True

  2. False


Correct Option: B
- Hide questions