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

  1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category
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

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