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 7122

Explain an ORA-01555

2 6797

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 18706

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

2 10804

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 9024

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

1 4623

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2328

Explain the use of table functions.

1 5546

Name three advisory statistics you can collect.

1 5578

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

1 8473

Explain materialized views and how they are used.

2436

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

1 9673

What background process refreshes materialized views?

Accenture, FLSmidth,

2 12534

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

2 8727

Describe what redo logs are.

1 5076

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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 to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

2083

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

1262

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

2628

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

988

What are the different types of upgrades that can be performed in sql server? : sql server DBA

1203

how to restore files with rman?

2293

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

2147

internal architecture

2184

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?

1982

What is a system database and what is a user database? : sql server DBA

1215

What is dcl? : sql server DBA

1254

How to start SQL Server in minimal configuration mode?

7953

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

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1989

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