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

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

Microsoft,

2 7237

WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?

8 21902

MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE

IBM, TCS,

2 17438

What is INTVAL( )and where we use Plz any body help me

1 5901

what is primary key and foreign key when and where have to use

5 7560

can you tell me some sites name for sql server 2000 commands with example??? plz reply soon.

2072

can we use a having cluase in groupby clause. if there are 500 records i will give rownumber<250 then how many records does it retrieve. wt is the result of nvl2(null,notnull,null) if there are four tables without using cartesian how many joins can be there. in the sql subqueries wt is the parent ans1)select 2)update,3) delete 4)2&3

i2,

2 6079

What is the difference between a stored procedure and a user defined function in sql server?

Millennium,

2 7890

could u plz explain about joins and views?

2 5289

plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005

3 5360

can anyone explain me the concept of Serialization in Detail and Clear? plz its urgent i have interview on friday (15th feb)

1 6485

what is the sql equivaent of the dataset relation object ?

2048

Differences between UNIQUE and DISTINCT in select statements

ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,

26 135912

what is view?

Accenture,

7 11008

How the Action Trigger works? and what is full syntex of srw.run_report?

CMC, Yantro Software,

1 9030

Un-Answered Questions { Databases }

How to start a specific oracle instance?

1046

What is dba in sound level?

604

How many postgresql users are there, worldwide?

1081

Explain dml compiler?

1067

In which year mysql created?

988

What is dba training?

573

what is database white box testing? : Mysql dba

1012

What is the use of partition by in sql?

1005

How many databases Microsoft SQL server provides?

1109

How to assign data of the deleted row to variables?

1086

how to enter characters as hex numbers? : Sql dba

1058

What is right join in sql?

1107

How many entries can mysql handle?

1022

What is normalization according to you and explain its different levels?

969

How do I delete a table in postgresql?

878

For More Un-Answered { Databases } Questions Click Here