DB Administration Interview Questions
Questions Answers Views Company eMail

what is the role of dip user in our database?

2253

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

DELL, TCS,

4 8173

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

2072

how to restore files with rman?

2002

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

IBM,

2 5986

what is the diffrence between core dba and apps dba?

Cap Gemini,

2341

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

HP,

1940

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

2 3373

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 5198

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

HP,

2 5582

what is the use of home directory???

HP,

1 4714

what is rebuild index??

IBM, Sapient,

2 5187

What is the dataguard background process??

iGate,

1 5835

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

iGate,

2496

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

TCS,

1 3745


Post New DB Administration Questions

Un-Answered Questions { DB Administration }

how can a session indicate its interest in receiving alerts?

812


what is a user-defined lock?

793


who owns the operating system files created by the utl_file package?

847


What is the difference between dropping a database and taking a database offline? : sql server DBA

849


what is the role of dip user in our database?

2253


when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1465


What are the commands you'd issue to show the explain plan for "select * from dual"?

2022


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

776


What are the recovery models for a database? : sql server DBA

854


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.

1991


If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

797


Explain about your sql server dba experience? : sql server DBA

821


can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1551


what are the differences of where and if in SAS?

1919


how can you implement fine-grained auditing?

860