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 7149

Explain an ORA-01555

2 6820

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 18740

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

2 10828

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 9034

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

1 4644

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2346

Explain the use of table functions.

1 5562

Name three advisory statistics you can collect.

1 5602

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

1 8498

Explain materialized views and how they are used.

2446

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

1 9694

What background process refreshes materialized views?

Accenture, FLSmidth,

2 12563

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

2 8749

Describe what redo logs are.

1 5087

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

which background process invoke at the time of upgradation tell me???

2736

Why would you use sql agent? : sql server DBA

1092

internal architecture

2201

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.

2171

what are the types of connection load-balancing?

1002

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

how can you get actual data change values from previous transactions in oracle?

1091

What is the default port no on which sql server listens? : sql server DBA

1164

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

2207

what do you understand by fine-grained auditing?

1062

how can you generate profile of pl/sql applications to identify performance bottlenecks?

1084

What is the default fill factor value? : sql server DBA

1135

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

2067

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

3417

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

4356

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