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

925

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

984

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

916

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

893

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

879

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

1061

Mention the different types of cursor?

993

Mention the differences between trigger and stored procedures

1167

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

944

Explain the working of foreign key?

1076

What is primary key and unique key?

1125

Why do we need databases?

1055

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

982

What are the different types of dbmss?

1018

What are the advantages of normalization?

1083

Un-Answered Questions { Databases }

What is a sql instance vs database?

1127

What is the option used in PostgreSQL to increase the number of shared memory buffers shared among the backend processes

1329

What are transaction isolation levels supported by oracle?

1082

Can group by be used without aggregate functions?

929

What is an Entity set?

921

What is tuple with example?

938

Where are the settings stored for each instance in oracle?

1111

How to include text values in sql statements?

1048

What is normalization and its types?

1042

What is the default Port No on which SQL Server listens?

1132

what are different types of keys in sql?

1163

explain advantages of innodb over myisam. : Sql dba

1135

Can you leave a union at any time?

1069

I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS

2860

How can you see the connection used by mongos?

For More Un-Answered { Databases } Questions Click Here