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

write a query to delete similar records in different tables with same structure

4 9449

write a query to delete similar records in particular fields(columns) in different tables

TCS,

6 13927

Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

1 4134

What is index? How many types of indexes?

HCL,

2 12094

what are the optimization techniques for Query optimization performance issues and faster execution of queries

Infosys, Sierra Atlantica,

2 12811

what is difference between view and Dip.

IBM, L&T,

2412

what is curser.

9 13673

what is Data Transformation Services (DTS) ?can u explain me in detail?

TCS,

5 14581

wht is normalization?can u explain me in detail?

TCS,

9 18274

what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?

E2 Solutions, Tesco,

10 44259

what are the new features of sql server 2005?

HP, Keane India Ltd,

8 13265

Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?

HP,

1 5301

what is the bond code in materialized view?

3004

what is the boundary line in varrays?

HCL,

1 8431

what is explain plan?

4 21337

Un-Answered Questions { Databases }

How to use subqueries in the from clause in oracle?

1113

What does the update command do?

1117

List five most important parameter in 9i affecting performance?

570

What is the difference between myisam dynamic and myisam static in mysql?

1013

Does pl sql work in mysql?

986

What is primary key, unique key, and foreign key?

976

How to end a stored procedure properly in ms sql server?

1093

Is mongodb orm?

What is the unique index?

1055

Write short notes on manual refreshes.

2738

How do I restart mysql on windows?

960

what is a sub-report?

140

How to provide default values to function parameters?

1146

What is normalisation and its types?

1008

What are the benefits of ordbms?

1088

For More Un-Answered { Databases } Questions Click Here