DB Administration Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB Administration Interview Questions

Questions Answers Views Company eMail

How would you force a log switch?

4 13629

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

2 11384

What does coalescing a tablespace do?

1 15391

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

2 7000

Name a tablespace automatically created when you create a database.

5 12369

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

3 8691

How do you add a data file to a tablespace?

3 7697

How do you resize a data file?

2 13932

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

3 8721

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

3 9242

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

4 11157

How can you rebuild an index?

6 13600

Explain what partitioning is and what its benefit is.

2 7213

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

3 9349

How can you gather statistics on a table?

3 17610

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What is transparent data encryption? : sql server DBA

1114

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1986

how can you schedule a job in database?

1043

Which autogrowth database setting is good? : sql server DBA

1058

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2404

What is the importance of a recovery model? : sql server DBA

966

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

986

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?

2743

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2060

what is the use of recording information about current session?

994

What the different topologies in which replication can be configured? : sql server DBA

1179

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1936

how to restore files with rman?

2236

how can you initialize log miner?

1084

What is dbcc? : sql server DBA

1217

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