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

what are the main differences between ms access and sqlserver

C DAC, CDAC,

1 4962

Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 5770

What is the difference between SQL and SQL Server?

Cognizant, HCL,

3 9175

Which is better Oracle or MS SQL? Why?

Bally Technologies,

2 5033

Which is better Oracle or MS SQL? Why?

Bally Technologies,

2 6484

i want department wise maxmum salary and empolyee name

9 30112

Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?

IBM,

1 4063

in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out

4 6040

what is meant by gateway

IBM,

1 4180

hOW TO LOAD SOURCE INTO TARGET 2 TIMES?(INFORMATICA)

2 4833

Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?

4719

WHICH IS THE BEST INSTITUTE IN HYD FOR "ORACLE"?

3 5087

what is integrated security (SSPI). why we use in the connection string?

2 7542

emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example

1 3461

I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?

Zensar,

2 5564

Un-Answered Questions { Databases }

What is a trace frag? Where do we use it?

1155

What is the Disadvantage of indexed sequential file.

1130

Can you have more than one content canvas view attached with a window ?

2371

Explain about integration services of Microsoft SQL server?

1089

What is view explain with example?

999

Does mongodb need a lot of ram?

What is a nvl function?

1096

How do I clean up sql server transaction log?

1126

How to use subqueries in the from clause in oracle?

1165

What is mysql and why it is used?

1132

What is varchar sql?

1207

What does trigger mean in slang?

1124

How to list all user names in a database?

1094

Is nosql database types?

What is a partition in oracle?

1205

For More Un-Answered { Databases } Questions Click Here