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

Why is the basic difference between left join, right join and inner join?

1050

How do we use % when performing a search query?

927

How do we delete a row in a table?

1007

What is the difference between char and varchar?

1207

What is the default port of mysql server?

1047

What are the different column comparison operators in mysql?

961

Write a query to select all teams that won either 1, 3, 5 or 7 games.

1387

What are the disadvantages of mysql?

1087

Why do we use the mysql database server?

1070

What are the technical specifications of mysql?

1183

Write a query to count the number of rows of a table in mysql.

951

Write a query to display current date and time?

936

What is regexp?

1153

How do you determine the location of mysql data directory?

953

What is the difference between float and double?

1145

Un-Answered Questions { Databases }

What is buffer manager?

934

IS it possible to built the oracle database without setting the kernal parameters?

2366

How to insert stored procedure result into temporary table?

1033

What is the advantage of nosql?

1082

aht is the difference b/w network & hierarchial & relational dbms????

2230

What is a Phantom Deadlock?

1006

How do you update a sql procedure?

1046

what is data control language? : Sql dba

1042

Where is mysql data stored linux?

1030

When would you use sql joins?

977

Where is psql data stored?

836

Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

1370

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1122

What is dbms used for?

1018

Can a database be shrunk with users active?

1158

For More Un-Answered { Databases } Questions Click Here