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

Difference between 2NF &3NF ?

Cap Gemini,

1046

What will happen when a Rollback statement is executed inside a trigger?

Flextronics, Hexaware,

1 1916

What do you mean by a dependent functionality in a build?

HCL,

1084

How do you create type- insensitive operator?

EXL,

1014

Give me a SQL Query to find out the second largest company?

Ernst Young,

1140

Explain different types of Normalization.

HPCL, Hughes Systique Corporation, Ittiam Systems,

1 1768

What is the difference between Triggers and Stored Procedure?

HCL,

1053

Explain the concept of view and Types of views in SQL server?

HCL,

953

How to connect of datebase with sql express.?

MCN Solutions,

1072

What do you mean by a Composite primary key?

Genpact,

1046

Are all views updatable ?

MCN Solutions,

1119

How each E-R model constructs can be mapped to the relational model?

HCL,

947

Tell me about normalization in DBMS.

Honeywell, Zomato,

965

what is the difference between count(*) and count(1) ?

MCN Solutions,

1045

Relational calculus is what type of language?

HCL,

994

Un-Answered Questions { Databases }

Can you shard mysql?

893

How are queries run in ms access? List different ways.

734

What is cursors? And what are the different types of cursor?

1104

What you can use regular expression for in mysql?

894

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

979

How do I create a small business database in access?

818

What is dynamic sql in pl sql?

1000

How many commands are in sql?

1024

How does left join work in sql?

962

How to change program global area (pga) in oracle?

1049

Can a table have 2 primary keys?

949

When columns are added to existing tables, what do they initially contain?

997

Describe how to use the linked server?

1089

Why stored procedure is faster than query?

996

How many types of schemas are there?

1002

For More Un-Answered { Databases } Questions Click Here