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,

1125

How to concatenate two strings in SQL Server.

HCL,

1222

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

MCN Solutions,

1064

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

QuestPond,

1202

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

Microsoft,

1155

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

MindCracker,

1191

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,

1159

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

MCN Solutions,

1280

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

HCL,

1176

Show Practically Sql Server Views are updatable?

QuestPond,

1200

Define tool Manage Statistics in SQL Server 2000 query ?

NA,

1173

What is dynamic cursor in SQL SERVER?

1150

How you can change the database name in SQL SERVER?

1258

how we use window authentication connection with sql server.?

MCN Solutions,

1226

Un-Answered Questions { Databases }

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

1112

What do you understand by oracle forms?

1120

Why are data files so large?

What is thr feature of change data capture?

1039

What is the execution plan in sql?

1078

Is mongodb a json?

What does the update command do?

1180

SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?

1079

How can you append an identity column to a temporary table?

1049

How to optimize stored procedures in sql server?

1252

Is mongodb relational database?

State three differences between Dbms and Rdbms?

1121

can u combine pipeline parallelism and partition parallalism? how and whan?

2388

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

992

Call by value and call by reference in procedure and function, with NOCOPY.

1354

For More Un-Answered { Databases } Questions Click Here