DB Administration Interview Questions
Questions Answers Views Company eMail

what is the role of dip user in our database?

2053

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

DELL, TCS,

4 7342

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

1839

how to restore files with rman?

1755

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

IBM,

2 5381

what is the diffrence between core dba and apps dba?

Cap Gemini,

2094

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

HP,

1685

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

2 2898

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 4822

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

HP,

2 4961

what is the use of home directory???

HP,

1 3995

what is rebuild index??

IBM, Sapient,

2 4728

What is the dataguard background process??

iGate,

1 5372

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

iGate,

2233

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

TCS,

1 3409


Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What are the different types of upgrades that can be performed in sql server? : sql server DBA

686


What is transparent data encryption? : sql server DBA

567


Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2196


What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2112


Can you redefine a table online?

675






what are the differences of where and if in SAS?

1666


What happens on checkpoint? : sql server DBA

564


how can you enable flashback feature?

540


what is logical system in sap basis

1145


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

1839


suppose you want to audit specific activities on sensitive data. How can you achieve that?

552


Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

605


what functionality does oracle provide to secure sensitive information?

559


how to restore files with rman?

1755


Which autogrowth database setting is good? : sql server DBA

581