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 6351

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 16189

what is DTS what are tasks available

Wipro,

1 3820

Normalization and denormalization

Wipro,

3 6839

Diffrent types of function

Wipro,

1 4447

diffrence between function and procedure

Wipro,

5 7408

diffrence between Cluster Index and non Cluster Index

Wipro,

3 6217

System variable and temporary variables

Wipro,

2253

optimization techinques

Wipro,

2680

user defined datatypes

Wipro,

1 4499

What is bulk collections?

2 7863

what is External tables? explain with examples

TCS,

2 13821

what is difference between decode and case function?

2 10149

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 }

What is the difference between char and varchar in mysql?

1119

What is the use of function "module procedure" in pl/sql?

1198

What is left join example?

949

How to create “dependant” parameter “make, model, year”

131

Can we rollback truncate?

998

How to call stored procedure using http soap?

1079

Is primary key a clustered index?

968

What are the features of ms access?

742

How do I view an execution plan in sql?

986

What is a trace file and how is it created in oracle?

1062

What do you understand by unique key?

988

What is mysql routine?

934

What are the 5 r's of managing behaviors?

1089

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

1064

What is the option used in PostgreSQL to increase the number of shared memory buffers shared among the backend processes

1325

For More Un-Answered { Databases } Questions Click Here