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 19927

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

2 10697

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

2 11496

Where would you look for errors from the database engine?

IBM,

2843

Compare and contrast TRUNCATE and DELETE for a table.

7 15751

Give the reasoning behind using an index.

2 8668

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

2 7605

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

1 3957

Give two examples of referential integrity constraints.

2 8595

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?

2486

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

5 24421

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

2 5287

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

1 3405

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

3 10509

How would you go about generating an EXPLAIN plan?

2 8056

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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

2454

how can you implement fine-grained auditing?

1118

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

2054

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

1970

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?

2486

What is the importance of a recovery model? : sql server DBA

1021

What is dcl? : sql server DBA

1246

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

What types of replication are supported in sql server? : sql server DBA

1274

Which autogrowth database setting is good? : sql server DBA

1143

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?

2670

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3752

What the different components in replication and what is their use? : sql server DBA

1037

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2537

What is dbcc? : sql server DBA

1270

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