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 19930

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

2 10699

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

2 11498

Where would you look for errors from the database engine?

IBM,

2843

Compare and contrast TRUNCATE and DELETE for a table.

7 15753

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 7606

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

1 3957

Give two examples of referential integrity constraints.

2 8596

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?

2489

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

5 24427

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

2 5291

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

1 3408

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

3 10514

How would you go about generating an EXPLAIN plan?

2 8057

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What are the different types of indexes available in sql server? : sql server DBA

1182

Explain about your sql server dba experience? : sql server DBA

1076

how can you generate profile of pl/sql applications to identify performance bottlenecks?

1071

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

984

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

1252

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

2098

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2796

What is the default port no on which sql server listens? : sql server DBA

1142

What happens on checkpoint? : sql server DBA

1081

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

1021

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

1302

how can you process messages in order asynchronously?

968

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

1120

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

2494

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.

2263

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