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?

958

Explain 3nf?

955

How to export data from database and import into another?

924

Explain meant by 3-tier architecture?

950

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

857

What is the advantage of using preparedstatement?

952

Define and explain about progress?

939

How to create a database from my program?

1113

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

1014

What is the difference between case version and decode version?

1026

How to write udf s in delphi?

1029

How to drop all foreign keys in database?

1094

What is netlib for clipper?

899

What is metadata and why should I use it?

935

How to change database dialect?

982

Un-Answered Questions { Databases }

What is indexing explain it with an example?

1016

How do you create an append query?

941

Define scalar functions.

983

Does the order of columns in update statements matter?

916

How do I view a procedure in sql server?

996

1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?

2008

What is the most common sql injection tool?

1047

What is an oracle transaction?

1151

What is data source in connection string?

914

How can I join two tables in database?

1063

Differentiate between a local and a global temporary table?

961

What is difference between rank () row_number () and dense_rank () in sql?

1108

What is the syntax for encrypting a column in SQL Server?

1126

Explain index in sql server?

1021

What is the maximum number of triggers, you can apply on a single table?

1001

For More Un-Answered { Databases } Questions Click Here