Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 2866

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

1631

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

1 3813

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

2232

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

STC,

1 3870

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

1 5850

What is blocking and how would you troubleshoot it?

1 5501

Explain CREATE DATABASE syntax?

2 6288

How to start SQL Server in minimal configuration mode?

1 6514

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

3 6439

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

1 4136

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

1 3338

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

1 3124

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

TCS,

7 18258

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 9555


Post New DB Administration Questions

Un-Answered Questions { DB Administration }

Which autogrowth database setting is good? : sql server DBA

388


Why would you use sql agent? : sql server DBA

407


Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

426


What is the default port no on which sql server listens? : sql server DBA

375


how can you implement fine-grained auditing?

433






What is the difference between clustered and non-clustered index? : sql server DBA

384


Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

1671


Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

421


What are the different ways you can create databases in sql server? : sql server DBA

414


what do you understand by fine-grained auditing?

401


What are the different sql server versions you have worked on? : sql server DBA

377


suppose you want to audit specific activities on sensitive data. How can you achieve that?

369


How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

473


How can you control the amount of free space in your index pages? : sql server DBA

498


How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

1868