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 19958

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 11528

Where would you look for errors from the database engine?

IBM,

2850

Compare and contrast TRUNCATE and DELETE for a table.

7 15788

Give the reasoning behind using an index.

2 8685

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 3969

Give two examples of referential integrity constraints.

2 8615

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?

2513

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

5 24469

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 3426

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

3 10539

How would you go about generating an EXPLAIN plan?

2 8068

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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

2440

How would you best determine why your MVIEW couldn't FAST REFRESH?

2360

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1760

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2338

who owns the operating system files created by the utl_file package?

1074

how can you create a user-defined lock?

1019

what are the performance views in an oracle rac environment?

1055

what do you understand by flashback feature of oracle?

995

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

7911

What is fill factor? : sql server DBA

1249

how can you initialize log miner?

1146

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

3761

What authentication modes does sql server support? : sql server DBA

1217

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

2153

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

2471

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