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

What are the different Topologies in which Replication can be configured?

1 1279

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

1 1202

What are the different Authentication modes in SQL Server and how can you change authentication mode?

1 1155

What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

1 1111

What is meant by Active-Passive and Active-Active clustering setup?

1 1302

List out a number of the wants to setup a SQL Server failover cluster?

1 1148

What is Transparent Data Encryption?

1 1070

Explain in brief about Microsoft SQL server?

1 1201

Explain about merge replications?

1 1093

Explain about SQL server 2005?

1 1041

Detail about the hardware which is supported by SQL server?

1 1143

Explain about thread and memory management process of SQL?

1 1052

Explain about integration services of Microsoft SQL server?

1 1110

Explain about analysis services?

1 1131

Explain about the command-line tool SQLCMD?

1 1179

Un-Answered Questions { Databases }

Why use identity in sql server?

1189

what are the advantages of sql ? : Sql dba

1136

What is a view in sql?

1035

When should you use an instead of trigger?

1042

What is normalization and what are the advantages of it?

1050

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

1490

How do I create a trace in sql server?

1109

How do I find query history in sql server?

1018

what is the difference between openrowset and openquery?

1186

Is inner join faster than left join?

1271

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1041

What is your daily office routine?

2333

What is the difference between for xml raw and for xml auto?

1108

What is self contained sub query?

1134

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1059

For More Un-Answered { Databases } Questions Click Here