DB Administration Interview Questions
Questions Answers Views Company eMail

what is the role of dip user in our database?

2037

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

DELL, TCS,

4 7282

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

1828

how to restore files with rman?

1738

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

IBM,

2 5338

what is the diffrence between core dba and apps dba?

Cap Gemini,

2077

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

HP,

1674

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

2 2863

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 4794

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

HP,

2 4924

what is the use of home directory???

HP,

1 3937

what is rebuild index??

IBM, Sapient,

2 4693

What is the dataguard background process??

iGate,

1 5342

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

iGate,

2213

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

TCS,

1 3379


Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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

505


Can you redefine a table online?

659


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2381


What is dbcc? : sql server DBA

769


Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2050






how to restore files with rman?

1738


what is the use of recording information about current session?

553


what is the role of dip user in our database?

2037


how can you schedule a job in database?

587


how can you create a user-defined lock?

578


Why would you call update statistics? : sql server DBA

569


What authentication modes does sql server support? : sql server DBA

685


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

615


how does an oracle clusterware manage crs resources?

561


Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

570