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?

988

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

1013

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

1128

Where is the myisam table stored?

1013

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

1039

How can you validate emails using a single query?

959

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

928

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

1181

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

963

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?

1005

List the different types of normalization?

994

How can you increase the performance of mysql select query?

976

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

1033

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

967

Un-Answered Questions { Databases }

How to change server name in sql server?

1267

What is the difference between view and stored procedure?

1009

How will you decide the active and passive nodes?

1192

What is character varying in postgres?

907

What are policy management terms?

1050

How is view stored in database?

1021

What is mysql server?

1167

Can mysql handle billions of records?

1151

Define database.

1057

What is audit logout in sql profiler?

1078

Explain the scenarios or situations under which progress database creates new index entry for a record?

1084

how to enter binary numbers in sql statements? : Sql dba

1021

What is a primary index?

982

is there a tool to trace queries, like profiler for sql server?

1204

Which data type is a composite type?

1043

For More Un-Answered { Databases } Questions Click Here