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,

1081

what are the performance views in an oracle rac environment?

Oracle,

1049

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

Oracle,

1060

how can you initialize log miner?

Oracle,

1135

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

1075

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

1558

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

1095

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

1304

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

1021

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

1259

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

1175

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

999

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

1124

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

988

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

1171

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What are the different types of indexes available in sql server? : sql server DBA

1188

what is a crs resource?

1160

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2403

how can you record information about current session?

1040

What is transparent data encryption? : sql server DBA

1186

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

1091

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2328

what is the role of dip user in our database?

2410

how can a session indicate its interest in receiving alerts?

1037

how can you enable flashback feature?

943

what do you understand by fine-grained auditing?

1049

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

2162

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2454

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1108

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

4341

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