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

Explain datetimeoffset data type in sal server 2008?

975

What is buffer cash in sql server?

1206

Define master database?

1143

Explain transaction server auto commit?

1092

What are the essential components of sql server service broker?

1069

Why do we use non clustered index?

1135

How to use the inserted and deleted pseudo tables?

1009

Define full outer join?

1013

Explain concepts of analysis services?

1018

Explain where clause?

1037

What are the advantages of sql stored procedure?

1128

Explain syntax for disabling triggers?

1100

Define left outer join?

1029

How dts is used to extract, transform and consolidate data?

1117

How to implement service broker?

1074

Un-Answered Questions { Databases }

What happens if you are trying to access a schema not owned by you?

1023

‘Order by’ is not allowed in a view how can you sort information from a view?

1126

what is raid? : Sql server database administration

1088

What is innodb mysql?

1163

What is the use of sp_helprotect in sybase?

1023

What is acid property in a database?

1088

What are the differences between web role and worker role?

124

Can we use distinct and group by together?

1110

What is sharded database?

1014

Can I use sql azure as a backup with log shipping or database mirroring?

156

What are data modelling techniques?

1029

Explain the different types of languages that are available in the dbms?

964

Where are full-text indexes stored?

1040

What is the default isolation level in sql server? : Transact sql

1089

Give the query of getting last two records from the table in SQL SERVER?

1015

For More Un-Answered { Databases } Questions Click Here