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 the report model project?

1 220

What is report server project?

1 227

What is report snapshot in ssrs?

1 352

What is format parameter in ssrs?

1 217

What is snapshot parameter in ssrs?

1 217

What is the report builder?

1 198

What are the rendering extensions of ssrs?

1 220

What is the location of pre_defined_functions.

1 1238

What is a call statement? Explain with an example.

1 1092

If a cursor is open, how can we find in a pl/sql block?

1235

Explain polymorphism in pl/sql.

1 1197

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1 1104

Is it possible to pass parameters to triggers?

1 1193

What are the different types of triggers?

1 1219

Explain the uses of database trigger.

1 1195

Un-Answered Questions { Databases }

Can you index views?

951

Does group by remove duplicates?

1108

What are the kinds of subquery?

1099

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1041

What are the different subsets of sql?

1646

Can sql servers link to other servers like oracle?

910

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

929

what are the advantages of sql ? : Sql dba

1136

What is sql server query analyzer?

1121

what are aggregate and scalar functions? : Sql dba

1122

What is acid mean in sql server?

1234

what is dbms? : Sql dba

1059

how to escape special characters in sql statements? : Sql dba

1110

How many concurrent programs you have customized, can you name some of them?

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1124

For More Un-Answered { Databases } Questions Click Here