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?

2369

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

DELL, TCS,

4 8878

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

2234

how to restore files with rman?

2249

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

IBM,

2 6452

what is the diffrence between core dba and apps dba?

Cap Gemini,

2516

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

HP,

2069

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

2 3743

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 5565

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

HP,

2 6130

what is the use of home directory???

HP,

1 5221

what is rebuild index??

IBM, Sapient,

2 5588

What is the dataguard background process??

iGate,

1 6230

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

iGate,

2667

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

TCS,

1 4046

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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

2656

how can you enable flashback feature?

900

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

1045

What is the importance of a recovery model? : sql server DBA

972

what are the types of connection load-balancing?

944

Which autogrowth database setting is good? : sql server DBA

1075

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2576

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2067

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1062

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

2667

What are the different sql server versions you have worked on? : sql server DBA

968

What happens on checkpoint? : sql server DBA

1041

how does an oracle clusterware manage crs resources?

1037

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2417

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

4390

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