1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category
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 3279

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

 1799

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

 1 4230

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

 2411

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

STC,

1 4300

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

 1 6193

What is blocking and how would you troubleshoot it?

 1 5895

Explain CREATE DATABASE syntax?

 2 6886

How to start SQL Server in minimal configuration mode?

 1 6938

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

3 7078

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

 1 4541

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

 1 3821

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

 1 3506

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

TCS,

7 19264

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 10191

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

how can you initialize log miner?

569

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

591

Why would you call update statistics? : sql server DBA

570

what is a crs resource?

586

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

505




What are the different types of database compression introduced in sql server 2008? : sql server DBA

558

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

536

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

1647

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

1504

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

3298

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?

1991

How do you open a cluster administrator? : sql server DBA

574

Where do you find the default index fill factor and how to change it? : sql server DBA

545

what functionality does oracle provide to secure sensitive information?

545

how can you communicate with operating system files from oracle?

554

For More Un-Answered { DB Administration } Questions Click Here