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 19956

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

2 10716

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

2 11523

Where would you look for errors from the database engine?

IBM,

2849

Compare and contrast TRUNCATE and DELETE for a table.

7 15788

Give the reasoning behind using an index.

2 8682

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

2 7620

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

1 3967

Give two examples of referential integrity constraints.

2 8612

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?

2511

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

5 24465

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

2 5306

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

1 3425

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

3 10536

How would you go about generating an EXPLAIN plan?

2 8065

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What are statistics, under what circumstances they go out of date, how do you update them?

2250

Explain materialized views and how they are used.

2441

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

2435

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

2439

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

1001

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2470

what is the use of ocr?

1032

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

2410

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

1109

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

1005

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

1080

What is replication? : sql server DBA

1174

what are the benefits of flashback feature?

1022

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2336

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

4426

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