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,

978

What is the function of DML Compiler?

Amazon, iNautix,

1160

Explain Relational Algebra in RDBMS

Infosys,

1039

What do you mean by DBMS?

Hexaware,

941

Explain the Surrogate Key in DBMS.

Genpact,

905

Define RDBMS.

Ernst Young, Thomson Reuters,

1136

Tell me about view, sequence and index in DBMS.

Honeywell, Zomato,

1087

What is the difference between system objects and user objects?

HCL,

1126

How to manipulate data from one table to another table ?

MCN Solutions,

931

How can we use ConnectorJ JDBC Driver with MS SQL?

PUCIT,

973

What are the features of Embedded SQL

HCL,

1102

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

Genpact,

1223

Explain Geometry datatype in sql server 2008 with example

Infosys,

933

What is the Control Flow in SSIS

HCL,

1050

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

MCN Solutions,

1024

Un-Answered Questions { Databases }

How to determine the size of an index?

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

2402

How do you change the order of columns?

813

What does over partition by mean in sql?

935

Is hadoop a nosql?

960

Write a query for primary key constraint with identity key word?

992

What are the types of optimization?

904

What is bcnf in the dbms?

893

What is database white box testing and black box testing?

1068

How do you rename a database?

861

Explain how does the report manager work in ssrs?

922

How does clustered and non clustered index work?

865

What is the difference between execution of triggers and stored procedures?

1076

Where would you look for errors from the database engine?

2815

Enlist the disadvantages of query.

1119

For More Un-Answered { Databases } Questions Click Here