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,

1239

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

MindCracker,

992

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

HCL,

1019

Define Joins?

HCL,

991

Suggest a method of joining two tables.

Ernst Young, Thomson Reuters,

1127

Give me any three differences between Truncate and Delete.

Genpact,

1064

What are the types of lock supported by ?

HCL,

1007

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

HCL,

982

What is the difference between Stored Procedures and triggers?

HCL,

1055

How to update muliple row in single query?

MCN Solutions,

1017

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

EXL,

1295

What is nolock hint in sql server 2008

HCL,

1097

What is normalization? Explain its different types?

GE, Maveric,

1058

Different types of keys in SQL?

Infosys,

1066

What are Spatial data types in SQL Server 2008

Infosys,

983

Un-Answered Questions { Databases }

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2231

What is the relationship?

936

How can we store rows in PL/SQL using array?

1183

What are the Roles and responsibilities of database administrator?

2462

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

1076

Can I delete event logs?

895

How to use old values to define new values in update statements in ms sql server?

1202

How do I edit a table in mysql workbench?

822

What is difference between db2 and sql?

958

How to write pl sql in postgresql?

849

What is the difference between join and natural join?

907

explain extended properties

943

What are the character types that are available in postgresql?

1364

What is a package in oracle?

1060

What is dimension table? : sql server analysis services, ssas

983

For More Un-Answered { Databases } Questions Click Here