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

How to include comments in sql statements?

1020

What are numeric data types?

1051

What are ddl statements in mysql?

1136

What is 'mysqlshow'?

1122

How many sql ddl commands are supported by 'mysql'?

1193

What are the differences between char and nchar?

1196

How many sql dml commands are supported by 'mysql'?

1035

What are the differences between char and varchar?

1161

How to enter numeric values as hex numbers?

1041

Explain what is mysql?

1086

How to use case expression?

1022

How to show all tables with 'mysql'?

1068

How many ways to get the current time?

1016

How to convert dates to character strings?

1139

How to drop an existing index in mysql?

1163

Un-Answered Questions { Databases }

What is mongojs?

What is the difference between the 2 operating modes of database mirroring?

1172

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

946

How can you list all the columns in a database?

978

How to create a testing table in oracle?

1038

What is openedge translation manager?

1130

How to declare variable in mysql trigger?

1071

What is difference between views and stored procedures?

1034

what is the difference between filters and conditions?

2517

What is the difference between insensitive and scroll cursor?

1252

Why use “pivot” in sql server?

1190

What is data profiling in sql?

1143

Is delete faster than truncate?

1057

What are the instances when triggers are appropriate?

1024

Suggest a method of joining two tables.

1239

For More Un-Answered { Databases } Questions Click Here