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,

1096

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 would you extract DDL of a table without using a GUI tool?

2488

How to get list of all tables from a database?

1160

What are the integrity rules in dbms?

1100

What is rename command in sql?

1035

What is function of master database?

114

How to change sql*plus system settings?

1054

What are the various editions of sql server 2017 that are available in the market?

890

What are different types of queries?

944

What is a database lookup?

1095

Which tcl commands are available on the sql server?

1082

What is difference between sql and mysql?

1131

How can I change database in mysql?

888

what's query optimization and without use of IN AND Exist can we get another way data from query

2141

What are the general features of sql server management studio? : sql server management studio

1076

What are the dml statements?

1141

For More Un-Answered { Databases } Questions Click Here