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

Oracle (3253)
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 9600

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

TCS,

6 14182

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

1 4225

What is index? How many types of indexes?

HCL,

2 12229

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

Infosys, Sierra Atlantica,

2 12928

what is difference between view and Dip.

IBM, L&T,

2461

what is curser.

9 13965

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

TCS,

5 14748

wht is normalization?can u explain me in detail?

TCS,

9 18626

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 44567

what are the new features of sql server 2005?

HP, Keane India Ltd,

8 13534

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 5393

what is the bond code in materialized view?

3071

what is the boundary line in varrays?

HCL,

1 8533

what is explain plan?

4 21529

Un-Answered Questions { Databases }

How do I manually create a database?

1281

Can postgres use multiple indexes?

908

What is the difference between stored procedure and functions?

1207

What is procedure in dbms?

941

What is pl sql record in oracle?

1093

What is the maximum size of column in sql server?

948

What are the qualities of 2nf?

1101

What is offset limit?

1013

what are date and time intervals? : Sql dba

1105

How do I access sql anywhere database?

1026

What are the critical issues you have resolved in your company

2322

What is recycle bin in Oracle?

1205

What is the meaning of sql server?

1044

Explain the steps needed to create the scheduled job?

1095

What are types of dbms?

1085

For More Un-Answered { Databases } Questions Click Here