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?

966

How do you write an index?

966

Is clustered index a primary key?

949

How do I delete a trigger?

967

How do you delete a table?

1075

How do I remove duplicates in two columns?

1067

How do I find duplicates in two columns?

1169

How can I delete duplicate rows?

1018

How do rank () and dense_rank () differ?

1046

Are stored procedures faster than queries?

948

What schema means?

889

Is delete faster than truncate?

1002

Can we use rowid as primary key?

989

How do you remove duplicate records from a table?

941

How do you truncate?

907

Un-Answered Questions { Databases }

What is artificial key?

885

What do you understand by query optimization?

1027

Why is the basic difference between left join, right join and inner join?

1031

Why is sql better than hql?

993

In which language neo4g is written?

How can you change to get the decimal separator as comma instead of the decimal point (.)?

856

What is the role of replication server in sybase?

961

What are the advantages of passing name-value pairs as parameters?

1168

The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?

579

Explain collation?

1068

What are the purposes of using enum and set data types?

937

What are the differences between user defined functions and stored procedures?

1074

What is a string in mysql?

902

What is data type for image in mysql?

870

Can we call procedure inside function in oracle?

1096

For More Un-Answered { Databases } Questions Click Here