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

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

1 1099

How do we use % when performing a search query?

1 977

How do we delete a row in a table?

1 1069

What is the difference between char and varchar?

1 1290

What is the default port of mysql server?

1 1107

What are the different column comparison operators in mysql?

1 1023

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

1 1495

What are the disadvantages of mysql?

1 1160

Why do we use the mysql database server?

1 1144

What are the technical specifications of mysql?

1 1241

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

1 1010

Write a query to display current date and time?

1 1002

What is regexp?

1 1211

How do you determine the location of mysql data directory?

1 1009

What is the difference between float and double?

1 1226

Un-Answered Questions { Databases }

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1021

do you know how to configure db2 side of the application? : Sql server database administration

1119

How did mongodb get its name?

Where can you add custom error messages to sql server?

1206

How to start an oracle instance?

1103

what are aggregate and scalar functions? : Sql dba

1125

what is the difference between openrowset and openquery?

1189

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1295

How to put more than 1000 values into an oracle in clause?

1112

Explain “row_number()” in sql server with an example?

1074

What are the different SQL Server Versions you have worked on?

1077

Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:

2313

Is there some bulk load or other way to import a lot of data fast?

931

How to provide default values to function parameters?

1252

What is the current version of sql?

1091

For More Un-Answered { Databases } Questions Click Here