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 4964

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 5772

What is the difference between SQL and SQL Server?

Cognizant, HCL,

3 9180

Which is better Oracle or MS SQL? Why?

Bally Technologies,

2 5038

Which is better Oracle or MS SQL? Why?

Bally Technologies,

2 6487

i want department wise maxmum salary and empolyee name

9 30125

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 4064

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 6046

what is meant by gateway

IBM,

1 4183

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

2 4840

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

4720

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

3 5092

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

2 7544

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

1 3462

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 5567

Un-Answered Questions { Databases }

what is package and it uses and how can u call a package

2068

Explain about integration services of Microsoft SQL server?

1092

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1183

What are the varoius components of physical database structure of oracle database?

1042

How does sql developer connect to oracle database?

1051

How to view existing locks on the database?

1103

Is mongodb a relational database? Explain

What is the best alternative to microsoft access?

851

How do I edit a trigger in sql developer?

1054

What is a pl/sql block?

1330

What are the elements of a database?

958

What is oracle sql called?

979

Do you know what are the steps to process a single select statement?

1020

Does oracle partitioning improve performance?

1053

Compare sql & pl/sql

1211

For More Un-Answered { Databases } Questions Click Here