1. Categories >> Software >> Databases
  2. Suggest New Category


Databases Interview Questions
Questions Answers Views Company eMail

Types of joins?

Microsoft,

4 7616

How do you get all records from 2 tables. Which join do you use?

Microsoft,

8 16857

Types of optimization?

Microsoft,

6 13508

Difference between inline query and stored procedure?

Bharat, Microsoft,

4 27570

Types of joins ?

Digital GlobalSoft, HeadStrong,

3 10647

Types of cursors and explanation each of them ?

DELL,

4 11058

Types of cursor locks and explanation each of them ?

DELL, HP Finsoft,

3 12273

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 8511

How do you rate yourself in oracle and sql server ?

Keane India Ltd,

2 7343

What is E-R diagram ?

CGI, Keane India Ltd,

2 11200

Draw E-R diagram for many to many relationship ?

Keane India Ltd,

3154

Design database draw er diagram for a certain scenario ?

Keane India Ltd, TATA,

4098

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 190475

What is Normalization ?

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

55 73615

Difference between sub query and nested query ?

Keane India Ltd, TCS,

19 62356

Un-Answered Questions { Databases }

Why are sql stored procedures used?

611

Why select is used in sql?

514

Is mongodb a database?

1

What is a matrix in ssrs?

101

How do I select a table in mysql?

489




How to access the deleted record of an event?

575

How you find which is the latest record in SCD type2 transformation?

299

What are partitioned views and distributed partitioned views?

600

How dts is used to extract, transform and consolidate data?

594

How to connect to oracle using service name instead of sid?

547

What are the common oracle dba tasks?

619

How to do a full database export?

631

Difference between global and parameter variables?

1453

What are the types of profiles in ODI?

318

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

852

For More Un-Answered { Databases } Questions Click Here