Oracle Dba Interview Question and Answers

26. Which servers are hosted from the application tier?
 
    The following six servers constitute the application tier:
  • Oracle HTTP server (Apache)
  • Forms server
  • Reports server
  • Admin server
  • Concurrent processing server
  • Discoverer server
 
Your Name Your Email-ID
Your Answer
27. What is Streams?
  Oracle Streams is a data replication and integration feature. It enables the propagation of data, transactions and events in a data stream either within a database or from one database to another.
 
Your Name Your Email-ID
Your Answer
28. What background process refreshes materialized views?
  The job queue processes refresh the materialized views.
 
Your Name Your Email-ID
Your Answer
29. What is the Recovery Manager used for?
  The Recovery Manager is used for backup and recovery. This product performs these operations and maintains a catalog of previous backups.
 
Your Name Your Email-ID
Your Answer
30. What is the difference between system and object privileges?
  This statement when executed will display all the available system privileges such as Create Session, Drop User, Alter Database and so on.
 
Your Name Your Email-ID
Your Answer
123456789101112131415


16171819202122 Page 6 of 22