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 is a replica set?

1 71

Explain can you move old files in the movechunk directory?

1 69

How can you see the connection used by mongos?

1 74

What is storage encryption?

1 76

Explain the structure of objectid in mongodb.?

1 72

What is crud?

1 75

what is the command syntax for inserting a document?

What is use of gridfs in mongodb?

1 69

What is “namespace” in mongodb?

1 73

What do you understand by nosql databases? Is mongodb a nosql database? Explain.

1 79

By default, which index is created by mongodb for every collection?

1 69

Compare mongodb and couchdb at high level?

1 68

How many indexes does mongodb create by default for a new collection?

1 72

what is objecld composed of?

1 81

What is the difference between mongodb and mysql?

1 67

Un-Answered Questions { Databases }

How can you append an identity column to a temporary table?

1066

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1207

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2702

Can we use distinct and group by together?

1131

List out the different types of locks available in sql server?

1045

What are the kinds of subquery?

1101

What is normalization and what are the advantages of it?

1054

How can we solve concurrency problems?

1120

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2089

How to use values from other tables in update statements using oracle?

1149

What is an indexed view?

1018

What are the properties of the transaction?

1069

Where can you add custom error messages to sql server?

1203

What is the current mysql version?

1095

What is oracle latest version?

1171

For More Un-Answered { Databases } Questions Click Here