Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3259)
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 do you send email on SQL Server?

MindCracker,

1064

How to concatenate two strings in SQL Server.

HCL,

1149

In which format does an image save in SQL Server database ?

MCN Solutions,

1001

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

QuestPond,

1135

What is the default port for SQL Server over a firewall?

Microsoft,

1097

What is the syntax for encrypting a column in SQL Server?

MindCracker,

1120

what is difference between NULL and ISNULL in SQL Server 2008?

MCN Solutions,

1014

How to create a Master database in SQL server ?

MCN Solutions,

1088

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

MCN Solutions,

1208

Difference between LEN() and DATALENGTH() in sql server ?

HCL,

1104

Show Practically Sql Server Views are updatable?

QuestPond,

1123

Define tool Manage Statistics in SQL Server 2000 query ?

NA,

1093

What is dynamic cursor in SQL SERVER?

1079

How you can change the database name in SQL SERVER?

1192

how we use window authentication connection with sql server.?

MCN Solutions,

1152

Un-Answered Questions { Databases }

How do I create a database?

899

How do I automate a backup in mysql?

992

Compare mongodb and couchdb at high level?

What are the various types of relationships in database? Define them.

895

How to move a multi-file database?

1033

What is the difference between left join and right join?

942

What is primary key in ms access 2007?

843

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2619

Why is the basic difference between left join, right join and inner join?

1030

Write a query to stop mysql in unix

1051

How to do paging with oracle?

999

Explain about the command-line tool SQLCMD?

1088

How index is used in mongodb?

What are the types pl/sql code blocks?

1127

What is the difference between clustered index and primary key?

922

For More Un-Answered { Databases } Questions Click Here