Tag: databases

Questions Related to databases

  1. V$SQLSTATS.DISK_READS

  2. V$DISK_READS

  3. V$SQL_STATS

  4. V$SYS_STAT


Correct Option: A

Which of the following generates the PLAN for SQL statements?

  1. PLAN

  2. EXPLAIN PLAN

  3. TKPROF

  4. V$PLAN


Correct Option: B

In which version of Oracle is AWR Introduced ?

  1. 11g

  2. 9i

  3. 8i

  4. 10g


Correct Option: D

Is Statspack available in Oracle 11g?

  1. True

  2. False


Correct Option: A

Which user owns all the package of STATSPACK?

  1. PERFMON

  2. PERFSTAT

  3. SYSTEM

  4. SCOTT


Correct Option: B
  1. Indexes

  2. Tables

  3. Public Synonyms

  4. Triggers and Packages


Correct Option: C
  1. select nvl(to_char(comm),'NA') from emp;

  2. select nvl(comm,'NA') from emp;

  3. select nvl(comm,NA) from emp;

  4. None of the above


Correct Option: A