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 do you simulate a deadlock for testing purposes

1 10302

what is thae main difference between foreingkey and primarykey

5 8890

which version of mysql can't support stored procedure??

3 6098

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

DELL,

13 19552

how to get the third quarter of employee details from emp?

CompuTech,

2 7948

How can i insert data inro a table with 3 columns using FORALL?

Oracle,

2 10861

find the third highest salary?

23 44375

i have cleared the nic test...please send me the interview questions if anyone have them.... my email id is v84priya@gmail.com

NIC,

1881

how to display only 4 records from a table based on a condition for ex i have a table called products in that nid,prodname are fields i want to display only any 4 records of perticular product plz tell me

6 7428

What is the Tune Query

2298

what is autonomouse transaction?

Oracle,

3 8236

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

HCL, ZX,

5 9919

what is the difference between group and having give an example with query and sample output

7 9958

What is Data model and how to prepare a data model.?

TCS,

1 5649

what is a stored procedure and trigger?

3 6076

Un-Answered Questions { Databases }

What is max pool size?

782

What is sqlcommand?

1032

Where is trigger in sql server?

1051

Describe triggers features and limitations?

993

What is a table partition?

1141

What is an Oracle Data Segment?

1054

explain GROUPBY & HAVING clause with examples.

2297

Name three of the features managed by the surface area configuration tool? : sql server security

998

What are the restrictions applicable while creating views? : SQL Server Architecture

1031

List the types of locking?

1012

What are the limitations of database?

900

What is an access?

815

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

1024

what is insert all statement in sql

6528

What is the rdbms concept in sql?

996

For More Un-Answered { Databases } Questions Click Here