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

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 7153

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

HCL, LN,

5 19524

give a simple example of physical and logical data independence

2562

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 10449

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

2393

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 12415

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

Genpact,

3 8702

How to find only %th Highest Sal

Infogain, Symphony,

6 12270

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

Scio Healthcare,

3 6343

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

Metric Stream,

2 9818

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

CTS,

2 10621

What are the Diff B/W Cursor and REF Cursor

CTS,

3 13120

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

Doyensys,

4 15624

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

IBM,

2 6219

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

Sutherland,

1 8812

Un-Answered Questions { Databases }

Is there a combination of "like" and "in" in sql?

1065

Is microsoft access still used?

878

What is index length in mysql?

942

What is database architecture?

699

What is different keys in dbms?

938

How sql server enhances scalability of the database system?

1216

State some of the products of sybase?

899

How do you set a trace flag in sql server?

1035

Can you roll back the ddl statement in a trigger?

969

Determine when an index is appropriate?

1076

What does a senior database administrator do?

608

What the difference between UNION and UNIONALL?

1040

What are out-of-range errors with date and time literals?

1030

Data structure used to implements a menu:

1164

What is plpgsql language?

1063

For More Un-Answered { Databases } Questions Click Here