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 are the different mysql database engines?

1173

What are aggregate functions in mysql?

1 1384

Explain unique key in sql.

1031

How to use distinct and count in sql query? Explain

1041

What is the difference between having and a where in sql?

1116

Explain the components of sql?

1079

Explain normalization and what are the advantages of it?

968

Explain clause in sql?

1038

What are the advantages of sql? Explain

1122

Explain foreign key in sql?

1051

What is a primary key? Explain

992

Explain the difference between drop and truncate commands in sql?

1077

Write a query to find the names of users that begin with "um" in sql?

1013

Explain scalar functions in sql?

1082

What is sql and explain its components?

1081

Un-Answered Questions { Databases }

Query processing is slow(eg select query)how will u solve that

7939

What is the difference between mysql and mysqli?

1219

What is the unique index?

1066

Are sql database names case sensitive?

1019

What is on delete restrict?

1017

Why do gaps in sequences occur?

983

Is mongodb stitch free?

what is the use of double ampersand (&&) in sql queries?

1188

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

967

What are the different types of database objects?

1079

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

980

How can you merge two tables in oracle?

1017

Explain dml compiler?

1065

I need a function for a train ticket reservation please answer it thanks in advance

1042

What is an exception in PL/SQL? What are the two types of exceptions?

1332

For More Un-Answered { Databases } Questions Click Here