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 master database? : SQL Server Architecture

1086

Explain what are the database objects? : SQL Server Architecture

1148

What are pages and extents? : SQL Server Architecture

1077

Do you know spatial data types - geometry and geography in sql server 2008?

1093

Explain filtered indexes?

1043

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

1034

What is inline variable assignment?

1082

What is enhanced database mirroring in sql server 2008?

1037

Explain encryption of entire databases without the need for application changes in sql server 2008?

1092

Explain filtered indexes benefits?

1047

What is entity data services?

1118

What is plan freezing?

1017

Do you know how to store and query spatial data?

1091

What is compression - row-level and page-level compression?

965

Tell me extended events in sql server 2008?

1055

Un-Answered Questions { Databases }

What do you mean by the term 'normalization'?

1292

What do you mean by deferred update in sybase?

985

What are the advantages of using a stored procedure?

1065

Who uses access database?

881

Can I disable or restrict ssrs export formats (rendering formats)?

155

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1122

How do I create a stored procedure in sql server?

1101

What is the main difference between ‘between’ and ‘in’ condition operators?

1281

How many mysql connections can handle?

953

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

1073

What is a composite primary key?

1144

What is the difference between horizontal and vertical partitioning?

1046

Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

152

What is the most popular database?

991

What is normalization? What are different type of normalization?

998

For More Un-Answered { Databases } Questions Click Here