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

How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

DELL,

2 9642

How do you rate yourself in oracle and sql server ?

Keane India Ltd,

2 8593

What is E-R diagram ?

CGI, Keane India Ltd,

2 12583

Draw E-R diagram for many to many relationship ?

Keane India Ltd,

3674

Design database draw er diagram for a certain scenario ?

Keane India Ltd, TATA,

4628

Difference between primary key and unique key ?

Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions,

77 212478

What is Normalization ?

ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,

55 89623

Difference between sub query and nested query ?

Keane India Ltd, TCS,

19 69065

Un-Answered Questions { Databases }

How do I pipe the output of one isql to another?

1058

What do you understand by check constraint in sql server?

1019

When we will denormalize data?

1085

What do you understand by e-r model?

1089

Explain the storage engines in mysql?

1056

How to create table with timestamp in postgres?

865

What is the difference between the application object and session object?

1123

What is benefit of creating memory optimized table?

1034

What are collection pools? What are the advantages?

945

What is a table partition?

1208

What is sql profiling in oracle?

1133

Can we call procedure in select statement?

1113

What is the first step in creating a database?

932

How do I know if oracle is installed on windows?

987

How to uncatalog backup?

604

For More Un-Answered { Databases } Questions Click Here