Tag: databases

Questions Related to databases

  1. drop_job

  2. copy_job

  3. kill_job

  4. stop_job

  5. None


Correct Option: C
  1. PLSQL_BLOCK

  2. EXECUTABLE

  3. STORED_PROCEDURE

  4. STORED_PROCEDURE_EXECUTABLE

  5. STORED_EXECUTABLE


Correct Option: C
  1. Oracle 8

  2. Oracle 7

  3. Oracle 10g

  4. Oracle 9i

  5. None


Correct Option: A
  1. all_scheduler_job_log_

  2. dba_scheduler_job_logs

  3. users_scheduler_job_log

  4. all the above

  5. None


Correct Option: E
  1. DBMS_SCHEDULER package

  2. DBMS_SCHEDULE package

  3. DBMS_JOB package

  4. Both A & C

  5. None


Correct Option: D

You are preparing a new index on a table that has 1,500 rows. 10 rows are added to this table every day. The table already has a primary key, and the new index does not represent the order in which data in the table is to be stored. Updates to the table occur periodically but are infrequent. Which type of index would you create under this situation?

  1. Use a clustered index with a high FILLFACTOR setting

  2. Use a clustered index with a low FILLFACTOR setting

  3. Use a nonclustered index with a high FILLFACTOR setting

  4. Use a nonclustered index with a low FILLFACTOR setting


Correct Option: D