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,

1033

What is the function of DML Compiler?

Amazon, iNautix,

1201

Explain Relational Algebra in RDBMS

Infosys,

1085

What do you mean by DBMS?

Hexaware,

976

Explain the Surrogate Key in DBMS.

Genpact,

952

Define RDBMS.

Ernst Young, Thomson Reuters,

1169

Tell me about view, sequence and index in DBMS.

Honeywell, Zomato,

1123

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,

1127

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,

1092

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

MCN Solutions,

1059

Un-Answered Questions { Databases }

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1088

What is an oracle stored procedure?

1050

What are fact tables and dimension tables ? What is dimensional modeling and star schema design

890

Why join is faster than subquery?

1111

What is composite primary key in sql?

996

how you can get the list of largest tables in a database? : Sql server administration

1053

Is port 1433 secure?

997

Why we use mysql workbench?

906

How to return top 5 rows in oracle?

1062

What is temp db database? : sql server architect

877

Can truncate be rolled back?

943

What port does postgresql use?

817

What are the knowledge modules types?

588

What is difference between stored procedure and trigger?

1165

How to use existing values in update statements using oracle?

1066

For More Un-Answered { Databases } Questions Click Here