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 CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.

Synergy,

1 6347

If there are 1 to 100 numbers in a table and in that 100 numbers some 10 numbers are deleted.I want to find out the missing numbers between 1 to 100 by pl/sql how?

JPMorgan Chase,

9 16183

what is DTS what are tasks available

Wipro,

1 3819

Normalization and denormalization

Wipro,

3 6834

Diffrent types of function

Wipro,

1 4442

diffrence between function and procedure

Wipro,

5 7393

diffrence between Cluster Index and non Cluster Index

Wipro,

3 6216

System variable and temporary variables

Wipro,

2250

optimization techinques

Wipro,

2676

user defined datatypes

Wipro,

1 4497

What is bulk collections?

2 7859

what is External tables? explain with examples

TCS,

2 13819

what is difference between decode and case function?

2 10145

what is the link between suppliers and banks in ap module in oracle apps? And also query?

Polaris,

2472

In oracle 10g export, import if we declare rows=y/n what would be the output?

Value Labs,

2941

Un-Answered Questions { Databases }

Does mongodb support acid transactions?

What is crud diagram?

948

Write a query to display the current date in sql?

1020

What are the dmvs?

1014

Explain neo4j vs. Mongodb?

what is a package n what r the packages availbla in report

2096

How to view the error log for any specific instance? : sql server database administration

1039

Enlist various types of interactions created by dbms?

1008

What is on delete restrict?

1000

How to test for null values?

1050

how to convert dates to character strings? : Sql dba

1169

what's the maximum size of a row? : Sql server database administration

1084

What is blob data type in oracle?

1123

what is data manipulation language? : Sql dba

1016

In which format does an image save in SQL Server database ?

1001

For More Un-Answered { Databases } Questions Click Here