Tag: databases

Questions Related to databases

Which are appropriate scheduling tools for use in EIP database?

technology databases

  1. CONTROL M

  2. DBMS_JOB

  3. DBMS_SCHEDULER

  4. ALL

Show answer
Correct Option: D

What can be used to optimize the performance of simple SQL?

technology databases

  1. DYNAMIC PARALLELISM

  2. HINTS

  3. STORED OUTLINES

  4. ALL

Show answer
Correct Option: D

COMPLETE REFRESH by default will _________________all rows in an mview before inserting new rows
technology databases

  1. Create

  2. Delete

  3. Append

  4. None

Show answer
Correct Option: B

On a partitioned table which index is used mostly
technology databases

  1. Local

  2. Global

  3. Both

  4. None

Show answer
Correct Option: A

Indexes and statistics are built ________________ the exchange of the exchange table ?
technology databases

  1. After

  2. Before

  3. In either way

  4. Not Relevant

Show answer
Correct Option: B

If the value in a column is not unique then which index is used ?

technology databases

  1. bitmap indexes

  2. b*-tree indexes

  3. composite unique index

  4. cluster index

Show answer
Correct Option: A

Which object in PL/SQL provides encapsulation features ?

technology databases

  1. Procedure

  2. Package

  3. Functions

  4. All

Show answer
Correct Option: B

When we should truncate the working table ?

technology databases

  1. At the end of the run

  2. Beginning of next run

  3. At any point of Time

  4. Can't be done

Show answer
Correct Option: B

If you need remove code from a script, including PL/SQL, what you will do?
technology databases

  1. remove

  2. comment the code

  3. Either of them should be fine

  4. Don't do anything

Show answer
Correct Option: A

while making query in a partitioned table which one we should use .
technology databases

  1. explicit reference to partitions

  2. use the partition key in filter condition

  3. query will automatically decide the partition

  4. All of the above

Show answer
Correct Option: B