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?

2464

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

DELL, TCS,

4 9199

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

2350

how to restore files with rman?

2362

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

IBM,

2 6710

what is the diffrence between core dba and apps dba?

Cap Gemini,

2624

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

HP,

2169

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

2 3960

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 5756

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

HP,

2 6363

what is the use of home directory???

HP,

1 5401

what is rebuild index??

IBM, Sapient,

2 5808

What is the dataguard background process??

iGate,

1 6424

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

iGate,

2783

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

TCS,

1 4199

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What is fill factor? : sql server DBA

1309

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

2128

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

1137

what are the benefits of flashback feature?

1094

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.

2356

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

2218

2350

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

1166

What is replication? : sql server DBA

1239

how to restore files with rman?

2362

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1167

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

2559

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

1160

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

1063

What are the different sql server versions you have worked on? : sql server DBA

1071

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