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 1194

What is query and its types?

1 991

Why main is user defined function?

1 1058

Why do we partition data?

1 1106

What is difference between aggregate and analytic function?

1 999

What is the data type of time?

1 1022

What is a partition key?

1 1068

What are the advantages of partitioning?

1 1204

What is the partitioning method?

1 1089

Can coalesce return null?

1 1084

Does hive support indexing?

1 1025

Does partitioning ssd reduce performance?

1 957

Does partitioning help performance?

1 1015

Does partitioning improve performance?

1 1040

Un-Answered Questions { Databases }

how to use regular expression in pattern match conditions? : Sql dba

1105

How to convert character strings into numeric values?

1186

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

1110

what is the command syntax for inserting a document?

what is the difference between openrowset and openquery?

1186

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

1108

What is the difference between upgrade and migration in sql server?

1175

what is dbms? : Sql dba

1059

Does group by remove duplicates?

1108

When should you use an instead of trigger?

1042

How do I find query history in sql server?

1018

Can we use distinct and group by together?

1130

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1291

Are you familiar with user exits in reports?

Were you involved in any data conversion, which one?

For More Un-Answered { Databases } Questions Click Here