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 9436

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

TCS,

6 13919

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

1 4130

What is index? How many types of indexes?

HCL,

2 12082

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

Infosys, Sierra Atlantica,

2 12794

what is difference between view and Dip.

IBM, L&T,

2409

what is curser.

9 13648

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

TCS,

5 14570

wht is normalization?can u explain me in detail?

TCS,

9 18244

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 44229

what are the new features of sql server 2005?

HP, Keane India Ltd,

8 13250

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 5294

what is the bond code in materialized view?

3002

what is the boundary line in varrays?

HCL,

1 8428

what is explain plan?

4 21320

Un-Answered Questions { Databases }

When should you increase copy latches?

644

what is asm?

1047

What do we mean by record group in oracle forms?

1073

What is dbms explain in brief?

1029

What is a sql profiler?

1023

Why select is used in sql?

1018

How do I completely uninstall postgresql?

861

Can you please explain the difference between primary keys and foreign keys?

1110

What privilege is needed for a user to create views in oracle?

1044

How do I open microsoft access on my computer?

852

Define the select into statement.

1056

Do you know what are the differences between lost updates and uncommitted dependencies?

1081

What's the information that can be stored inside a bit column?

1004

What is change data capture (cdc) in sql server 2008?

1024

what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba

1078

For More Un-Answered { Databases } Questions Click Here