DB Administration Interview Questions
Questions Answers Views Company eMail

what is the role of dip user in our database?

2233

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

DELL, TCS,

4 8109

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

2054

how to restore files with rman?

1971

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

IBM,

2 5933

what is the diffrence between core dba and apps dba?

Cap Gemini,

2325

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

HP,

1920

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

2 3321

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 5165

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

HP,

2 5514

what is the use of home directory???

HP,

1 4654

what is rebuild index??

IBM, Sapient,

2 5145

What is the dataguard background process??

iGate,

1 5801

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

iGate,

2476

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

TCS,

1 3717


Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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.

1971


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

2310


how can you initialize log miner?

854


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3508


what is the role of dip user in our database?

2233


Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2319


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

2199


what is a user-defined lock?

773


What is fill factor? : sql server DBA

905


Where do you find the default index fill factor and how to change it? : sql server DBA

820


how can you communicate with operating system files from oracle?

797


What are the different types of indexes available in sql server? : sql server DBA

827


how does an oracle clusterware manage crs resources?

789


How do you open a cluster administrator? : sql server DBA

797


how can you schedule a job in database?

828