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?

2415

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

DELL, TCS,

4 9053

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

2295

how to restore files with rman?

2302

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

IBM,

2 6596

what is the diffrence between core dba and apps dba?

Cap Gemini,

2568

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

HP,

2113

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

2 3865

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 5674

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

HP,

2 6232

what is the use of home directory???

HP,

1 5309

what is rebuild index??

IBM, Sapient,

2 5704

What is the dataguard background process??

iGate,

1 6329

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

iGate,

2727

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

TCS,

1 4129

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What is dbcc? : sql server DBA

1283

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

3215

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.

2166

Why would you use sql agent? : sql server DBA

1081

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

2107

how can you process messages in order asynchronously?

974

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

2727

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

1286

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

2278

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

2617

what do you understand by flashback feature of oracle?

993

What purpose does the model database server? : sql server DBA

1184

What the different types of replication and why are they used? : sql server DBA

1176

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1116

What is dcl? : sql server DBA

1267

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