Follow Our FB Page << CircleMedia.in >> 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?

1804


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

397


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?

2806


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

1353


how can you record information about current session?

354






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

507


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

418


how does an oracle clusterware manage crs resources?

415


what is logical system in sap basis

963


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

421


how can you process messages in order asynchronously?

413


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

386


what are the differences of where and if in SAS?

1467


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

441


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

2598