DB Administration Interview Questions
Questions Answers Views Company eMail

How would you force a log switch?

4 11947

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

2 10566

What does coalescing a tablespace do?

1 14584

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

2 6015

Name a tablespace automatically created when you create a database.

5 10457

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

3 7589

How do you add a data file to a tablespace?

3 6563

How do you resize a data file?

2 12978

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

3 7412

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

3 8260

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

4 9621

How can you rebuild an index?

6 11602

Explain what partitioning is and what its benefit is.

2 6341

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

3 8328

How can you gather statistics on a table?

3 16423


Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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

1933


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?

2378


How can you control the amount of free space in your index pages? : sql server DBA

715


what are the types of connection load-balancing?

553


What is the default fill factor value? : sql server DBA

565






currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

1855


You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

3927


Why would you call update statistics? : sql server DBA

567


Can you redefine a table online?

657


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

589


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.

1688


how can you implement fine-grained auditing?

594


Query processing is slow(eg select query)how will u solve that

6479


How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

1891


how can you schedule a job in database?

587