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,

1027

Suggest a method of joining two tables.

Ernst Young, Thomson Reuters,

1156

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,

1009

What is the difference between Stored Procedures and triggers?

HCL,

1081

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,

1351

What is nolock hint in sql server 2008

HCL,

1127

What is normalization? Explain its different types?

GE, Maveric,

1089

Different types of keys in SQL?

Infosys,

1097

What are Spatial data types in SQL Server 2008

Infosys,

1020

Un-Answered Questions { Databases }

What's the difference between microsoft access and excel?

970

how to control the amount of free space in your index pages? : Sql server database administration

1036

What is the advantage of database management system?

915

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

985

What is mysql common?

909

What is mean by dml?

1009

What is database migration in mysql?

1021

What is tcl in sql server?

1122

What if your ocr (oracle cluster registry) is corrupted?

what is bit datatype? : Sql server database administration

916

Is nosql relational?

943

What is the purpose of a field in a database?

965

Is subquery faster than join?

1013

How to open postgresql gui in ubuntu?

911

how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

983

For More Un-Answered { Databases } Questions Click Here