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

What is the difference between specialization and generalization?

BirlaSoft,

1073

Data structure used to implements a menu:

Verifone,

1216

How default key is different from primary key?

Abacus,

1080

How many indexes can be created on a table?

Abacus,

1230

How many types of locks are present in a database?

Abacus,

1184

What are the types of indexes that are present inside a database?

Abacus,

1170

What is difference between clustered, non-clustered and unique index?

Abacus,

1128

What is the use of default key?

Abacus,

1223

What will happen non-clustered index will be created on clustered index?

Abacus,

1095

How many types of normalization? What is the use of it?

Accenture,

1192

What are different types of data models available? Explain with example?

Accenture,

1182

What does new grouping sets enables you to do?

ADITI,

1088

What is the advantage of varchar2 over char?

ADITI,

1310

Why merge statement is used inside the database?

ADITI,

1155

How heap is implemented in database?

Amazon,

1218

Un-Answered Questions { Databases }

How did mongodb get its name?

What is change data capture (cdc) in sql server 2008?

1080

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

1045

Explain how to send email from sql database?

1108

What is the difference between $oracle_base and $oracle_home?

1140

What is ora-1555 snapshot too old error? Explain in detail?

739

What is database architecture? : SQL Server Architecture

1102

Why do we use sql constraints?

1216

how would you convert a secondary server into a primary server ?

182

Explain unique key in sql server?

1051

Is sql server is free?

1019

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

1077

Is mysql from oracle?

1018

How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff

2299

What is unique key in mysql?

1052

For More Un-Answered { Databases } Questions Click Here