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 13847

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

2 11504

What does coalescing a tablespace do?

1 15496

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

2 7154

Name a tablespace automatically created when you create a database.

5 12654

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

3 8828

How do you add a data file to a tablespace?

3 7893

How do you resize a data file?

2 14086

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

3 8873

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

3 9415

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

4 11351

How can you rebuild an index?

6 13879

Explain what partitioning is and what its benefit is.

2 7366

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

3 9498

How can you gather statistics on a table?

3 17785

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2680

when does an alert gets signaled?

1052

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

3217

how can a session indicate its interest in receiving alerts?

1044

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1077

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

1024

Can you redefine a table online?

1117

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1288

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

1005

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

1268

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

2109

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

1199

how can you process messages in order asynchronously?

976

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?

2513

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

1571

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