Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3259)
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,

1035

What is the function of DML Compiler?

Amazon, iNautix,

1201

Explain Relational Algebra in RDBMS

Infosys,

1085

What do you mean by DBMS?

Hexaware,

977

Explain the Surrogate Key in DBMS.

Genpact,

955

Define RDBMS.

Ernst Young, Thomson Reuters,

1169

Tell me about view, sequence and index in DBMS.

Honeywell, Zomato,

1125

What is the difference between system objects and user objects?

HCL,

1159

How to manipulate data from one table to another table ?

MCN Solutions,

969

How can we use ConnectorJ JDBC Driver with MS SQL?

PUCIT,

999

What are the features of Embedded SQL

HCL,

1129

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

Genpact,

1268

Explain Geometry datatype in sql server 2008 with example

Infosys,

989

What is the Control Flow in SSIS

HCL,

1094

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

MCN Solutions,

1059

Un-Answered Questions { Databases }

What are the uses of a database trigger?

994

What is the most restrictive isolation level? : Transact sql

1085

What is use command in mysql?

1041

How to upsert (update or insert into a table)?

999

How do I bcp null dates in sybase?

933

Is mysql an oracle product?

846

What is an exception in PL/SQL? What are the two types of exceptions?

1310

How do I find query history in sql server?

942

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

1135

Explain 'forcing an index' concept.

915

What is a key in database?

903

Give the query of getting last two records from the table in SQL SERVER?

963

How to compute database fragmentation in sybase?

897

How to list all columns in a table using odbc_columns()?

976

What is trigger explain with program?

980

For More Un-Answered { Databases } Questions Click Here