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 a profiler with reference to mongodb?

What should all points be taken into consideration while creating a schema in mongodb?

What is the “__v” field in mongoose?

What do you know about mongodb?

Explain sharding in mongodb?

What are the differences between mongodb and mysql?

I am getting error cannot overwrite model once compiled mongoose, how to fix it?

What is difference between unix timestamp and mysql timestamp?

1019

Write a command to list all databases in mysql?

1051

How to find second highest salary from a table?

1033

What are the types of database engines available in mysql?

1050

Explain triggers and stored procedures?

944

Write command to import an mysql file?

1046

How to store binary data in mysql?

1008

What is difference between inner vs self vs cross?

975

Un-Answered Questions { Databases }

Sql server reporting services vs. Crystal reports.

134

In what situation u create the BPA.

2219

Is sybase open source?

881

What is database white box testing?

1135

What is the return type of executeupdate ()?

916

What is end user in database?

602

Is not equal in sql?

1019

What are the two characteristics of a primary key?

999

Do you know how to implement service broker?

945

What is string in database?

888

Differentiate between mongodb vs. Sql server?

1113

Mention the differences between having and where clause.

1075

Why is %isopen always false for an implicit cursor?

1122

you need to add parameters to a query in ms access database. How would you do that?

851

How can I delete duplicate rows?

1025

For More Un-Answered { Databases } Questions Click Here