Oracle Dba Interview Question and Answers

31. What is the major difference between the clob and blob data types in Oracle Database 1Og?
  The clob stores only alphanumeric data, whereas the blob can accommodate any type of data, including sound and video.
 
Your Name Your Email-ID
Your Answer
32. What is the difference between an index cluster and a hash cluster?
  An index cluster is a cluster that has an index on the cluster key,
whereas the hash cluster uses a hashing function to access the cluster key.
 
Your Name Your Email-ID
Your Answer
33. What is a recovery catalog?
  Recovery catalog is an inventory of the backup taken by RMAN for the database.It is used to restore a physical backup, reconstruct it, and make it available to the server.
 
Your Name Your Email-ID
Your Answer
34. What are architectural components of RMAN?
 
    Following are the architectural components of RMAN :
  • RMAN executable
  • Server processes
  • Channels
  • Target database
  • Recovery catalog database (optional)
  • Media managements layer (optional)
  • Backups, backup sets, and backup pieces.
 
Your Name Your Email-ID
Your Answer
35. What is load balancing?
  Load balancing is a server process that monitors loading on all of the forms servers. Each of the forms servers runs a load balancing client which keeps the load balancing server apprised of its load.
 
Your Name Your Email-ID
Your Answer