| Other DB Administration Interview Questions |
| |
| Question |
Asked @ |
Answers |
| |
| How do you tell what your machine name is and what is its IP
address? |
| 4 |
| What is RAID and what are different types of RAID
configurations? |
| 1 |
| How do you increase the OS limitation for open files (LINUX
and/or Solaris)? |
| 1 |
| Explain the difference between $ORACLE_HOME and $ORACLE_BASE. |
| 3 |
| Give two examples of referential integrity constraints. |
| 2 |
| what is the differnce between process and thread ? |
IBM | 1 |
| deleted of control file how will u recover control file? |
CTS | 4 |
| What is the difference between the SQL Loader and IMPORT
utilities? |
| 3 |
| How can you rebuild an index? |
| 6 |
| How would you determine what sessions are connected and what
resources they are waiting for? |
| 2 |
| You have just had to restore from backup and do not have any
control files. How would you go about bringing up this database? |
| 3 |
| what is difference between user managed backup and rman backup? |
CTS | 1 |
| |
| For more DB Administration Interview Questions Click Here |