Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

DB Administration Interview Questions
Questions Answers Views Company eMail

what is the role of dip user in our database?

1894

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

DELL, TCS,

4 6809

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

1685

how to restore files with rman?

1584

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

IBM,

2 4733

what is the diffrence between core dba and apps dba?

Cap Gemini,

1896

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

HP,

1512

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

2 2569

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 4528

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

HP,

2 4548

what is the use of home directory???

HP,

1 3539

what is rebuild index??

IBM, Sapient,

2 4353

What is the dataguard background process??

iGate,

1 5008

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

iGate,

2027

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

TCS,

1 3137


Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What is the default port no on which sql server listens? : sql server DBA

395


how can you record information about current session?

356


What is the difference between clustered and non-clustered index? : sql server DBA

401


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

530


what is asm?

424






In what script is "snap$" created? In what script is the "scott/tiger" schema created?

1793


What is transparent data encryption? : sql server DBA

413


what are the differences of where and if in SAS?

1474


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?

2027


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

1361


When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

407


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

1927


how can you create a user-defined lock?

442


What are the different types of database compression introduced in sql server 2008? : sql server DBA

401


how can you initialize log miner?

425