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 r the types of backup?

CSC,

5 7029

how will u see whether the dabase is in archive log mode or not?

CSC,

2 4274

by issuing "alter tablespace begin backup;" what happens to tablespace?

CSC, Logica CMG,

5 9109

which background process will run @ the time of creation of catalog database

CSC,

1 4499

What is the difference between Datapump & export/import?

2 11925

Can we take incremental backups in datapump?

1 11452

Datapump backup steps?

1 5147

How will u copy the objects of one schema to another schema in datapump & export/import?

1 5155

What is checkpoint?

Accenture,

3 5654

Oracle 11g new features?

2 11735

Hot backup procedure?

2 4864

If we issue alter database begin backup. What happens to database?

2 7206

deleted of control file how will u recover control file?

CTS,

4 8709

What is the difference between LMT & DLT?

CTS,

1 7322

why we use cursors

1 3614

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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

2367

What the different types of replication and why are they used? : sql server DBA

1107

What types of replication are supported in sql server? : sql server DBA

1226

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.

2115

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2279

what is a user-defined lock?

986

Where would you look for errors from the database engine?

2794

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.

2519

what are the differences of where and if in SAS?

2136

what is the role of dip user in our database?

2367

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2411

how can you get actual data change values from previous transactions in oracle?

1040

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

953

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

1038

How would you best determine why your MVIEW couldn't FAST REFRESH?

2296

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