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

How many types of normalization are there?

1015

How do you write an index?

1008

Is clustered index a primary key?

987

How do I delete a trigger?

1015

How do you delete a table?

1124

How do I remove duplicates in two columns?

1149

How do I find duplicates in two columns?

1264

How can I delete duplicate rows?

1063

How do rank () and dense_rank () differ?

1109

Are stored procedures faster than queries?

990

What schema means?

939

Is delete faster than truncate?

1052

Can we use rowid as primary key?

1043

How do you remove duplicate records from a table?

981

How do you truncate?

954

Un-Answered Questions { Databases }

What do you understand by replication in sql server?

1127

Enlist some commands of ddl?

1005

What is split brain syndrome in rac?

How to divide by zero and nulls in sybase?

1013

What is the use of the drop option in the alter table command?

629

What is a sequence in a database?

1064

What is nosql vs sql?

1225

Does postgres support json?

905

What is the meaning of disabling a trigger?

1237

What does mysql_fetch_assoc do?

997

What is dimension table? : sql server analysis services, ssas

1066

What is the first step in creating a database?

930

Name some of the file extension for ms access?

1059

what are rollup and cube in t-sql? : Transact sql

1149

How do I tune a mysql query?

943

For More Un-Answered { Databases } Questions Click Here