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 ora 24313?what is the procedure to exclude that error?

2559

the process of adding a cpu in sql server is called..?

TCS,

2 5421

1)how to Take Backup in sql server 2005 from Flash Drive

1 3243

In oracle 10g export, import if we declare rows=y/n what would be the output?

Value Labs,

2933

what is the purpose of catlaog in oracle rman?

Value Labs,

2 5375

what is the difference between hot backup n rman backup?

Value Labs,

1 15280

A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?

TCS,

1 4474

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

IBM,

2056

i had backup last manday.now i need back monday to now ..how do get backup?

Infozech, Wipro,

3 6111

now one user in online.now i want drop him..how do u drop him?

Wipro,

4 6572

what is the differnce between process and thread ?

IBM,

1 4839

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1744

What is the difference between online backup & offline backup?

CSC,

3 10882

what is the difference between catalog & nocatalog?

CSC,

3 21601

internal architecture

CSC,

2184

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1744

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

1091

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

1055

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?

2798

What are statistics, under what circumstances they go out of date, how do you update them?

2238

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

1095

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1982

What is dbcc? : sql server DBA

1278

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

2186

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2098

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2403

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

2626

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

999

What are the recovery models for a database? : sql server DBA

1123

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2498

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