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

State at least four kinds of indexing?

Amazon, iNautix,

1101

What is the function of DML Compiler?

Amazon, iNautix,

1287

Explain Relational Algebra in RDBMS

Infosys,

1140

What do you mean by DBMS?

Hexaware,

1025

Explain the Surrogate Key in DBMS.

Genpact,

1006

Define RDBMS.

Ernst Young, Thomson Reuters,

1220

Tell me about view, sequence and index in DBMS.

Honeywell, Zomato,

1175

What is the difference between system objects and user objects?

HCL,

1222

How to manipulate data from one table to another table ?

MCN Solutions,

1029

How can we use ConnectorJ JDBC Driver with MS SQL?

PUCIT,

1055

What are the features of Embedded SQL

HCL,

1181

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

Genpact,

1335

Explain Geometry datatype in sql server 2008 with example

Infosys,

1052

What is the Control Flow in SSIS

HCL,

1165

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

MCN Solutions,

1107

Un-Answered Questions { Databases }

Who uses mongodb?

How to define output parameters in stored procedures?

1100

What are parameter files? Where do we use them?

How to name query output columns in ms sql server?

1025

Explain what is the function of sql server agent windows service?

1046

How to retrieve data from multiple collections in mongodb?

What are the limitations of database?

947

What is pg pool?

905

What are different types of statements supported by sql?

1225

How important do you consider cursors or while loops for a transactional database?

1021

How does a database store data?

1009

What are the various benefits of using rac architecture?

Explain about the difficulties faced by the database developer in implementing pre compiled statements?

785

Who created postgresql?

817

What are the integrity rules in dbms?

1176

For More Un-Answered { Databases } Questions Click Here