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 7042

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

CSC,

2 4282

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

CSC, Logica CMG,

5 9114

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

CSC,

1 4505

What is the difference between Datapump & export/import?

2 11933

Can we take incremental backups in datapump?

1 11458

Datapump backup steps?

1 5156

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

1 5162

What is checkpoint?

Accenture,

3 5672

Oracle 11g new features?

2 11744

Hot backup procedure?

2 4878

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

2 7215

deleted of control file how will u recover control file?

CTS,

4 8730

What is the difference between LMT & DLT?

CTS,

1 7329

why we use cursors

1 3620

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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

2202

what is the diffrence between core dba and apps dba?

2517

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

2418

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1927

What is a correlated sub-query? : sql server DBA

1015

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?

2751

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

4391

what is a user-defined lock?

998

what are the benefits of flashback feature?

965

What the different components in replication and what is their use? : sql server DBA

1007

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1945

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

1151

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

995

Why would you use sql agent? : sql server DBA

1028

What is dcl? : sql server DBA

1197

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