DB Administration Interview Questions
Questions Answers Views Company eMail

what is the role of dip user in our database?

2227

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

DELL, TCS,

4 8060

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

2038

how to restore files with rman?

1957

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

IBM,

2 5903

what is the diffrence between core dba and apps dba?

Cap Gemini,

2313

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

HP,

1908

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

2 3296

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 5144

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

HP,

2 5473

what is the use of home directory???

HP,

1 4620

what is rebuild index??

IBM, Sapient,

2 5129

What is the dataguard background process??

iGate,

1 5777

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

iGate,

2464

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

TCS,

1 3698


Post New DB Administration Questions

Un-Answered Questions { DB Administration }

how can you enable flashback feature?

715


what are the performance views in an oracle rac environment?

807


what is the last version,the release date of that version and fix pack of ibm db2 udb?

1705


what is a crs resource?

855


how to restore files with rman?

1957


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

1650


what do you understand by flashback feature of oracle?

779


I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1707


how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

3178


what is the use of ocr?

788


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

2964


Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1777


What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2198


how can you find out if a table can be redefined?

789


what is a user-defined lock?

769