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 is the difference between primary key and unique key and foreign key in oracle?

1046

what is the difference between substr and instr function in oracle?

1151

Explain the difference between sap and oracle?

1091

What is oracle join syntax?

1067

What is sybase infomaker?

1048

Explain the advantages of sybase iq.

955

Explain the features of sybase.

974

Explain the role of replication server in sybase.

931

What are the advantages that you can get from mainframe connect in sybase?

915

What is coalesce in sybase?

1006

Explain table partitioning in sybase.

979

Explain the advantages of data integration suite in sybase.

942

What do you mean by sybase iq?

948

What do you mean by asa in sybase?

1042

Is sybase a database? Explain.

1021

Un-Answered Questions { Databases }

Are subqueries better than joins?

1046

What is difference between standardization and normalization?

1172

I have a few records all are same structures data, I want to store data in multiple targets how

2716

Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.

1959

Explain about link server in sql server?

1125

Explain about the difficulties faced by the database developer in implementing pre compiled statements?

785

Explain the working of foreign key?

1147

How to display employee records who gets more salary than the average salary in the department?

1130

List out the different types of locks available in sql server?

1036

How to use fetch statement in a loop?

1072

List out the acid properties and explain?

1020

What is forms_mdi_window?

What is Service Broker in sql server 2012?

1080

Where can I learn sql for free?

1060

What is difference between equi join and natural join?

1132

For More Un-Answered { Databases } Questions Click Here