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 1451

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

980

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

1 2539




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

1402

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

STC,

1 2429

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

1 4605

What is blocking and how would you troubleshoot it?

1 4215

Explain CREATE DATABASE syntax?

2 4881




How to start SQL Server in minimal configuration mode?

1 4736

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

3 4341

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

1 3029

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

1 2103

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

1 2010

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

TCS,

7 13538

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 7319


Post New DB Administration Questions






Un-Answered Questions { DB Administration }

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

654


How to start SQL Server in minimal configuration mode?

4736


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

919


can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

578


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

1372


what are the differences of where and if in SAS?

838


Why does Oracle not permit the use of PCTUSED with indexes?

1483


Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

759


How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

1018


Explain materialized views and how they are used.

945


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.

1187


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

1406


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

785


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1521


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

980