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

Do you think BCNF is better than 2NF & 3NF? Why?

Ernst Young,

1278

Write a query for primary key constraint with identity key word?

MindCracker,

1031

Can we return Data from 4(more than 1) tables in stored procedure?

HCL,

1059

Define Joins?

HCL,

1028

Suggest a method of joining two tables.

Ernst Young, Thomson Reuters,

1157

Give me any three differences between Truncate and Delete.

Genpact,

1107

What are the types of lock supported by ?

HCL,

1044

What is the name of the system variable that returns the number of rows affected by a SQL statement?

HCL,

1011

What is the difference between Stored Procedures and triggers?

HCL,

1082

How to update muliple row in single query?

MCN Solutions,

1058

Tell me about the approaches which you used to counter the DI problems.

EXL,

1353

What is nolock hint in sql server 2008

HCL,

1127

What is normalization? Explain its different types?

GE, Maveric,

1090

Different types of keys in SQL?

Infosys,

1098

What are Spatial data types in SQL Server 2008

Infosys,

1020

Un-Answered Questions { Databases }

What is mutating error?

965

Explain cursor types?

1026

How to run queries on external tables?

1046

What is posting?

1039

How does a covering index work?

960

How do I drop a collection in mongodb? Write it's syntax

What is table join?

1115

What is the difference between a function and a trigger?

1082

How to enable or disable a row of a table using MySQL in struts?

4099

Which is super key?

805

How does clustered and non clustered index work?

924

how can you test for null values in a database? : Mysql dba

938

What is DB Development software?

2074

Why we use mysql workbench?

906

How to check your oracle database 10g xe installation?

986

For More Un-Answered { Databases } Questions Click Here