Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

DB Administration Interview Questions
Questions Answers Views Company eMail

How would you force a log switch?

4 11345

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

2 10149

What does coalescing a tablespace do?

1 14287

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

2 5636

Name a tablespace automatically created when you create a database.

5 9732

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

3 7169

How do you add a data file to a tablespace?

3 6198

How do you resize a data file?

2 12653

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

3 6957

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

3 7812

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

4 9068

How can you rebuild an index?

6 10898

Explain what partitioning is and what its benefit is.

2 6028

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

3 7777

How can you gather statistics on a table?

3 15986

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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


What are the different types of indexes available in sql server? : sql server DBA


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?


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


how can you record information about current session?


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


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


how does an oracle clusterware manage crs resources?


what is logical system in sap basis


What are the operating modes in which database mirroring runs? : sql server DBA


how can you process messages in order asynchronously?


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


what are the differences of where and if in SAS?


how can you find out if a table can be redefined?


How would you go about verifying the network name that the local_listener is currently using?