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 20114

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

2 10808

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

2 11656

Where would you look for errors from the database engine?

IBM,

2897

Compare and contrast TRUNCATE and DELETE for a table.

7 16047

Give the reasoning behind using an index.

2 8787

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

2 7734

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

1 4037

Give two examples of referential integrity constraints.

2 8734

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?

2580

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

5 24723

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

2 5429

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

1 3491

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

3 10658

How would you go about generating an EXPLAIN plan?

2 8193

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

how can you communicate with operating system files from oracle?

1096

Explain materialized views and how they are used.

2501

what is grd?

1157

how can you schedule a job in database?

1196

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

1079

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

3812

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

1224

how can you find out if a table can be redefined?

1062

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

1152

how can you connect from 10g user to 11g user??

2169

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2673

What purpose does the model database server? : sql server DBA

1273

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

2155

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2392

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1964

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