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 do you switch from an init.ora file to a spfile?

TCS,

4 19968

Explain the difference between a data block, an extent and a segment.

2 10730

Give two examples of how you might determine the structure of the table DEPT.

2 11538

Where would you look for errors from the database engine?

IBM,

2859

Compare and contrast TRUNCATE and DELETE for a table.

7 15807

Give the reasoning behind using an index.

2 8694

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 7631

What type of index should you use on a fact table?

1 3971

Give two examples of referential integrity constraints.

2 8624

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?

2519

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 24489

What command would you use to create a backup control file?

2 5315

Give the stages of instance startup to a usable state where normal users may access it.

1 3429

What column differentiates the V$ views to the GV$ views and how?

3 10548

How would you go about generating an EXPLAIN plan?

2 8081

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

Where do you find the default index fill factor and how to change it? : sql server DBA

1082

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.

2286

What is a system database and what is a user database? : sql server DBA

1240

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

999

How to start SQL Server in minimal configuration mode?

7983

how does an oracle clusterware manage crs resources?

1093

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

2467

What are the commands used in dcl? : sql server DBA

1077

What happens on checkpoint? : sql server DBA

1099

suppose you want to audit specific activities on sensitive data. How can you achieve that?

1005

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

1031

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

2110

Why would you call update statistics? : sql server DBA

995

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

1274

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1986

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