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 9489

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

TCS,

6 13970

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

1 4153

What is index? How many types of indexes?

HCL,

2 12128

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

Infosys, Sierra Atlantica,

2 12831

what is difference between view and Dip.

IBM, L&T,

2424

what is curser.

9 13728

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

TCS,

5 14621

wht is normalization?can u explain me in detail?

TCS,

9 18343

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 44324

what are the new features of sql server 2005?

HP, Keane India Ltd,

8 13325

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 5322

what is the bond code in materialized view?

3015

what is the boundary line in varrays?

HCL,

1 8448

what is explain plan?

4 21362

Un-Answered Questions { Databases }

Explain subquery and state its properties?

1057

How do you bind variables in pl sql?

1111

What is the difference between horizontal and vertical partitioning?

1005

Is oracle a language?

965

can sql servers linked to other servers like oracle? : Sql dba

1020

What are types of exception?

931

How to create database with physical files specified in ms sql server?

1009

What is dml and ddl?

980

what is object cache in neo4j. how many types of they are?

What is the difference between mysql and pdo?

1003

Why does sql studio use a single registered database repository? : sql server management studio

1013

How to delete an existing row from a table in oracle?

1088

how to start mysql server? : Sql dba

1212

What is partition by in sql?

1087

Do you know what is a linked server in sql server?

1034

For More Un-Answered { Databases } Questions Click Here