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 7111

Explain an ORA-01555

2 6789

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 18700

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

2 10800

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 9018

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

1 4616

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2325

Explain the use of table functions.

1 5540

Name three advisory statistics you can collect.

1 5574

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

1 8468

Explain materialized views and how they are used.

2432

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

1 9666

What background process refreshes materialized views?

Accenture, FLSmidth,

2 12522

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

2 8722

Describe what redo logs are.

1 5072

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What is dcl? : sql server DBA

1246

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

7890

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2796

what is a user-defined lock?

1047

Where would you look for errors from the database engine?

2843

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

2429

how to restore files with rman?

2293

when does an alert gets signaled?

1036

Explain about your sql server dba experience? : sql server DBA

1075

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

982

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

1928

what do you understand by fine-grained auditing?

1049

how can you initialize log miner?

1131

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

1093

what is the role of dip user in our database?

2408

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