DB Administration Interview Questions
Questions Answers Views Company eMail

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

IBM,

1 1368

What are statistics, under what circumstances they go out of date, how do you update them?

944

What is RAID and what are different types of RAID configurations?

1 2471




What are the steps you will take to improve performance of a poor performing query?

1355

What are the steps you will take, if you are tasked with securing an SQL Server?

STC,

1 2351

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 4505

What is blocking and how would you troubleshoot it?

1 4120

Explain CREATE DATABASE syntax?

2 4763




How to start SQL Server in minimal configuration mode?

1 4613

What are the different ways of moving data or databases between servers and databases in SQL Server?

3 4181

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 2955

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 2017

How to determine the service pack currently installed on SQL Server?

1 1951

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

TCS,

7 13139

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 7192


Post New DB Administration Questions






Un-Answered Questions { DB Administration }

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

1148


i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

744


What are statistics, under what circumstances they go out of date, how do you update them?

944


What are the steps you will take to improve performance of a poor performing query?

1355


What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

1231


when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

477


In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

1368


What are the commands you'd issue to show the explain plan for "select * from dual"?

763


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2321


How to start SQL Server in minimal configuration mode?

4613


How would you extract DDL of a table without using a GUI tool?

1072


A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

1040


Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

969


I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

2806


Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

893