Database Management Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Database Management Interview Questions

Questions Answers Views Company eMail

IF Statements BLOCK 1 . IF a >= b THEN do_this …..; ELSE do_that….; END IF BLOCK 2 . IF a < b THEN do_that …..; ELSE do_this….; END IF; • Given any pair of non-NULL values for “a” and”b”, will Block 1 and Block 2 do the same thing? • What if either “a” or”b” (or both) is NULL?

2223

what is candidate key & primary key,different b/t the two?

3 5922

Can we update table which is created from view?

IBM, Punjab National Bank,

2 5135

I am using Oracle 10g and want to access the default tables of 9i? how? Any script and how to use it please mail me @ rashi.sandhu@gmail.com........

1 3593

is it sufficient to normalize a database up to 3NF?

4 7097

What is the difference between oracle CPU and PSU?

2 20802

1)How to check tablespace utilization? 2)what are the RMAN CLONING STEPS? 3)what is standby database? 4)what is difference between standalone database and target database? 5)How to backup the standalone database? 6)tell about the ubgrade steps? 7)How to apply the pathes?

Wipro,

2215

1)what is the difference between view and materilized view? 2)what is the difference between delete and truncate? 3)what is the difference between migration and upgration? 4)what is the difference between RMAN HOT BACKUP and normal hot backup?

3i Infotech,

2 6059

WHEN YOU FIRE A QUERY IT WILL SLOW WHAT WILL U DO.

CTS, iNautix, TCS,

4 8547

i want to know real time experience on oracle dba anybody help me please mail me aniltelkar50@gmail.com

IBM,

1 4644

what is ORACLE CLINICAL What are the uses of Oracle clinical

1 10596

How can we check whether A S M instance is up or down?

Excelacom, HCL,

2421

How can we tune if buffer busy wait issue comes in oracle?

IBM,

1 3804

How can we tune a oracle database if log file sync issue comes

L&T,

2107

how to join two table?

iNautix,

2 4930

Post New Database Management Questions

Un-Answered Questions { Database Management }

How do you create a database?

913

Explain what is a deadlock and mention how it can be resolved?

886

What are the advantages of dbms?

938

Explain relational algebra?

933

What is write ahead logging in DBMS?

1089

What are the package used in DBMS ?

2614

Why is rdbms important?

875

What is the structure of a database?

927

What is cold backup, hot backup, warm backup recovery?

830

Is the internet a database?

937

What do you mean by index hunting?

1097

What is 2nf in dbms?

1100

Define denormalization.

1169

What is database write application of database?

899

What entity means?

864

For More Un-Answered { Database Management } Questions Click Here