Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3253)
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?

1064

Write a command to list all databases in mysql?

1084

How to find second highest salary from a table?

1064

What are the types of database engines available in mysql?

1115

Explain triggers and stored procedures?

991

Write command to import an mysql file?

1097

How to store binary data in mysql?

1050

What is difference between inner vs self vs cross?

1012

Un-Answered Questions { Databases }

What is a Transformation?

1073

How do I find the sql server instance name?

1018

How many databases instances are there in sql server 2000?

1170

What is cursors?

1264

What is syntax of for loop in r?

How to create new table with "create table" statements?

1200

Explain openquery function and openrowset function?

995

Are foreign key constraints necessary?

894

What is Database Management System?

1280

How would you use user_constraints table in DB?

1066

What is the best way to do multi-row insert in oracle?

1112

How to display error message in postgresql?

1063

can you elaborate on blob and text in mysql? : Mysql dba

944

what is isam? : Sql dba

1069

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2181

For More Un-Answered { Databases } Questions Click Here