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

How many types of normalization are there?

959

How do you write an index?

965

Is clustered index a primary key?

949

How do I delete a trigger?

965

How do you delete a table?

1074

How do I remove duplicates in two columns?

1065

How do I find duplicates in two columns?

1167

How can I delete duplicate rows?

1014

How do rank () and dense_rank () differ?

1044

Are stored procedures faster than queries?

944

What schema means?

888

Is delete faster than truncate?

1002

Can we use rowid as primary key?

988

How do you remove duplicate records from a table?

939

How do you truncate?

906

Un-Answered Questions { Databases }

Who are end users in dbms?

987

How is use pl and sql?

1059

What is the difference between left join and right join?

942

What is the difference between PFILE and SPFILE in Oracle?

1060

What is the difference between index seek vs. Index scan?

1023

When you used JKM ?

587

Explain the process of the user request and data generating?

1092

What is indexing and what are the different kinds of indexing?

961

Where is pl sql used?

951

Explain self joins in oracle?

1017

How to filter records of table in SQL SERVER?

1086

What are constraints?

1009

What do you mean by data integrity?

1068

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1094

What is toast in postgres?

932

For More Un-Answered { Databases } Questions Click Here