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 the difference between partitioning and sharding?

1 1078

What is memory optimized table?

1 1112

Is coalesce faster than isnull?

1 1054

Can we rollback delete command?

1 1051

What is a temporal data type?

1 1120

How do you identify a primary key?

1 1128

What is the need of a partition key?

1 1059

How do you rename a procedure in mysql?

1 1000

How show all tables in mysql query?

1 1013

How much does mysql enterprise cost?

1 999

How do you create a table in mysql workbench?

1 1007

How to use count function in mysql?

1 998

How do I view data in mysql workbench?

1 1079

How do you rename a table in mysql?

1 1136

Is mysql a free database?

1 1010

Un-Answered Questions { Databases }

What is self contained sub query?

1138

Why use identity in sql server?

1191

What is the latest version of postgresql?

951

How to convert character strings into numeric values?

1186

Is inner join faster than left join?

1273

Where can you add custom error messages to sql server?

1203

What are the two main functions of queries in databases?

1525

How raid can influence database performance?

1114

What is in place upgrade in sql server?

1123

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1207

What are the types of database explain each of them briefly?

1053

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1293

What are the different SQL Server Versions you have worked on?

1077

Does view occupy space?

1005

Equi join and non equi join is possible with sql server?

1126

For More Un-Answered { Databases } Questions Click Here