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 is dbcc? : sql server DBA

1 1389

Why would you use sql agent? : sql server DBA

1 1177

What is replication? : sql server DBA

1 1270

What types of replication are supported in sql server? : sql server DBA

1 1387

Why would you call update statistics? : sql server DBA

1 1065

What are the different sql server versions you have worked on? : sql server DBA

1 1095

What is transparent data encryption? : sql server DBA

1 1278

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

1 1215

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1 1241

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1 1116

What happens on checkpoint? : sql server DBA

1 1184

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

1 1085

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

1 1098

What is fill factor? : sql server DBA

1 1344

What is the default port no on which sql server listens? : sql server DBA

1 1254

Un-Answered Questions { Databases }

How did mongodb get its name?

Are you familiar with user exits in reports?

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

1068

Why should you use or avoid select * statements?

1108

Can we use distinct and group by together?

1133

What is standby servers? Explain types of standby servers.

1077

please send me oracle pl/sql exp resume. and also faqs...

2568

How to define array in mongoose schema?

How to convert character strings into numeric values?

1187

How to write a left outer join with the where clause in oracle?

1151

Can you index views?

953

How to provide default values to function parameters?

1251

how to escape special characters in sql statements? : Sql dba

1113

Can one drop a column from a table?

1083

What are the kinds of subquery?

1103

For More Un-Answered { Databases } Questions Click Here