DB Administration Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB Administration Interview Questions

Questions Answers Views Company eMail

what is the role of dip user in our database?

2419

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

DELL, TCS,

4 9075

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

2309

how to restore files with rman?

2307

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

IBM,

2 6615

what is the diffrence between core dba and apps dba?

Cap Gemini,

2577

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

HP,

2117

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

2 3877

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 5683

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

HP,

2 6243

what is the use of home directory???

HP,

1 5321

what is rebuild index??

IBM, Sapient,

2 5712

What is the dataguard background process??

iGate,

1 6341

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

iGate,

2736

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

TCS,

1 4133

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What is dbcc? : sql server DBA

1298

what is the last version,the release date of that version and fix pack of ibm db2 udb?

1977

what is a user-defined lock?

1072

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2821

how can a session indicate its interest in receiving alerts?

1052

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

1093

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2348

what is the use of ocr?

1036

how can you process messages in order asynchronously?

982

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

2947

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

3766

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

1075

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2049

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2725

Which autogrowth database setting is good? : sql server DBA

1163

For More Un-Answered { DB Administration } Questions Click Here