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

Can you tell few best practices to be followed for optimization in sql?

912

How can you take the backup and restore a mysql database using php?

966

How to copy data from one server to another using php?

1053

Where is the myisam table stored?

968

Can you tell the difference between $message and $$message?

977

How can you validate emails using a single query?

903

Can you tell what are various ways to create an index?

885

Can you tell a way to know the number of days between the two given dates in php?

1101

Can you tell how to find the number of rows in a resultset using php?

904

Consider a scenario where you have two to three tables with thousand tuples in each of them. Now, if you have to perform a join operation between them will you choose to perform filtering of rows or transforming of rows first.

998

Can you tell which of the following where clauses is faster?

914

List the different types of normalization?

951

How can you increase the performance of mysql select query?

928

What is a checkpoint in dbms and when does it occur?

983

Explain the terms database and dbms. Also, mention the different types of dbms.

915

Un-Answered Questions { Databases }

What does trigger mean in psychology?

971

What is Reduced List of Values?

2180

Can you explain the disadvantages/limitation of the cursor?

993

How do I find mysql version in mysql workbench?

944

Is foreign key unique?

1006

What is recompile sql server?

1047

What is a Built_in subprogram ?

4003

What is the data in a database?

907

What is database or database management systems (dbms)? And what's the difference between file and database? Can files qualify as a database?

932

How to copy data from one server to another using php?

1053

Is postgresql better than sql server?

934

How is the pattern matching done in the sql?

1174

What do you mean by entity type?

1081

In mysql, what is joins? Explain

978

What is built-in function?

1015

For More Un-Answered { Databases } Questions Click Here