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

Why are indexes and views important to an organization?

1 1025

Which join is default?

1 1027

What is before and after trigger?

1 1022

Can I call a procedure inside a function?

1 1092

Which is better join or subquery?

1 1225

What is the difference between instead of trigger and after trigger?

1 1086

Why we use cross join?

1 1010

Why indexing is needed?

1 1054

Why is normalization important?

1 1104

Which is faster subquery or join?

1 1293

Why do we need unique key in a table?

1 1017

Which is the correct statement about truncate and delete?

1 1201

Why is a trigger used?

1 1010

Why query optimization is needed?

1 996

Why use truncate instead of delete?

1 1086

Un-Answered Questions { Databases }

Equi join and non equi join is possible with sql server?

1121

Is primary key clustered index?

1009

Were you involved in any data conversion, which one?

Can delete statement be rollbacked?

1050

How can you append an identity column to a temporary table?

1063

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1021

what are the advantages of sql ? : Sql dba

1136

do you know how to configure db2 side of the application? : Sql server database administration

1114

What is normalization and what are the advantages of it?

1050

What is in place upgrade in sql server?

1119

What is a view in sql?

1035

List out the different types of locks available in sql server?

1043

How do I start sql server 2017?

1009

What are the different subsets of sql?

1644

Can we shrink data file in sql server?

1119

For More Un-Answered { Databases } Questions Click Here