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 19789

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

2 10623

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

2 11396

Where would you look for errors from the database engine?

IBM,

2802

Compare and contrast TRUNCATE and DELETE for a table.

7 15530

Give the reasoning behind using an index.

2 8559

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

2 7536

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

1 3887

Give two examples of referential integrity constraints.

2 8490

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?

2410

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

5 24249

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

2 5184

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

1 3323

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

3 10391

How would you go about generating an EXPLAIN plan?

2 7970

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1923

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2522

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

960

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

7777

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

1043

What is a correlated sub-query? : sql server DBA

1015

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

2405

how can you implement fine-grained auditing?

1075

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1203

What are the commands you'd issue to show the explain plan for "select * from dual"?

2193

Why would you use sql agent? : sql server DBA

1028

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

942

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.

2105

What is dcl? : sql server DBA

1197

what are the types of connection load-balancing?

944

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