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 5923

Can we update table which is created from view?

IBM, Punjab National Bank,

2 5136

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 7100

What is the difference between oracle CPU and PSU?

2 20804

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 8552

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 10598

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 4932

Post New Database Management Questions

Un-Answered Questions { Database Management }

What do you mean by e-r model?

1000

What is difference between database and server?

1001

What is big data in database?

882

What are the elements of a database?

919

What is the structure of a table in database?

965

What does partition mean in database?

908

Where is database stored?

876

Where is data stored in a database?

1001

Is database a data structure?

869

What is a candidate key in a database?

888

What is normalisation and its type?

928

What is data redundancy in dbms?

908

What's the best database software for mac?

934

What restrictions can you apply when you are creating views?

893

What is difference between database and dbms?

990

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