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 10819

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 5596

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 }

how can you process messages in order asynchronously?

976

Why would you use sql agent? : sql server DBA

1084

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

1289

What happens on checkpoint? : sql server DBA

1095

what are the performance views in an oracle rac environment?

1055

how can you find out if a table can be redefined?

1015

what is a user-defined lock?

1065

what is the role of dip user in our database?

2417

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

1102

What is the difference between dropping a database and taking a database offline? : sql server DBA

1069

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2471

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

1217

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

1188

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1987

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