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 14026

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

2 11629

What does coalescing a tablespace do?

1 15608

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

2 7273

Name a tablespace automatically created when you create a database.

5 12877

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

3 8947

How do you add a data file to a tablespace?

3 8063

How do you resize a data file?

2 14206

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

3 9006

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

3 9533

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

4 11504

How can you rebuild an index?

6 14119

Explain what partitioning is and what its benefit is.

2 7534

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

3 9640

How can you gather statistics on a table?

3 17928

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2033

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

1166

Which autogrowth database setting is good? : sql server DBA

1244

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

2526

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2687

How to start SQL Server in minimal configuration mode?

8093

what is the use of recording information about current session?

1112

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2018

how to restore files with rman?

2362

How do you trace the traffic hitting a sql server? : sql server DBA

1634

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

2355

how can you schedule a job in database?

1195

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2618

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

8051

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2089

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