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 faster than join?

1053

Does inner join remove duplicates?

943

Can we rollback after truncate?

1031

Can we create a trigger on view?

896

Does truncate release storage space?

1078

Are views faster than queries?

992

Can we perform dml on view?

1044

How does a trigger work?

1074

Can we insert delete data in view?

951

How does a covering index work?

961

Can we have two clustered index on a table?

1025

How many types of primary keys are there?

1040

Can we insert data into view?

904

How do you define a foreign key?

1005

Can we join tables without foreign key?

962

Un-Answered Questions { Databases }

Is it safe to delete log files?

920

What is the definition for sql server 2000?

1091

What does stand for in sql?

972

What skills should a dba have?

575

What are the consideration at tehe migration of Oracle 9i to 10G.

3067

Which profile required to access solution in Designer tool?

586

What is insert query in mysql?

909

Can postgres handle big data?

855

How triggers can be used in mysql?

1017

Explain 'forcing an index' concept.

920

What are the requirements on sql server network connections?

1000

What is sqlca in db2?

970

Does mongodb cost money?

What is the use of a namespace in mongodb?

How do you pronounce sql?

1013

For More Un-Answered { Databases } Questions Click Here