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 ISAM?

1 1181

How can you see all indexes defined for a table?

1 1183

Define REGEXP?

1 1162

What are all the Common SQL Function?

1 1243

How to returns the columns and column information pertaining to the designated table.

1 1094

What is the difference between BLOB AND TEXT?

1 1245

How MySQL Optimizes DISTINCT?

1 1191

How can we find out which auto increment was assigned on Last insert?

1 1158

How to Set a root password if there is on root password.

1 1174

What is the difference between MyISAM Static and MyISAM Dynamic?

1 1104

What is the difference between the LIKE and REGEXP operators?

1 1113

What storage engines are used in MySQL?

1 1138

Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.

1 1081

Where MyISAM table will be stored and also give their formats of storage?

1 1129

Is Mysql query is case sensitive?

1 1115

Un-Answered Questions { Databases }

How to provide default values to function parameters?

1246

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1041

How do I start sql server 2017?

1009

How many concurrent programs you have customized, can you name some of them?

how to use regular expression in pattern match conditions? : Sql dba

1105

What is standby servers? Explain types of standby servers.

1069

Disadvantages of the indexes?

1216

How to use values from other tables in update statements using oracle?

1147

What kind of problems occurs if we do not implement proper locking strategy?

1493

What is an indexed view?

1018

How to convert numeric expression data types using the cast() function?

1142

How raid can influence database performance?

1107

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1021

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 is the difference between upgrade and migration in sql server?

1171

For More Un-Answered { Databases } Questions Click Here