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

Databases AllOther Interview Questions

Questions Answers Views Company eMail

How many indexes can be created on a table?

Abacus,

1077

How many types of locks are present in a database?

Abacus,

1064

What are the types of indexes that are present inside a database?

Abacus,

1070

What is difference between clustered, non-clustered and unique index?

Abacus,

1033

What is the use of default key?

Abacus,

1087

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

Abacus,

983

How many types of normalization? What is the use of it?

Accenture,

1071

What are different types of data models available? Explain with example?

Accenture,

1033

What does new grouping sets enables you to do?

ADITI,

980

What is the advantage of varchar2 over char?

ADITI,

1214

Why merge statement is used inside the database?

ADITI,

1042

How heap is implemented in database?

Amazon,

1104

What are different types of joins used in?

Amazon,

1054

What are the concurrency problems a database faces?

Amazon,

990

What does currency type mean in database?

Amazon,

1128

Post New Databases AllOther Questions

Un-Answered Questions { Databases AllOther }

HOW PASS PARAMETERS FOLLOWING ORDER RPG-CL-RPG?

2383

What are database connection details?

1085

Explain phantom deadlock?

1181

What is ase database?

963

First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9

1686

What is global database name?

952

Explain data independence & its types.

986

How to do Stored procedure testing? Who does this testing (Developer or tester)?

1768

Can you create a database in word?

990

What is the Lock Based Protocol used for?

1022

where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it

1977

5. Explain about relational algebra.

2117

What does new grouping sets enables you to do?

980

How many types of locks are present in a database?

1064

Explain file manager?

975

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