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 constraints? Also explain the different types of constraints?

1027

What is mysql and why it is used?

1139

How to show table structure mysql?

1069

What is federated tables in mysql?

970

Explain the storage engines in mysql?

1060

What are the difference between mongodb and mysql?

1 1429

Write a query to find duplicate rows in table?

956

Write a query to fetch duplicate records from a table using mysql?

998

How to make a copy values from one column to another in mysql?

1078

How we can create index in mysql?

1030

What is mysql aggregate functions? Explain

1172

what is constraints?

1247

What's new in mysql 8?

1049

Is mysql is a programming language?

1047

List data types in mysql? Explain

975

Un-Answered Questions { Databases }

Can binary strings be used in arithmetical operations?

994

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

1366

How to fetch the next row from a cursor with a "fetch" statement?

1122

Explain commit, rollback and savepoint.

1059

How to clone the database using RMAN back

2330

How to use go command in "sqlcmd"?

1277

How to add a new column to an existing table with a default value?

1064

how can you record information about current session?

1116

What are the advantages of using stored procedures in sql server?

1062

what is a schema in sql server 2005? : Sql server database administration

1095

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2379

Define constraints and give an example of their use?

1103

How to filter data from a mysql database table with php?

947

What is data mart? : sql server analysis services, ssas

1117

What are cursors give different types of cursors?

1011

For More Un-Answered { Databases } Questions Click Here