July 23, 2007

ORACLE Interview Questions -1

  1. How do you correct a procedure that has become invalid when one of the tables it is referring to was altered to drop a constraint?
  2. What piece of information is not available in the control file?
  3. Which data dictionary view shows statistical information from the ANALYZE INDEX VALIDATE STRUCTURE command?
  4. Which component is not part of the ROWID? A. Tablespace B. Data file number C. Object ID D. Block ID
  5. What is the prefix for dynamic performance views?
  6. Which data dictionary view provides information on the version of the database and installed components?
  7. Which component in the SGA has the dictionary cache?
  8. What is the default value of PCTFREE?
  9. What is the default password for the SYS user?
  10. Which role is created by default to administer databases?
  11. Which DB administration tools are included in the DBA Studio Pack?
  12. Name the parts of the database buffer pool.
  13. Which clauses in the CREATE DATABASE command specify limits for the database?
  14. Which clauses in the CREATE DATABASE command specify limits for the database?
  15. When creating a database, where does Oracle find information about the control files that need to be created?
  16. At which stage of the database start-up is the control file opened?
  17. Which script creates the data dictionary views?
  18. Which keyword is not valid of the BUFFER_POOL parameter of the STORAGE clause?
  19. Which initialization parameter cannot be changed after creating the database?
  20. Which command is used to assign a profile to an existing use? a. ALTER PROFILE b. ALTER USER c. SET PROFILE d. The profile should be specified when creating the user; it cannot be changed.
  21. What information is available in the alert log files?
  22. Which parameter value is use to set the directory path where the alert log file is written?
  23. When are the system change numbers assigned?
  24. Explain the nvl2 function?
  25. Which command will “bounce” the database-that is, shut down the database and start up the database in a single command?
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)