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?

2214

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

3 5890

Can we update table which is created from view?

IBM, Punjab National Bank,

2 5128

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 3588

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

4 7075

What is the difference between oracle CPU and PSU?

2 20790

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,

2208

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 6048

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

CTS, iNautix, TCS,

4 8539

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

IBM,

1 4636

what is ORACLE CLINICAL What are the uses of Oracle clinical

1 10578

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

Excelacom, HCL,

2416

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

IBM,

1 3791

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

L&T,

2105

how to join two table?

iNautix,

2 4922

Post New Database Management Questions

Un-Answered Questions { Database Management }

How to extract metadata for the entire database?

1064

Why not phenix, the zelinka/otwinoski libraries, etc?

1111

Is it possible to declare or create a cursor for update of table? If yes tell me how?

860

What is network database?

1030

Can I concurrently access a firebird database with embedded and with regular server?

929

What are the lock types?

946

What are the 5 databases?

844

What is a distributed database system?

928

Explain 5nf?

927

What is openedge workgroup rdbms?

1007

What is database Configuration assistant ?

1138

What are the types of rdbms?

895

What are the parts of a table?

977

Explain Enterprise Resource Planning (ERP), and what sort of a database is utilised in an ERP application?

952

What do you mean by aggregate and scalar functions in dbms?

928

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