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

Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1411)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

what rules exist regarding format, content, flame wars, etc

IBM,

who conceived and designed the informix database management system?

IBM,

who developed informix?

IBM,

why a foreground write in informix decrease performance?state the reason for the same?

IBM,

why do foreground writes decrease performance ?

IBM,

why is update statistics important to a database?

IBM,

What does REVERT do in SQL Server 2005?

HCL,

961

how to add a new column to an existing table?

MCN Solutions,

1023

How many types of km's? And you what are the type's km are used in your project?

Infosys,

577

What is File steps?

Infosys,

618

Can migrate the one ORACLE DATA INTEGATOR studio to another ORACLE DATA INTEGATOR studio?

TCS,

628

How many types of dimensions in oracle?

TCS,

578

What are the Types of Scd's?

TCS,

580

Where is the multi connections are used in ORACLE DATA INTEGATOR?

TCS,

629

Which data loaded are in target db?

TCS,

567

Un-Answered Questions { Databases }

Difference between Logical Page and Physical Page in SSRS.

476

What is update query?

980

What is the difference between pl and sql?

1093

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

914

What do you understand by fragmentation?

914

Define ddl and dml.

1046

How to check if postgres is running?

902

What is the difference between primary and candidate key?

1127

What is nvarchar in sql?

924

How to recreate an existing index in ms sql server?

1057

What are the limitations of ms access?

916

What are the steps for performance tuning.

1337

Can you use order by when defining a view?

977

Define SQL and state the differences between SQL and other conventional programming Languages?

1211

What functions can a view be used to performed?

1060

For More Un-Answered { Databases } Questions Click Here