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 left join inner or outer?

1033

Is join and inner join the same?

1016

Does a join table need a primary key?

964

How do you write an inner join query?

964

What is the difference between a subquery and a join?

1119

Can I join the same table twice?

1058

Are left and right joins the same?

1096

What is left join example?

959

What is difference between inner join and self join?

1093

Is join an inner join?

982

What is the difference between left join and right join?

956

Which join condition can be specified using on clause?

963

What is the difference between joins?

1050

What is foreign key and example?

942

Can you have a foreign key without a primary key?

963

Un-Answered Questions { Databases }

Difference between Inner vs outer joins?

958

What are the advantages/disadvantages of mysql and php?

966

How do I create a simple access database?

902

What is flag in database?

1019

What is database management system(dbms)?

998

What are stand-alone procedures?

962

What is nvarchar max in sql?

1028

What are indexes? What are b-trees?

994

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

1015

What is rdbms with diagram?

899

Is microsoft access free?

800

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1175

What is the use of i-am-a-dummy flag in mysql?

1018

In MS Access the long and short date option does not show 4 digit years. how do I achieve the mm/dd/yyyy format?

869

How is rdbms different from dbms?

963

For More Un-Answered { Databases } Questions Click Here