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 do you know about DBMS?

Accenture,

1113

What is Schema in DBMS?

MCN Solutions,

1122

What is write ahead logging in DBMS?

HAL,

1142

What you mean by Object Relational DBMS?

Infosys,

1112

Why its better to use files than a DBMS when there are multiple users to access the data

Infosys,

1230

what are the two integrity rules used in DBMS?

TCS,

1171

RDBMS file system can be defined as

3i Infotech,

1078

What are the various Database states.

Microsoft,

1029

How can you get data from a database in an Excel sheet?

MindCracker,

1105

When connection to database is failed, Which exception will be thrown?

MCN Solutions,

1011

What is the advantage of the database management approach

Infosys,

1115

What is a checkpoint and When does it occur in database?

TryTechnicals Pvt Ltd,

1149

What are the various normalizations in database?

NIIT,

1051

what are the different levels of database schema?

Infosys,

1181

How to start and stop database control?

MCN Solutions,

1095

Post New Database Management Questions

Un-Answered Questions { Database Management }

Why do we need database management?

1022

Explain the term generalization.

1051

Explain relational algebra?

985

Explain by listing some of dbms major advantages.

904

What happens when my integer identity runs out of scope?

1076

How can I create database in excel?

965

How do you create a database?

963

What is the sql 'in' clause?

1005

What is dbms and types of dbms?

1177

Define primary and unique key?

1213

1. Tell me about your self? 2. Latest Project Introduction? 3. Difference between server jobs and parallel jobs? 4. Seq-Seq Explain its behavior and execution mode and which parallelism technique is used? 5. What is padding characters? 6. Seq-Seq, Seq-Copy-Seq which one is the best and efficient? 7. How many reject links do we have to a transformer? 8. How many reject links to join stage? 9. Difference between join and lookup? 10. How to design PX routine? 11. How can we call job in another job? 12. Difference between batch and sequencer? 13. Which Database is used? 14. What is change capture? Give briefing of that? 15. What is change Code? Explain? 16. How you call UNIX in Ds? 17. How do you call JCL in UNIX? 18. How do you pass the job status of one job to another job? Have designed any job sequencer? 19. How do you find a file in existed directory? 20. How can you call parallel jobs in transformer? 21. Execution of jobs in command line? 22. Tuning of sql queries? 23. What is orchestrating metadata? 24. What are junk dimension? 25. What are the third party tools you are used? 26. What are the system variables you have used? IBM 1. What is virtual dataset? 2. How do you handle reject link to a peek stage? 3. What is transaction table? 4. Which one is the efficient from the following? a. ODBC enterprise b. Oracle enterprise 5. How can you extract data from excel sheet? Do you know how to parameterize, this option? 6. Six pages of complex query I have, how do you simplify this query? 7. Difference between dataset and lookup file set?

1956

Are databases stored on servers?

1099

What's the difference between file and database? Can files qualify as a database?

1028

What is concurrency control?

1108

What is like operator for and what are wild cards?

944

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