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 a coalesce? What is the equivalent of oracle/db2 coalesce function in sybase?

908

How does partition assignment relate to transactions in sybase?

873

What is asa in sybase?

927

How do I configure the burn factor in sybase?

878

What is replication server in sybase?

832

What are the best monitoring tools for the sybase database?

824

What is cis and how can I use it?

1076

How do I choose which tables to partition in sybase?

865

How to clear tempdb when the tempdb gets filled in sybase?

840

How do I correct time slice -201?

949

What is the command for quitting from sybase?

929

Given a table which contains some rows with duplicate keys, how would you remove the duplicates?

854

How to view the log files in sybase?

935

How do I turn off marked suspect on my database in sybase?

883

How do I bcp null dates in sybase?

933

Un-Answered Questions { Databases }

What is the maximum number of index per table?

1073

How are the stats updated in postgresql?

858

What is checkpoint in sql server?

1160

Is database a hardware or software?

997

How many anonymous blocks can be defined?

1184

All questions related to Control m monitoring tool

2545

Do you know query execution plan?

1176

Is it possible to read/write files to-and-from PL/SQL?

1102

what is the difference between call_form, new_form and open_form?

1308

What is the function of DML Compiler?

1201

What do you mean by erd and its main elements?

780

Why 32 bit version of mongodb are not preferred ?

Explain “not null constraint” in sql server?

1029

What are the differences between primary key and unique key?

1010

Is foreign key an index?

800

For More Un-Answered { Databases } Questions Click Here