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 would you go about increasing the buffer cache hit ratio?

2 7141

Explain an ORA-01555

2 6807

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 18729

How would you determine the time zone under which a database was operating?

2 10818

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 9028

What command would you use to encrypt a PL/SQL application?

1 4636

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2338

Explain the use of table functions.

1 5555

Name three advisory statistics you can collect.

1 5595

Where in the Oracle directory tree structure are audit traces placed?

1 8491

Explain materialized views and how they are used.

2443

When a user process fails, what background process cleans up after it?

1 9684

What background process refreshes materialized views?

Accenture, FLSmidth,

2 12550

How would you determine what sessions are connected and what resources they are waiting for?

2 8742

Describe what redo logs are.

1 5080

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2338

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

1217

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

1571

What is fill factor? : sql server DBA

1249

how to restore files with rman?

2304

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2203

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2109

Explain materialized views and how they are used.

2443

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2636

how can you schedule a job in database?

1124

what is grd?

1096

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

1005

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

4349

What would you do with an "in-doubt" distributed transaction?

1887

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

2440

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