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?

2303

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

3 6116

Can we update table which is created from view?

IBM, Punjab National Bank,

2 5255

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 3685

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

4 7306

What is the difference between oracle CPU and PSU?

2 20961

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,

2270

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 6153

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

CTS, iNautix, TCS,

4 8722

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

IBM,

1 4759

what is ORACLE CLINICAL What are the uses of Oracle clinical

1 10686

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

Excelacom, HCL,

2479

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

IBM,

1 3887

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

L&T,

2156

how to join two table?

iNautix,

2 5074

Post New Database Management Questions

Un-Answered Questions { Database Management }

What are procedures in dbms?

980

What are vdl and sdl?

1247

What are the various normalizations in database?

1051

How to create student table through query with a numeric column of ID and Name of Chaeacter and D-O-B with date type in database What will be the query for this purpose?

1065

Does google have a database like access?

1024

what are parameter, we can check after creating a database in terms of QC and for each tables what should be the parameters for QC and QA?

2658

What is a checkpoint in dbms?

1185

what are the two integrity rules used in DBMS?

1171

Explain what are super servers?

1204

Define data, entity, domain and referential integrity?

1188

What is a candidate key in dbms?

1143

Explain the architecture of reporting services?

1035

How to retrive a single data from a database

1263

What is a foreign key constraint?

1084

What is the concept of sub-query in terms of sql?

1022

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