DB Administration Interview Questions
Questions Answers Views Company eMail

How would you force a log switch?

4 13020

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

2 11072

What does coalescing a tablespace do?

1 15009

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

2 6603

Name a tablespace automatically created when you create a database.

5 11554

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

3 8265

How do you add a data file to a tablespace?

3 7230

How do you resize a data file?

2 13508

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

3 8167

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

3 8912

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

4 10483

How can you rebuild an index?

6 12768

Explain what partitioning is and what its benefit is.

2 6827

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

3 8970

How can you gather statistics on a table?

3 17106


Post New DB Administration Questions

Un-Answered Questions { DB Administration }

suppose you want to audit specific activities on sensitive data. How can you achieve that?

792


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

3006


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

1739


Explain materialized views and how they are used.

2175


Why would you call update statistics? : sql server DBA

799


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?

2245


what is grd?

890


What is a correlated sub-query? : sql server DBA

811


Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

2072


how does an oracle clusterware manage crs resources?

811


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2609


What would you do with an "in-doubt" distributed transaction?

1683


In what script is "snap$" created? In what script is the "scott/tiger" schema created?

2226


how can you implement fine-grained auditing?

860


What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2362