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 13829

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

2 11490

What does coalescing a tablespace do?

1 15486

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

2 7134

Name a tablespace automatically created when you create a database.

5 12618

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

3 8807

How do you add a data file to a tablespace?

3 7866

How do you resize a data file?

2 14064

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

3 8852

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

3 9378

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

4 11327

How can you rebuild an index?

6 13843

Explain what partitioning is and what its benefit is.

2 7349

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

3 9470

How can you gather statistics on a table?

3 17765

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What are the different sql server versions you have worked on? : sql server DBA

1004

How would you extract DDL of a table without using a GUI tool?

2481

what are the benefits of flashback feature?

1015

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

3401

what are the types of connection load-balancing?

994

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

2238

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

2454

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

2186

how to restore files with rman?

2293

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

1928

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

2145

what is the diffrence between core dba and apps dba?

2561

how can you implement fine-grained auditing?

1118

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1254

how can you enable flashback feature?

941

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