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

Database Management Interview Questions

Questions Answers Views Company eMail

What is the diff bet plan,package,dbrm?

1104

What are collection pools? What are the advantages?

894

Can you have more than one cursor open at any one time in a program ?

959

What is openedge abl in terms of taking the perspective of the developer?

918

Explain what are super servers?

1118

What is environment of openedge?

919

Which two statements are true about a foreign key?

972

How to reorder the table columns (fields)?

1088

Define truncate and delete commands?

1009

What are the restrictions applicable while creating views?

948

Explain 2nf?

955

How to do replication of firebird databases?

948

What is the difference between hashed file stage and sequential file stage in relates to datastage server?

1095

Explain what are triggers and rules?

909

Could you give me an example how, where I code checkpoint and restart. I need and example

1011

Post New Database Management Questions

Un-Answered Questions { Database Management }

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

1121

What do you mean by buffer manager?

1049

Mention the different languages present in dbms

951

Explain what are service-specific middleware?

972

What is an optimization and performance tuning and how does it really work in practical projects?

899

How view is related to data independence?

981

What are database data types?

905

Define join types.

949

How do you backup a database?

984

What is an advantage of a database?

1039

How many rows can a database hold?

1041

Is access a database?

878

How do queries work in a database?

1023

I have 2 tables with 1 million rows each. I have updated 1 row in first and 1 million update on second table. Now I commit both the updates. Which one will commit fast and Why?

2620

Briefly describe an outer join.

960

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