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 define the name and server for a new dsn?

1205

How to create a trigger for insert only?

1091

How to delete a login name in ms sql server?

1131

What are the differences between decimal and float in ms sql server?

1359

How to replace given values with null using nullif()?

1043

How to insert new line characters into strings?

1034

How to sort query output in descending order in ms sql server?

987

How to start and end transact-sql statements?

1090

What is sqlservr.exe - process - sql server (sqlex?press)?

1160

How to get a list of all tables with "sys.tables" view in ms sql server?

1088

How to attach adventureworkslt physical files to the server?

1166

How to download and install microsoft sql server management studio express?

1099

Does the unique constraint create an index?

1143

How to use column default values in insert statements in ms sql server?

1107

How to get a list of columns using the "sys.columns" view in ms sql server?

1013

Un-Answered Questions { Databases }

What is the difference between insensitive and scroll cursor?

1247

Explain the truncate command? : SQL Server Architecture

1241

What are the characteristics of modern DBMS?

1147

What's difference between dbms and rdbms ?

1008

Why normalization is used?

1069

Is sybase open source?

927

Do you know what is difference between stored procedure and user defined function?

1158

How do I know if localdb is running?

1001

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

1020

What is Command line parameters in PLSQL.?

1197

How do I delete a mysql user?

893

List down the features of informix 4gl.

Can function return multiple values in sql?

1103

What do you understand by the term 'normalization'?

716

How do you change the order of columns?

903

For More Un-Answered { Databases } Questions Click Here