Databases AllOther Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Databases AllOther Interview Questions

Questions Answers Views Company eMail

Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?

3i Infotech,

1114

Which three commands cause a transaction to end?

3i Infotech,

1062

You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?

3i Infotech,

1224

How does non-cluster index functions?

Alcatel-Lucent,

1132

What are the tools used for backup and ticketing?

Alcatel-Lucent,

997

What is the difference between oracle and MS Access?

Alcatel-Lucent,

1064

What is the function of cluster index?

Alcatel-Lucent,

1163

How concurrency problems effect the database?

BirlaSoft,

1155

What does specialization in DBMS mean?

BirlaSoft,

1154

What is a sequence? Explain it with one example?

BirlaSoft,

1187

What is the candidate key used for?

BirlaSoft,

1087

What is the difference between primary and candidate key?

BirlaSoft,

1124

What is the difference between specialization and generalization?

BirlaSoft,

1025

Data structure used to implements a menu:

Verifone,

1162

How default key is different from primary key?

Abacus,

1038

Post New Databases AllOther Questions

Un-Answered Questions { Databases AllOther }

Explain various types of locks in a transaction? Which is better and why?

1024

define primary key index, bitmap index, hash index,virtual indwx

3319

Explain entity type?

990

Is redis in memory database?

995

Explain database partitioning.

1074

What is the role of driver manager?

1011

Define stored procedure?

1014

What is the best database software for small businesses?

920

How does database replication work?

994

How do database connections work?

942

what is rcp,if rcp disabled what happen?

2215

What are different types of clusters present?

1075

What are the disadvantages of views in a database?

1053

WHAT IS CARDINALITIES OF JOIN?

2363

What is the importance of database partitioning?

1058

For More Un-Answered { Databases AllOther } Questions Click Here