Topic : Data Dictionary

How do you install STATSPACK?


Answer :

By running $ORACLE_HOME/rdbms/admin/spcreate.sql script

Show Answer Discuss

Which parameter is use to see spfile?


Answer :

Show parameter spfile.

Show Answer Discuss

Which parameter is used to see dynamic performance view?


Answer :

V$fixed_table

Show Answer Discuss

What is command to see database size


Answer :

Select log_mode from v$database;

Show Answer Discuss

A set of Dictionary tables are created


  • Once for the Entire Database
  • Every time a user is created
  • Every time a Tablespace is created
  • None of the above

Answer :

Once for the Entire Database

Show Answer Discuss