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 will be the maximum number of indexes per table?

985

What xml support does the sql server extend?

1032

What is a join in sql? What are the types of joins?

1129

What do you mean by data integrity?

1104

How can we determine what objects a user-defined function depends upon?

1028

What is the cartesian product of the table?

977

What is a deadlock and what is a live lock?

1016

Explain unique key in sql server?

1026

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

981

What is the difference between primary key and unique constraints?

978

Write a sql query to display the current date?

1113

Why use “in” clause in sql server?

1091

Write an sql query to find the names of employees start with ‘a’?

1 1771

When would you use it?

1017

What is the difference between ‘having’ clause and a ‘where’ clause?

1060

Un-Answered Questions { Databases }

Explain insert into select statement?

972

How do I flush privileges in mysql?

1026

What are the different type of joins in sql?

972

What do you mean by a database transaction & what all tcl statements are available in oracle?

1009

What is delimiter in dbms?

916

What does mvcc mean?

858

Can we save images in a database and if yes, how?

1085

Are the resulting relations of PRODUCT and JOIN operation the same?

853

Write a query to create a duplicate table with and without data present?

876

What trigger means?

1008

Can you copy and paste from excel to access?

838

What is stored in the mssqlsystemresource database? : sql server database administration

1045

What is varchar data type in sql?

1095

What is right join in sql?

1113

What is wide table?

975

For More Un-Answered { Databases } Questions Click Here