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 19963

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

2 10726

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

2 11535

Where would you look for errors from the database engine?

IBM,

2858

Compare and contrast TRUNCATE and DELETE for a table.

7 15796

Give the reasoning behind using an index.

2 8689

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

2 7629

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

1 3970

Give two examples of referential integrity constraints.

2 8619

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?

2515

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

5 24484

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

2 5310

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

1 3427

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

3 10545

How would you go about generating an EXPLAIN plan?

2 8076

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What is the difference between clustered and non-clustered index? : sql server DBA

1091

How can you control the amount of free space in your index pages? : sql server DBA

1314

what is asm?

1056

how can you create a user-defined lock?

1022

What are the different types of database compression introduced in sql server 2008? : sql server DBA

1108

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

3413

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

1576

How would you best determine why your MVIEW couldn't FAST REFRESH?

2360

What are the operating modes in which database mirroring runs? : sql server DBA

1188

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?

2685

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1114

how can you process messages in order asynchronously?

976

Which autogrowth database setting is good? : sql server DBA

1161

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

2300

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

1293

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