DB Administration Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB Administration Interview Questions

Questions Answers Views Company eMail

how does an oracle clusterware manage crs resources?

Oracle,

1141

what are the performance views in an oracle rac environment?

Oracle,

1127

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

Oracle,

1129

how can you initialize log miner?

Oracle,

1190

What is a correlated sub-query? : sql server DBA

1158

How do you trace the traffic hitting a sql server? : sql server DBA

1634

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

1160

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

1385

What is the importance of a recovery model? : sql server DBA

1083

What the different topologies in which replication can be configured? : sql server DBA

1319

What purpose does the model database server? : sql server DBA

1273

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

1079

What are the recovery models for a database? : sql server DBA

1181

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

1036

What the different types of replication and why are they used? : sql server DBA

1233

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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

1371

How would you best determine why your MVIEW couldn't FAST REFRESH?

2414

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

4411

Query processing is slow(eg select query)how will u solve that

8051

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

2502

how can a session indicate its interest in receiving alerts?

1095

what is asm?

1116

What authentication modes does sql server support? : sql server DBA

1265

which background process invoke at the time of upgradation tell me???

2783

What is a system database and what is a user database? : sql server DBA

1318

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

2000

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

3456

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

1036

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

2902

What are the operating modes in which database mirroring runs? : sql server DBA

1242

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