Oracle Dba Interview Question and Answers

81. What is VIP?
 
  • VIP is an IP address, which is not directly connected to any host.
  • It is a spare address, which can be mapped to another host in the same subnet.
  • It can be easily mapped to another host in case of a failure.
 
Your Name Your Email-ID
Your Answer
82. What are the disk components?
 
  • Datafiles
  • Redo Logs
  • Control files
  • Password files
  • parameter files
  • are the disk components.
 
Your Name Your Email-ID
Your Answer
83. What is the parameter file?
  The parameter file is a file that contains additional command line parameters.
 
Your Name Your Email-ID
Your Answer
84. What is rolling upgrade?
  Rolling upgrade refers to the software upgrade while database is still functional without bringing the database down for upgrade. This is the new feature of Oracle 11g.
 
Your Name Your Email-ID
Your Answer
85. What are the collection types in oracle?
  Collection types are objects that contain multiple sets of values. There are two kinds of collection types: varrays and object–type tables.
 
Your Name Your Email-ID
Your Answer