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,

1051

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

Genpact,

2 3055

What is BLOCK statements in SQL?

HCL,

1227

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

HCL,

1042

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

HCL,

1023

What the difference between UNION and UNIONALL?

HCL,

1001

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

Essar,

983

Why I have to use stored procedures?

Cognizant,

994

What is PROJECTION Operation?

Infosys,

981

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

HCL,

1222

What is the importance of three tier architecture?

QuestPond,

1042

What is the difference between functions and scalar functions?

EXL,

1151

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

HCL,

977

What is 'Join' and explain its various types.

Genpact,

1086

What do you do in data exploration

EXL,

944

Un-Answered Questions { Databases }

How do I connect to mongodb remotely?

explain the difference between delete , truncate and drop commands? : Sql dba

1044

What is bulk load in oracle?

1030

What is the instance of a relation?

971

What is vacuuming in postgresql?

725

What are the different parts of a database application called in access?

744

What are the benefits of modeling?

1003

How do I find the transaction log size in sql server?

934

What is break?

1159

What is rownum in sql?

992

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

999

Explain primary key?

920

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

How to convert dates to characters in oracle?

1003

What is a distributed database system?

897

For More Un-Answered { Databases } Questions Click Here