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 13833

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

2 11490

What does coalescing a tablespace do?

1 15487

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

2 7138

Name a tablespace automatically created when you create a database.

5 12629

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

3 8814

How do you add a data file to a tablespace?

3 7878

How do you resize a data file?

2 14068

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

3 8856

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

3 9389

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

4 11332

How can you rebuild an index?

6 13847

Explain what partitioning is and what its benefit is.

2 7350

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

3 9480

How can you gather statistics on a table?

3 17768

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What are the different sql server versions you have worked on? : sql server DBA

1007

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2613

what is the role of dip user in our database?

2410

what is ora 24313?what is the procedure to exclude that error?

2561

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2712

Where would you look for errors from the database engine?

2846

What are the recovery models for a database? : sql server DBA

1124

Explain materialized views and how they are used.

2436

Why would you use sql agent? : sql server DBA

1076

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

4423

Which autogrowth database setting is good? : sql server DBA

1146

what are the benefits of flashback feature?

1019

when does an alert gets signaled?

1043

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

1012

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.

2559

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