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

945

How does partition assignment relate to transactions in sybase?

942

What is asa in sybase?

1010

How do I configure the burn factor in sybase?

923

What is replication server in sybase?

896

What are the best monitoring tools for the sybase database?

873

What is cis and how can I use it?

1126

How do I choose which tables to partition in sybase?

904

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

890

How do I correct time slice -201?

1045

What is the command for quitting from sybase?

981

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

905

How to view the log files in sybase?

992

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

927

How do I bcp null dates in sybase?

998

Un-Answered Questions { Databases }

What is sybase replication server?

1046

What do you mean by entity type?

1125

What do you mean by oracle dba and what is its role?

630

Is mongodb better than other sql databases? If yes then how?

Explain alias in sql?

1094

List the data types available in mssql?

1104

How to create a table index in mysql?

1016

Does sql backup shrink transaction log?

1045

Is sql server is free?

1017

I am new to sas, can anybody explain the process of extracting data from source systems,storing in ods and how data modelling is done?

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

1312

What is Sqlpaging in SqlServer 2005 ?

1115

does the query needs a hint to access a materialized view?

1906

Is oracle an open source?

1127

What is the job of the information stored in data-dictionary?

851

For More Un-Answered { Databases } Questions Click Here