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 9538

How do you rate yourself in oracle and sql server ?

Keane India Ltd,

2 8495

What is E-R diagram ?

CGI, Keane India Ltd,

2 12468

Draw E-R diagram for many to many relationship ?

Keane India Ltd,

3627

Design database draw er diagram for a certain scenario ?

Keane India Ltd, TATA,

4579

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 210261

What is Normalization ?

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

55 87976

Difference between sub query and nested query ?

Keane India Ltd, TCS,

19 68489

Un-Answered Questions { Databases }

What is the difference between replication server and sql remote in sybase?

939

What are the benefits of pl sql?

1121

What is example of database?

1056

Does hive support indexing?

959

What is java oracle used for?

1021

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1288

Explain subquery and state its properties?

1042

How to use set clause in neo4j?

Where is the myisam table stored?

965

What is normalization? Explain different forms of normalization?

1160

What is raid controller technology?

997

what is cursor. write example of it. What are the attributes of cursor.

1391

Tell me what do you understand by a view? What does the with check option clause for a view do?

1021

What is postgresql database cluster?

920

What does clipper stand for?

1003

For More Un-Answered { Databases } Questions Click Here