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

How write primary and foreign key relationship between two tables without using constraints? u can use any of procedure/function/trigger and any sql?

Parexel,

1 7233

what is the difference between joins and set operators.i am always confusing with two,can u pls kindly help me .

HCL, LN,

5 19707

give a simple example of physical and logical data independence

2625

I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.

MTS,

7 10661

can u pls share responsibilities for production how to environment in odi?and how to generate report ?

2441

I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.

Cap Gemini, MTS,

4 12612

how to get max salary with employee number by using one select query and max function ??

Genpact,

3 8845

How to find only %th Highest Sal

Infogain, Symphony,

6 12511

What are the difference between data length and length in SQL Server-2008?

Scio Healthcare,

3 6512

How will you make performance better for application including front end and back

Metric Stream,

2 9941

Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?

CTS,

2 10716

What are the Diff B/W Cursor and REF Cursor

CTS,

3 13256

difference between table level constraint and column level and advantages of table level constraint

Doyensys,

4 15791

Why foreign key column allowing null values even a parent tables reference key column not having null value..

IBM,

2 6313

What is the difference between Memory_target and Memory_max_target? Why its required to resize these parameter?

Sutherland,

1 8901

Un-Answered Questions { Databases }

Explain the use of online redo log files in oracle.

1077

What do you mean by the term 'normalization'?

1282

Can you type more than one query in the query editor screen at the same time?

1069

Explain oracle left join with an example?

1063

What is table partitioning in sybase?

947

What is a non equi join?

1023

What is xml datatype?

1129

what are the oracle forms services components include?

1084

What are the advantages of sql?

1100

What is limit in dbms?

1109

Is microsoft access difficult to learn?

823

What is oracle block? Can two oracle blocks have the same address?

1078

How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?

2458

Explain multiserver query

1113

Which is the best database?

967

For More Un-Answered { Databases } Questions Click Here