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 7248

Explain an ORA-01555

2 6920

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 18839

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

2 10957

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 9113

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

1 4713

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2392

Explain the use of table functions.

1 5632

Name three advisory statistics you can collect.

1 5679

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

1 8571

Explain materialized views and how they are used.

2501

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

1 9764

What background process refreshes materialized views?

Accenture, FLSmidth,

2 12672

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

2 8840

Describe what redo logs are.

1 5172

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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

2687

Why does Oracle not permit the use of PCTUSED with indexes?

3020

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 does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2090

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

2350

What happens on checkpoint? : sql server DBA

1146

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2610

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

2902

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

1939

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

1036

what are the performance views in an oracle rac environment?

1127

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

1129

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

1158

how does an oracle clusterware manage crs resources?

1141

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

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