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

Is inner join same as self join?

1059

Does group by remove duplicates?

978

Is inner join faster than left join?

1123

Is primary key always clustered index?

944

Is primary key clustered index?

897

Can we rollback truncate?

943

Can delete statement be rollbacked?

930

Can we use distinct and group by together?

990

Do we need to rebuild index after truncate?

972

What is the basic form of sql query?

879

Is sql sequential or random?

980

Why truncate is used in sql?

935

How many types of indexes are there in sql?

932

What are sql procedures?

964

What is dense_rank in sql?

915

Un-Answered Questions { Databases }

hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...

2114

please tell me the informatica telecom projects interview question? like if they ask about project explanation and the difficulties and the solutions taken to solve the issues for telecom projects,e.g i am workin for a vodafone project handlin postpaid section,pls tell me wat wud be the process if i work in this ? thanks

8432

How to drop an existing table in oracle?

1012

How will you distinguish a global variable with a local variable in pl/sql?

1090

What the class forname () does?

974

What is procedure cache and data cache in sybase?

786

What does (+) mean in sql joins?

1009

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2188

What authentication modes does sql server support? : sql server DBA

1136

What is save point in oracle database?

1238

What is the default server name for sql server?

1088

Is mongodb stitch free?

How does postgres store data?

736

Why do we use sql constraints?

1122

How to connect asp pages to oracle servers?

1003

For More Un-Answered { Databases } Questions Click Here