Oracle Dba Interview Question and Answers

96. State five duties of an Oracle DBA?
  Duties of a DBA might include software and hardware installation, configuration of new hardware and software, security, performance tunning, backup and recovery, routine maintenance, trouble shooting and failure recovery.
 
Your Name Your Email-ID
Your Answer
97. What is RAC?
 
  • Real application cluster (RAC) is a clustering solution.
  • It ensures high availability for database application.
  • A RAC setup contaions at least two nodes for a database.
  • RAC provides high availability and load balancing through these nodes.
 
Your Name Your Email-ID
Your Answer
98. What is the difference between Apache and oracle HTTP server?
  Oracle HTTP server is the customized from of the Apache. Oracle has customized the Apache Web server as per its own requirement which is known as the Oracle HTTP server.
 
Your Name Your Email-ID
Your Answer
99. How do you control the maximum number of redo log files in a database?
  The maximum number of redo log files can be controlled by the parameter MAXLOGFILES.
 
Your Name Your Email-ID
Your Answer
100. What is the difference between a privilege and a role?
 
  • A privilege is the authority to perform a certain act or command.
  • A role is a collection of privileges and roles that can be assigned to a user.
 
Your Name Your Email-ID
Your Answer