| Other DB Administration Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How would you determine the time zone under which a database
was operating? | | 2 |
| What are the different ways of moving data or databases
between servers and databases in SQL Server?
| | 2 |
| What is RAID and what are different types of RAID
configurations? | | 1 |
| Explain an ORA-01555 | | 1 |
| Can you take Online Backups if the the database is running
in NOARCHIVELOG mode?
5. How do you bring the database in ARCHIVELOG mode from
NOARCHIVELOG mode?
6. You cannot shutdown the database for even some minutes,
then in which mode you should run
the database?
| Wipro | 2 |
| What does coalescing a tablespace do? | | 1 |
| How to start SQL Server in minimal configuration mode? | | 1 |
| How can you gather statistics on a table? | | 2 |
| What is the difference between the SQL Loader and IMPORT
utilities? | | 2 |
| Give the two types of tables involved in producing a star
schema and the type of data theyhold. | | 1 |
| Name two files used for network connection to a database. | | 4 |
| What type of index should you use on a fact table? | | 1 |
| Give the reasoning behind using an index. | | 1 |
| Give two examples of how you might determine the structure
of the table DEPT. | | 2 |
| what is ora 600? | | 1 |
| How to determine the service pack currently installed on
SQL Server? | | 1 |
| How do you add a data file to a tablespace? | | 1 |
| How can you rebuild an index? | | 4 |
| What is a deadlock and what is a live lock? How will you go
about resolving deadlocks? | | 1 |
| When creating a user, what permissions must you grant to
allow them to connect to the database? | | 2 |
| |
| For more DB Administration Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
