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

what are the main differences between ms access and sqlserver

C DAC, CDAC,

1 4885

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 5665

What is the difference between SQL and SQL Server?

Cognizant, HCL,

3 8993

Which is better Oracle or MS SQL? Why?

Bally Technologies,

2 4943

Which is better Oracle or MS SQL? Why?

Bally Technologies,

2 6386

i want department wise maxmum salary and empolyee name

9 29788

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 3965

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 5895

what is meant by gateway

IBM,

1 4099

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

2 4723

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

4671

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

3 4951

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

2 7441

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

1 3389

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 5467

Un-Answered Questions { Databases }

How to neo4j create a node with id?

Where is mysql password stored?

930

How do I start mysql in mysql workbench?

952

Is it important for a database administrator to understand the operating system and file access?

993

What is dump in mysql?

887

wat wil hapn if we give the both read and deny read permission to user?

2103

What is crud sql?

984

How can you use check constraints for self referential integrity?

969

Can I work with several databases simultaneously? : sql server management studio

988

What is field in database give an example?

941

What are the benefits of mysql?

935

What are the advantages of mysql?

991

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

1037

Why normalization is used?

1009

Explain what is the main purpose of having conversation group?

939

For More Un-Answered { Databases } Questions Click Here