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 7056

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

HCL, LN,

5 19308

give a simple example of physical and logical data independence

2488

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 10212

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

2314

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 12208

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

Genpact,

3 8553

How to find only %th Highest Sal

Infogain, Symphony,

6 11993

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

Scio Healthcare,

3 6195

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

Metric Stream,

2 9685

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

CTS,

2 10489

What are the Diff B/W Cursor and REF Cursor

CTS,

3 12963

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

Doyensys,

4 15347

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

IBM,

2 6111

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

Sutherland,

1 8700

Un-Answered Questions { Databases }

What is a tns service name?

944

How can we force the database to use the user specified rollback segment?

1069

What is sharded database?

897

Can you sum a count in sql?

956

how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.

860

What are the different types of modeling?

861

Is this statement true or false? All databases must be in third normal form?

938

What is the difference between cold backup and hot backup?

538

What is a Transformation?

973

What is the main difference between union and union all?

832

What is the purpose of optimization?

953

How to change system global area (sga) in oracle?

959

Explain what are the type of synonyms?

1056

What is the instance of a relation?

957

How delete a row in sql?

929

For More Un-Answered { Databases } Questions Click Here