DB Administration Interview Questions
Questions Answers Views Company eMail

what is the role of dip user in our database?

2150

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

DELL, TCS,

4 7768

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

1972

how to restore files with rman?

1871

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

IBM,

2 5735

what is the diffrence between core dba and apps dba?

Cap Gemini,

2233

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

HP,

1826

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

2 3156

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 5022

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

HP,

2 5227

what is the use of home directory???

HP,

1 4405

what is rebuild index??

IBM, Sapient,

2 4996

What is the dataguard background process??

iGate,

1 5620

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

iGate,

2394

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

TCS,

1 3598


Post New DB Administration Questions

Un-Answered Questions { DB Administration }

what functionality does oracle provide to secure sensitive information?

689


how to restore files with rman?

1871


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

1538


What are the operating modes in which database mirroring runs? : sql server DBA

759


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

2394






What is dcl? : sql server DBA

805


What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2329


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

1826


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

1773


What are the different ways you can create databases in sql server? : sql server DBA

718


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

2887


Why does Oracle not permit the use of PCTUSED with indexes?

2483


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

664


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

2159


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?

1668