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?

1034

What is the difference between cartesian product and cross join?

912

What is an indexing technique?

990

What is normalization 1nf 2nf 3nf?

1120

What is the library index called?

1121

What is difference between index and primary key?

1150

What is a unique index?

981

What is an indexing strategy?

1090

What is clustered vs nonclustered index?

1010

What is the function of inner join?

1129

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

1054

What are the sql versions?

1004

Why do we use triggers?

1024

What are keys in sql?

1052

What is trigger price?

1051

Un-Answered Questions { Databases }

how you will identify the mapping level bottleneck ? if there is a mapping level bottleneck then how will you try to improve the mapping

2015

What is mongodb atlas?

I need to run a report at scheduled timings only. I don't want to run the report on sundays. How to do this?

Explain look up fields?

926

Can I use mongodb for free?

How many types of tables are there in oracle?

1124

How to write a left outer join with the where clause in oracle?

1136

What are the advantages to use stored procedures?

1189

what is Neo4j?

How to list all field names in the result set using mssql_field_name()?

965

What are exact numeric data types in ms sql server?

1157

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

1049

What is analysis service repository?

1077

What are data resources?

967

How to fetch alternate records from a table?

1311

For More Un-Answered { Databases } Questions Click Here