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 9563

How do you rate yourself in oracle and sql server ?

Keane India Ltd,

2 8525

What is E-R diagram ?

CGI, Keane India Ltd,

2 12493

Draw E-R diagram for many to many relationship ?

Keane India Ltd,

3640

Design database draw er diagram for a certain scenario ?

Keane India Ltd, TATA,

4600

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 211010

What is Normalization ?

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

55 88325

Difference between sub query and nested query ?

Keane India Ltd, TCS,

19 68640

Un-Answered Questions { Databases }

What are the different types of triggers in SQL SERVER?

1153

What is the difference between a heap table and temporary table?

954

Explain what is raid and what are different types of raid levels?

1039

Is mongodb a distributed database?

What are sql servers used for?

1061

What is the exact use of Collections?

2159

Define a cross join?

1042

What language is access written in?

811

Explain oracle data types with examples?

1043

please send me oracle pl/sql exp resume. and also faqs...

2510

What is index hunting?

1212

What are unicode character string data types in ms sql server?

1275

what is the difference between delete table and truncate table commands? : Sql server database administration

1056

How many dba can you have?

555

What are the commands you'd issue to show the explain plan for "select * from dual"?

2247

For More Un-Answered { Databases } Questions Click Here