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 6652

Explain an ORA-01555

2 6316

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 18062

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

2 10168

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 8666

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

1 4243

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2089

Explain the use of table functions.

1 5200

Name three advisory statistics you can collect.

1 5224

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

1 8146

Explain materialized views and how they are used.

2174

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

1 9342

What background process refreshes materialized views?

Accenture, FLSmidth,

2 11933

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

2 8278

Describe what redo logs are.

1 4676

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

what is logical system in sap basis

1399

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

810

how to restore files with rman?

2002

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

846

how can you record information about current session?

765

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

776

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2447

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

2072

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

822

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1551

Where do you find the default index fill factor and how to change it? : sql server DBA

838

What is transparent data encryption? : sql server DBA

848

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2089

suppose you want to audit specific activities on sensitive data. How can you achieve that?

792

How would you go about verifying the network name that the local_listener is currently using?

3006

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