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 show table names with 'mysqlshow'?

1083

How to provide login information for a new odbc dsn?

1111

How to declare a cursor with "declare ... Cursor" in ms sql server?

1100

How to define and use table alias names in ms sql server?

1222

How to name query output columns in ms sql server?

1025

How to get the definition of a trigger back?

1049

What is wrong with sql server client libarary dll, ntwdblib.dll?

1103

Why I am getting this error when renaming a database in ms sql server?

1121

What is the security principal at the server level that represents your session?

1067

How to create an index on a view?

1152

What happens if you add a new index to large table?

990

How to convert binary strings into integers in ms sql server?

1094

What happens to a trigger with multiple affected rows?

1002

What are database states in ms sql server?

1260

What happens if null values are involved in arithmetic operations?

1050

Un-Answered Questions { Databases }

What are the events recorded in a transaction log?

1054

How do I change the default postgres password?

920

Is it possible to call a stored procedure within a stored procedure?

1038

How do I save a stored procedure in sql server?

1063

how to create a table index in mysql? : Sql dba

1136

Is mongodb unstructured?

Does uninstalling mysql delete database?

1093

Difference between truncate, delete and drop commands?

1151

What is the similarity between mongodb and couchdb?

How do you rename a table in mysql?

1113

What is the data quality in odi?

717

What are the five steps of data modeling?

1071

What is denormalization in a database?

1113

What does rownum mean in sql?

1095

Define RDBMS.

1220

For More Un-Answered { Databases } Questions Click Here