Oracle Dba Interview Question and Answers

106. What is auditing used for?
  Auditing is used either to characterize database activity or to find the source of suspicious activity.
 
Your Name Your Email-ID
Your Answer
107. What is the difference between a temporary table space and a permanent table space?
 
  • A temporary tablespace provides temporary storage during the processing of database function, such as sorting; whereas
  • A permanent tablespace is used to store permanent database objects, such as tables, partitions, indexes and clusters.
 
Your Name Your Email-ID
Your Answer
108. What is a log file group?
  A log file group is a set of log files that is used to store system redo information. By having a group of log files, Oracle will automatically mirror redo information to the log files in the groups.
 
Your Name Your Email-ID
Your Answer
109. What is RMAN?
  RMAN is an Oracle supplied tool or utility that can be used to manage backup and recovery activities.
 
Your Name Your Email-ID
Your Answer
110. What is ACFS?
  ACFS provides an Oracle Home shared file system or a general cluster file system on ASM storage. It needs ASM Dynamic Volume Manager(ADVM) to communicate to the operating system.
 
Your Name Your Email-ID
Your Answer
123456789101112131415


16171819202122 Page 22 of 22