Oracle Admin Interview Question and Answers

29. How can you backup the parameter files?
  RMAN can be used to backup SPFILE with control file if CONFIGURE CONTROLFILE AUTOBACKUP is ON.
The following RMAN command can be used to backup the control file:
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
The following RMAN command can be used restore an SPFILE:
RMAN> RESTORE CONTROL FILE FROM AUTOBACKUP;
 
Your Name Your Email-ID
Your Answer
30. What happens after a user process fails?
  PMON cleans up the memory after user process fails.
 
Your Name Your Email-ID
Your Answer
31. What happens when multiple users try to update the same set of data?
  Oracle uses locking mechanism to ensure that only one session or user can update a single set of data at given point in time.
 
Your Name Your Email-ID
Your Answer
32. How can you convert SPFILE to PFILE to SPFILE?
  One can easily migrate from a PFILE to SPFILE or vice versa.
Execute the following commands from a user with the
SYSDBA or SYSOPER privilege:
SQL> CREATE PFILE FROM SPFILE;
SQL> CREATE SPFILE FROM PFILE;
 
Your Name Your Email-ID
Your Answer
12345678910 Page 8 of 10