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 19525

give a simple example of physical and logical data independence

2564

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 ?

2396

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 12418

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 12271

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 9823

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

CTS,

2 10623

What are the Diff B/W Cursor and REF Cursor

CTS,

3 13121

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 6221

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

Sutherland,

1 8816

Un-Answered Questions { Databases }

What do you know about mongodb?

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1098

How to show all records starting with the letters 'sonia' and the phone number '9876543210'

932

Which was the neo4j first version and when was it released?

What are different types of raid configurations? : SQL Server Architecture

1083

What is scaling in mongodb?

Is postgresql scalable?

827

What is serial sql?

974

What is Database Management System?

1186

Explain the update statement in sql

992

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

1032

Is ms access a rdbms?

736

how may join possible between (requisition with purchase order)

2248

Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

2525

How would you enter characters as hex numbers?

943

For More Un-Answered { Databases } Questions Click Here