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 6353

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 16201

what is DTS what are tasks available

Wipro,

1 3821

Normalization and denormalization

Wipro,

3 6843

Diffrent types of function

Wipro,

1 4450

diffrence between function and procedure

Wipro,

5 7417

diffrence between Cluster Index and non Cluster Index

Wipro,

3 6224

System variable and temporary variables

Wipro,

2255

optimization techinques

Wipro,

2680

user defined datatypes

Wipro,

1 4503

What is bulk collections?

2 7867

what is External tables? explain with examples

TCS,

2 13827

what is difference between decode and case function?

2 10153

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 a checkpoint and When does it occur?

778

How do I partition a table in sql server?

1047

what is a composite primary key ? : Sql dba

1055

How many joins in sql server?

962

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5412

Can you redefine a table online?

1117

How can you see all indexes defined for a table?

1123

What is string join?

981

What is the importance of a recovery model? : sql server DBA

1031

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2464

Why use sub query in sql server and list out types of sub queries?

1000

Why use truncate instead of delete?

1017

Does windows 10 have microsoft access?

845

What privilege is needed for a user to create indexes in oracle?

1028

Is mongodb compass open source?

For More Un-Answered { Databases } Questions Click Here