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 a group function explain with an example?

1 1065

What is table valued function and scalar valued functions?

1 1199

What is query and its types?

1 995

Why main is user defined function?

1 1059

Why do we partition data?

1 1108

What is difference between aggregate and analytic function?

1 1001

What is the data type of time?

1 1026

What is a partition key?

1 1070

What are the advantages of partitioning?

1 1204

What is the partitioning method?

1 1091

Can coalesce return null?

1 1088

Does hive support indexing?

1 1025

Does partitioning ssd reduce performance?

1 957

Does partitioning help performance?

1 1015

Does partitioning improve performance?

1 1042

Un-Answered Questions { Databases }

what is the command syntax for inserting a document?

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1128

What are the types of database explain each of them briefly?

1053

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 are the kinds of subquery?

1101

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2702

How to enter binary string literals in ms sql server?

1235

Is inner join faster than left join?

1273

What is an indexed view?

1018

Is microsoft getting rid of access?

883

what are the advantages of sql ? : Sql dba

1138

what is spatial nonclustered index

1054

What is sql server query analyzer?

1123

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

1149

What is normalization and what are the advantages of it?

1054

For More Un-Answered { Databases } Questions Click Here