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

MindCracker,

1121

How to concatenate two strings in SQL Server.

HCL,

1213

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

MCN Solutions,

1061

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

QuestPond,

1190

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

Microsoft,

1147

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

MindCracker,

1180

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

MCN Solutions,

1060

How to create a Master database in SQL server ?

MCN Solutions,

1147

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

MCN Solutions,

1271

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

HCL,

1175

Show Practically Sql Server Views are updatable?

QuestPond,

1197

Define tool Manage Statistics in SQL Server 2000 query ?

NA,

1168

What is dynamic cursor in SQL SERVER?

1141

How you can change the database name in SQL SERVER?

1254

how we use window authentication connection with sql server.?

MCN Solutions,

1216

Un-Answered Questions { Databases }

Which one is better sql or oracle?

1015

Explain relationship between jdbc and sybase.

953

What types of replication are supported in sql server?

1122

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

1474

How will you add a new style in a table?

850

What is the difference between BPA AND Contract What are documents and test cases u followed

2443

What stored by the tempdb ? : sql server database administration

1100

what is nonclustered index

1007

In which format data is stored in mysql database?

1057

What are the disadvantages of file processing systems?

1077

How to change server name in sql server?

1259

What is primary key and unique key?

1171

What is 32-bit nuances?

how to take mysql database backup?

1131

Is left join same as inner join?

1222

For More Un-Answered { Databases } Questions Click Here