Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3253)
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,

1159

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

Genpact,

2 3263

What is BLOCK statements in SQL?

HCL,

1318

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

HCL,

1172

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

HCL,

1124

What the difference between UNION and UNIONALL?

HCL,

1096

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

Essar,

1075

Why I have to use stored procedures?

Cognizant,

1098

What is PROJECTION Operation?

Infosys,

1086

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

HCL,

1343

What is the importance of three tier architecture?

QuestPond,

1153

What is the difference between functions and scalar functions?

EXL,

1302

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

HCL,

1091

What is 'Join' and explain its various types.

Genpact,

1221

What do you do in data exploration

EXL,

1057

Un-Answered Questions { Databases }

What is sql performance tuning?

984

What is ddl, dml, and dcl?

1034

What is an expression in ms sql server?

1154

Differentiate between a primary key and a unique key.

1123

What are the limitations of mongodb?

What is advantages of progress actional?

984

What is ISAM?

1172

how would you store your query in an SSRS report or a Database server?

169

How can you determine if an index needs to be dropped and rebuilt?

608

What is asa in sybase?

1021

What is the use of stored procedures?

1121

What is raid and sybase?

1025

List some comparisons operators used in mysql?

1045

How to create a new table in your schema?

1141

What is left join in postgresql?

1095

For More Un-Answered { Databases } Questions Click Here