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

What is self contained sub query?

1135

What is a scheduled job or what is a scheduled task?

1029

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

1021

What is clustered index

1081

Disadvantages of the indexes?

1216

Equi join and non equi join is possible with sql server?

1121

What are the different acid properties?

1 1141

When multiple after triggers are attached to sql table, how to control the order of execution?

1 1131

How to find out the list schema name and table name for the database?

1 1002

What is serializable?

1 1109

What is save transaction and save point?

1 1286

Explain transaction isolation levels in sql server?

1 1219

Explain multiserver query

1 1142

How to remove duplicate rows from table?

1 1343

What is a hint?

1 1070

Un-Answered Questions { Databases }

How to Change a users password from unix shell.

1209

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2044

Is it possible to have clustered index on separate drive from original table location?

1034

Were you involved in any data conversion, which one?

What is the latest version of postgresql?

946

Explain system functions or built-in functions? What are different types of system functions?

1055

Is inner join faster than left join?

1272

Does group by remove duplicates?

1106

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

927

Have you used lexical parameters in reports?

How do I remove duplicates in two columns?

1175

How to define array in mongoose schema?

Is primary key always clustered index?

1088

Have you written applications to retrieve stored images in a table?

1083

Can sql servers link to other servers like oracle?

907

For More Un-Answered { Databases } Questions Click Here