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

What is the difference between specialization and generalization?

BirlaSoft,

983

Data structure used to implements a menu:

Verifone,

1114

How default key is different from primary key?

Abacus,

1003

How many indexes can be created on a table?

Abacus,

1103

How many types of locks are present in a database?

Abacus,

1083

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

Abacus,

1089

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

Abacus,

1045

What is the use of default key?

Abacus,

1121

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

Abacus,

1002

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

Accenture,

1094

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

Accenture,

1049

What does new grouping sets enables you to do?

ADITI,

996

What is the advantage of varchar2 over char?

ADITI,

1230

Why merge statement is used inside the database?

ADITI,

1066

How heap is implemented in database?

Amazon,

1129

Un-Answered Questions { Databases }

What is sql procedures and functions?

972

can we call primary key a 'address'????

2385

What is the command used to fetch the first 5 characters of a string?

1177

Explain what is meant by asymmetrical protocols?

1066

Explain what is a column in a table?

1062

What is the meaning of disabling a trigger?

1128

What is network database?

991

Is mongodb a json?

What is nosql vs sql?

1137

What happens if the update subquery returns no rows in ms sql server?

1088

What is the contrast between sql and mysql?

1062

Does mongodb cost money?

How to execute cql commands in neo4j?

We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.

5297

What is the Difference Primary key and Unique Key

974

For More Un-Answered { Databases } Questions Click Here