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 is distributed queries?

953

Explain 3nf?

949

How to export data from database and import into another?

916

Explain meant by 3-tier architecture?

947

Is there some bulk load or other way to import a lot of data fast?

851

What is the advantage of using preparedstatement?

943

Define and explain about progress?

932

How to create a database from my program?

1105

how to generate an auto incremental number in a ssis package?

1011

What is the difference between case version and decode version?

1019

How to write udf s in delphi?

1024

How to drop all foreign keys in database?

1079

What is netlib for clipper?

893

What is metadata and why should I use it?

931

How to change database dialect?

975

Un-Answered Questions { Databases }

You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

906

Write a query to create a duplicate table with and without data present?

857

State the various uses of dbcc command?

1060

What are the advantages and disadvantages of using mysql?

1001

What will happen non-clustered index will be created on clustered index?

1047

What is the option used in PostgreSQL to increase the number of shared memory buffers shared among the backend processes

1324

What is data independence and also explain its types?

904

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

1005

Does office 2016 have access?

751

Explain the record term used in database.

1074

What is rdbms and its types?

872

What are the technical features of MySQL?

1011

How to turn on the mssql api module in php?

1078

What is the difference between the LIKE and REGEXP operators?

1035

Can we store files in mongodb?

For More Un-Answered { Databases } Questions Click Here