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,

1170

Which three commands cause a transaction to end?

3i Infotech,

1121

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

3i Infotech,

1268

How does non-cluster index functions?

Alcatel-Lucent,

1183

What are the tools used for backup and ticketing?

Alcatel-Lucent,

1037

What is the difference between oracle and MS Access?

Alcatel-Lucent,

1110

What is the function of cluster index?

Alcatel-Lucent,

1222

How concurrency problems effect the database?

BirlaSoft,

1212

What does specialization in DBMS mean?

BirlaSoft,

1204

What is a sequence? Explain it with one example?

BirlaSoft,

1281

What is the candidate key used for?

BirlaSoft,

1133

What is the difference between primary and candidate key?

BirlaSoft,

1193

What is the difference between specialization and generalization?

BirlaSoft,

1073

Data structure used to implements a menu:

Verifone,

1216

How default key is different from primary key?

Abacus,

1080

Post New Databases AllOther Questions

Un-Answered Questions { Databases AllOther }

Explain entity set?

1066

What is database and its types?

1056

What will happen non-clustered index will be created on clustered index?

1095

What are the advantages of normalizing a database.

1101

Write a query to get maximum and second maximum in oracle?

1099

what is ad-hoc access? what is the diff b/w managed query and ad-hoc access?

2354

Explain data independence & its types.

1096

Is it good to store images in database?

1052

What happens when shared and exclusive locks are applied on data item?

1090

What do you mean by database?

1149

wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..

3174

What do you mean by foreign key and primary key?

1094

Why do we need distributed database?

1044

What are different types of blocks used in stored procedure?

1180

please tell me the informatica telecom projects interview question? like if they ask about project explanation and the difficulties and the solutions taken to solve the issues for telecom projects,e.g i am workin for a vodafone project handlin postpaid section,pls tell me wat wud be the process if i work in this ? thanks

8567

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