| Other DB Administration Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| You have just had to restore from backup and do not have any
control files. How would you go about bringing up this database? | | 2 |
| what is ora 600? | | 1 |
| When a user process fails, what background process cleans up
after it? | | 1 |
| When creating a user, what permissions must you grant to
allow them to connect to the database? | | 2 |
| What command would you use to create a backup control file? | | 1 |
| How can you enable a trace for a session? | | 1 |
| What is the difference between the SQL Loader and IMPORT
utilities? | | 2 |
| Give the reasoning behind using an index. | | 2 |
| What view would you use to look at the size of a data file? | | 2 |
| Name two files used for network connection to a database. | | 4 |
| How would you determine who has added a row to a table? | | 3 |
| Compare and contrast TRUNCATE and DELETE for a table. | | 4 |
| What are the different ways of moving data or databases
between servers and databases in SQL Server?
| | 2 |
| How would you determine the time zone under which a database
was operating? | | 2 |
| What column differentiates the V$ views to the GV$ views and
how? | | 1 |
| How would you force a log switch? | | 3 |
| What is a deadlock and what is a live lock? How will you go
about resolving deadlocks? | | 1 |
| Name a tablespace automatically created when you create a
database. | | 4 |
| What is blocking and how would you troubleshoot it? | | 1 |
| How would you determine what sessions are connected and what
resources they are waiting for? | | 2 |
| |
| For more DB Administration Interview Questions Click Here |