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

What are the different types of cursor?

HCL,

1096

How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?

Genpact,

2 3140

What is BLOCK statements in SQL?

HCL,

1263

Explain the difference between delete,drop and truncate in SQL Server?

HCL,

1100

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

HCL,

1058

What the difference between UNION and UNIONALL?

HCL,

1040

What is BCNF? How is it better than 2NF & 3NF?

Essar,

1017

Why I have to use stored procedures?

Cognizant,

1041

What is PROJECTION Operation?

Infosys,

1020

Where are SQL server users names and passwords are stored in sql server?

HCL,

1271

What is the importance of three tier architecture?

QuestPond,

1093

What is the difference between functions and scalar functions?

EXL,

1210

How to call a function from a stored procedure in SQL Server ?

HCL,

1029

What is 'Join' and explain its various types.

Genpact,

1137

What do you do in data exploration

EXL,

993

Un-Answered Questions { Databases }

What the difference between UNION and UNIONALL?

1040

What is redis good for?

957

Should you normalize audio?

941

Explain oracle data types with examples?

1028

Tell me what is difference between clustered and non clustered index?

944

Name the various constraints used in oracle?

1019

Can we write a distributed query and get some data which is located on other server and oracle database?

1231

How to create a new schema in a database?

1151

Is the primary key column of a table an index in ms sql server?

962

Can excel convert to access?

896

What is mongod command?

How do you define a foreign key?

1003

Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.

1476

What is the difference between database and server?

1022

What is metadata in dbms?

967

For More Un-Answered { Databases } Questions Click Here