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 do you understand by aggregation and atomicity?

960

Do we consider null values the same as that of blank space or zero?

1028

What do you understand by the terms entity, entity type, and entity set in dbms?

961

Explain what is a deadlock and mention how it can be resolved?

935

What do you understand by the view and mention the steps to create, update and drop a view?

927

What do you understand by cursor? Mention the different types of cursor?

1163

Mention the different types of cursor?

1071

Mention the differences between trigger and stored procedures

1271

what is the difference between two and three-tier architectures?

991

Explain the working of foreign key?

1144

What is primary key and unique key?

1173

Why do we need databases?

1096

What are primary key and foreign key and how they work?

1024

What are the different types of dbmss?

1062

What are the advantages of normalization?

1132

Un-Answered Questions { Databases }

What is the operator that is used for case-insensitive regular expression searches in PostgreSQL?

1312

What is a dead lock in oracle?

1188

What does cursor do in sql?

1067

Is nosql faster than sql?

1078

What is a trace file and how is it created in oracle?

1153

What is file manager?

955

what is difference between view and Dip.

2461

What are cursors stored procedures and triggers?

1094

How can I create database in excel?

969

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

4112

What command is used to rename the database?

1091

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

1069

What is difference between index seek vs. Index scan?

1203

Is grant a ddl statement?

949

What do you understand by case manipulation functions?

1092

For More Un-Answered { Databases } Questions Click Here