| Other DB Administration Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is ora 600? | | 1 |
| How do you resize a data file? | | 2 |
| What are the different ways of moving data or databases
between servers and databases in SQL Server?
| | 2 |
| Name two files used for network connection to a database. | | 4 |
| How to start SQL Server in minimal configuration mode? | | 1 |
| You have just compiled a PL/SQL package but got errors, how
would you view the errors? | | 3 |
| Explain the difference between $ORACLE_HOME and $ORACLE_BASE. | | 2 |
| What is the difference between a TEMPORARY tablespace and a
PERMANENT tablespace? | | 1 |
| Explian different types of BACKUPs avaialabe in SQL Server?
Given a particular scenario, how would you go about
choosing a backup plan? | | 1 |
| Explain CREATE DATABASE syntax? | | 1 |
| What does coalescing a tablespace do? | | 1 |
| How to make a replica of existing oracle server to another
server?
| | 1 |
| Name a tablespace automatically created when you create a
database. | | 4 |
| Give two examples of referential integrity constraints. | | 1 |
| How would you force a log switch? | | 3 |
| Explain the difference between a data block, an extent and a
segment. | | 1 |
| What is the difference between the SQL Loader and IMPORT
utilities? | | 2 |
| When a user process fails, what background process cleans up
after it? | | 1 |
| How would you go about generating an EXPLAIN plan? | | 1 |
| How do you find out from the RMAN catalog if a particular
archive log has been backed-up? | | 2 |
| |
| For more DB Administration Interview Questions Click Here |
Site Map
