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

Do you know what is replace and stuff function in sql server?

1085

Explain various data region available in ssrs with their use?

989

What are the ways available in sql server to execute sql statements?

1210

Tell me what is the order in which the sql query is executed?

1019

Do you know what are various aggregate functions that are available?

1221

What are the restrictions while creating batches in sql server?

1122

Tell me what is fill factor?

1013

Explain what is the purpose of sql profiler in sql server?

1135

Explain what is the difference between a local and a global temporary table?

1048

Explain how to integrate the ssrs reports in application?

1065

What are sql dirty pages?

1084

What is transactional replication?

1026

Can you explain full-text query in sql server?

1061

Do you know what is openxml in sql server?

1117

Do you know what is normalization of database? What are its benefits?

1209

Un-Answered Questions { Databases }

Operators used in select statements are?

993

How to create a trigger for insert only?

1090

Enlist various transaction phases.

1047

What query language does mongodb use?

What is the use of i-am-a-dummy flag in mysql?

1057

How do I delete a postgres database?

917

How to load data from file to file and what are the KM's required for this requirement?

665

What is database partition key?

966

What is MTTR advisor in Oracle?

1144

What is the limitation on the block size of pl/sql?

1044

How can we identify the resources for which the sessions are waiting?

What is a string data type in sql?

1105

Is access better than excel?

963

What are the package used in DBMS ?

2677

What causes index fragmentation?

1049

For More Un-Answered { Databases } Questions Click Here