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 19738

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

2 10605

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

2 11386

Where would you look for errors from the database engine?

IBM,

2791

Compare and contrast TRUNCATE and DELETE for a table.

7 15483

Give the reasoning behind using an index.

2 8540

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

2 7512

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

1 3866

Give two examples of referential integrity constraints.

2 8464

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?

2397

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

5 24197

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

2 5170

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

1 3317

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

3 10370

How would you go about generating an EXPLAIN plan?

2 7953

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1986

Where would you look for errors from the database engine?

2791

Query processing is slow(eg select query)how will u solve that

7754

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

1232

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

1021

how can you create a user-defined lock?

959

What would you do with an "in-doubt" distributed transaction?

1830

What is fill factor? : sql server DBA

1181

How would you extract DDL of a table without using a GUI tool?

2440

what are the performance views in an oracle rac environment?

1000

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

1028

How do you open a cluster administrator? : sql server DBA

1032

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

1919

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2364

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2134

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