DB Administration Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB Administration Interview Questions

Questions Answers Views Company eMail

what is the role of dip user in our database?

2409

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

DELL, TCS,

4 9014

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

2284

how to restore files with rman?

2293

how will you see when the database was started using sql prompt?

IBM,

2 6571

what is the diffrence between core dba and apps dba?

Cap Gemini,

2561

how can you connect from 10g user to 11g user??

HP,

2102

one datafile is lost in standy side how can you recover that??

2 3843

i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

iGate,

1 5664

I lost one datafile i dont have backup how can you recover that???

HP,

2 6216

what is the use of home directory???

HP,

1 5306

what is rebuild index??

IBM, Sapient,

2 5693

What is the dataguard background process??

iGate,

1 6315

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

iGate,

2718

any body know about orawaves do they really provide placements in their unique placement program

TCS,

1 4113

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

998

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

1879

Which autogrowth database setting is good? : sql server DBA

1144

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

981

Can you redefine a table online?

1109

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

1744

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2326

what is the use of recording information about current session?

1046

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

1255

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

2186

how can you record information about current session?

1038

how can you process messages in order asynchronously?

968

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

1072

what are the types of connection load-balancing?

994

What are the different types of database compression introduced in sql server 2008? : sql server DBA

1092

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