Oracle Dba Interview Question and Answers

51. What is the control file?
  Control file is a file that contains all the information about the physical structure of the database,such as the number of log files and their location.
 
Your Name Your Email-ID
Your Answer
52. What is the difference between incremental backup and differential backup?
  Both, incremental and differential backup files that have been modified or created after the previous backup. However, attributes are reset after the incremental backup but after the differential backup.
 
Your Name Your Email-ID
Your Answer
53. Which files must be backed up?
 
    The following files must be backed up :
  • Database files
  • Control files
  • Archived log files
 
Your Name Your Email-ID
Your Answer
54. What is internal monitor?
  This manager is used to implement parallel concurrent processing. It monitors whether the ICM is still running, and if the ICM crashes, it will restart it on another node.
 
Your Name Your Email-ID
Your Answer
55. What is the significance of GWYUID?
  It is used to connect to database by thick clients.
 
Your Name Your Email-ID
Your Answer