Tag: databases

Questions Related to databases

Do you need to recycle Views for better performance?

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Using NVL(),TO_DATE (), TO_NUMBER () functions in 'where' clause on non-indexed columns does improve performance
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Which View helps in querying high I/O statements?
technology databases

  1. V$SQLSTATS.DISK_READS

  2. V$DISK_READS

  3. V$SQL_STATS

  4. V$SYS_STAT

Show answer
Correct Option: A

Which of the following generates the PLAN for SQL statements?

technology databases

  1. PLAN

  2. EXPLAIN PLAN

  3. TKPROF

  4. V$PLAN

Show answer
Correct Option: B

In which version of Oracle is AWR Introduced ?
technology databases

  1. 11g

  2. 9i

  3. 8i

  4. 10g

Show answer
Correct Option: D

Is Statspack available in Oracle 11g?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Which user owns all the package of STATSPACK?
technology databases

  1. PERFMON

  2. PERFSTAT

  3. SYSTEM

  4. SCOTT

Show answer
Correct Option: B

Which of the following is not a schema object?
technology databases

  1. Indexes

  2. Tables

  3. Public Synonyms

  4. Triggers and Packages

Show answer
Correct Option: C

If commission is null then the text “Not Applicable” must be displayed, instead of blank space. How do I write the query?
technology databases

  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

Show answer
Correct Option: A

Which data dictionary object is used to retrieve the information about the tables from a given schema?

technology databases

  1. USER_TABLES

  2. USER_TABS

  3. Both 1 & 2

  4. None of the above

Show answer
Correct Option: A