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?

2364

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

DELL, TCS,

4 8838

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

2226

how to restore files with rman?

2236

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

IBM,

2 6441

what is the diffrence between core dba and apps dba?

Cap Gemini,

2510

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

HP,

2061

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

2 3726

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 5552

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

HP,

2 6115

what is the use of home directory???

HP,

1 5192

what is rebuild index??

IBM, Sapient,

2 5576

What is the dataguard background process??

iGate,

1 6207

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

iGate,

2662

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

TCS,

1 4026

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

Why would you use sql agent? : sql server DBA

1016

What are the commands you'd issue to show the explain plan for "select * from dual"?

2186

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

4383

what is grd?

1047

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1053

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2398

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1983

What is the importance of a recovery model? : sql server DBA

966

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

2134

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1660

Which autogrowth database setting is good? : sql server DBA

1058

What happens on checkpoint? : sql server DBA

1031

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?

2446

What is fill factor? : sql server DBA

1181

what functionality does oracle provide to secure sensitive information?

941

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