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?

2417

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

2298

how to restore files with rman?

2304

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

IBM,

2 6601

what is the diffrence between core dba and apps dba?

Cap Gemini,

2570

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

HP,

2115

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 5705

What is the dataguard background process??

iGate,

1 6329

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

iGate,

2729

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 }

Query processing is slow(eg select query)how will u solve that

7912

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1985

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.

2282

what are the benefits of flashback feature?

1024

what do you understand by fine-grained auditing?

1057

What is dbcc? : sql server DBA

1286

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

1887

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2443

What the different topologies in which replication can be configured? : sql server DBA

1268

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

1111

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

1089

how can you implement fine-grained auditing?

1136

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

2066

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

4427

how to restore files with rman?

2304

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