DB Administration Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB Administration Interview Questions

Questions Answers Views Company eMail

How would you force a log switch?

4 13666

Give two methods you could use to determine what DDL changes have been made.

2 11408

What does coalescing a tablespace do?

1 15412

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 7033

Name a tablespace automatically created when you create a database.

5 12415

When creating a user, what permissions must you grant to allow them to connect to the database?

3 8721

How do you add a data file to a tablespace?

3 7728

How do you resize a data file?

2 13959

What view would you use to look at the size of a data file?

3 8748

What view would you use to determine free space in a tablespace?

3 9274

How would you determine who has added a row to a table?

4 11198

How can you rebuild an index?

6 13649

Explain what partitioning is and what its benefit is.

2 7238

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 9378

How can you gather statistics on a table?

3 17640

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

Where do you find the default index fill factor and how to change it? : sql server DBA

1035

how does an oracle clusterware manage crs resources?

1039

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?

2414

Can you redefine a table online?

1067

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2419

What is the default port no on which sql server listens? : sql server DBA

1098

how can you create a user-defined lock?

972

what is the diffrence between core dba and apps dba?

2521

What authentication modes does sql server support? : sql server DBA

1150

what are the differences of where and if in SAS?

2142

what is the role of dip user in our database?

2371

what are the types of connection load-balancing?

945

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

945

how can you implement fine-grained auditing?

1079

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1894

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