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 19959

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

2 10718

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,

2851

Compare and contrast TRUNCATE and DELETE for a table.

7 15789

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 7621

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 8069

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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

2230

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

1217

which background process invoke at the time of upgradation tell me???

2729

Why does Oracle not permit the use of PCTUSED with indexes?

2943

what is a user-defined lock?

1065

how can you communicate with operating system files from oracle?

1051

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

2113

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

2298

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

2436

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

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

2043

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

1077

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

1081

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

1008

What is transparent data encryption? : sql server DBA

1194

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