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 3290

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

 1804

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

 1 4240

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

 2417

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

STC,

1 4312

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

 1 6200

What is blocking and how would you troubleshoot it?

 1 5902

Explain CREATE DATABASE syntax?

 2 6919

How to start SQL Server in minimal configuration mode?

 1 6946

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

3 7090

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

 1 4551

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

 1 3846

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

 1 3516

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

TCS,

7 19312

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 10213

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

what is a crs resource?

597

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

1867

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?

2031

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

547

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2175




What types of replication are supported in sql server? : sql server DBA

597

how can you schedule a job in database?

597

what functionality does oracle provide to secure sensitive information?

552

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

654

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1491

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1520

who owns the operating system files created by the utl_file package?

564

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

558

Which autogrowth database setting is good? : sql server DBA

574

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

707

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