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

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

979

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

1011

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

1117

Where is the myisam table stored?

1012

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

1034

How can you validate emails using a single query?

956

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

923

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

1177

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

958

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.

1043

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

998

List the different types of normalization?

994

How can you increase the performance of mysql select query?

974

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

1027

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

963

Un-Answered Questions { Databases }

Does PostgrSQL support Column constraints? If so how is it done?

1325

What security features are available for stored procedure?

1080

How many sql databases can you have on one server?

1158

How can we call stored procedures inside store procedures?

877

What are the most common databases?

1018

Explain the designer?

681

What is the difference between a database and a relational database?

1162

What is ISAM?

1166

What is sql exception?

1015

Where is the database stored?

952

What's new in sql management studio for sql server? : sql server management studio

1129

How to open and close an explicit cursor in oracle?

1103

How to check sybase database status in linux?

1092

Is mongodb a distributed database?

What is application role in sql server database security? : sql server security

1126

For More Un-Answered { Databases } Questions Click Here