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 difference between views and stored procedures?

1 1037

What is the difference between cartesian product and cross join?

1 914

What is an indexing technique?

1 993

What is normalization 1nf 2nf 3nf?

1 1124

What is the library index called?

1 1121

What is difference between index and primary key?

1 1150

What is a unique index?

1 981

What is an indexing strategy?

1 1101

What is clustered vs nonclustered index?

1 1010

What is the function of inner join?

1 1131

What is the difference between an index and a unique index?

1 1054

What are the sql versions?

1 1004

Why do we use triggers?

1 1024

What are keys in sql?

1 1052

What is trigger price?

1 1057

Un-Answered Questions { Databases }

How raid can influence database performance?

1093

List the ways in which dynamic sql can be executed?

1071

Is inner join faster than left join?

1265

Explain “row_number()” in sql server with an example?

1062

what are aggregate and scalar functions? : Sql dba

1116

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?

1200

what is sql server agent? : Sql dba

1162

Is primary key always clustered index?

1081

Can delete statement be rollbacked?

1038

how to escape special characters in sql statements? : Sql dba

1097

What is standby servers? Explain types of standby servers.

1067

Where can you add custom error messages to sql server?

1190

What kind of problems occurs if we do not implement proper locking strategy?

1479

What are the steps in creating a database?

985

How to select all columns of all rows from a table in oracle?

1107

For More Un-Answered { Databases } Questions Click Here