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?

2228

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

3 5933

Can we update table which is created from view?

IBM, Punjab National Bank,

2 5146

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 3596

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

4 7113

What is the difference between oracle CPU and PSU?

2 20823

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,

2219

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 6065

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

CTS, iNautix, TCS,

4 8568

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

IBM,

1 4652

what is ORACLE CLINICAL What are the uses of Oracle clinical

1 10610

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

Excelacom, HCL,

2423

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

IBM,

1 3811

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

L&T,

2112

how to join two table?

iNautix,

2 4945

Post New Database Management Questions

Un-Answered Questions { Database Management }

Explain the Surrogate Key in DBMS.

961

What is primary key in dbms?

914

What are records and fields in a database?

1086

What do you mean by Correlated subquery in database?

1001

what are the differences between network and hierarchical database model?

1126

How do you set up a database?

963

1. Difference between Lookup and join? 2. Difference between funnel and join? 3. What type of load you have used in your project? 4. What type of data warehouse schema you have fallowed in you project? 5. How many fact tables and dimension tables is their in project? 6. How do you kill the job process using windows environment? 7. Difference between sequence file and dataset? 8. What is delta load and subsequent load? 9. By using which stages you have implemented the SCD

1976

What are the disadvantages of file processing systems?

1024

How to retrive a single data from a database

1199

What do you mean by e-r model & object-oriented model?

942

What do you understand by fragmentation?

921

What is query in rdbms?

932

What is 1nf in database?

1001

What do you mean by e-r model?

1005

what are the two integrity rules used in DBMS?

1121

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