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 proper subset of candidate key?

1 1051

What is the concept of optimization?

1 1120

What is the benefit of normalization?

1 1147

What is the full meaning of dml?

1 1008

What is optimization and its types?

1 1043

What is a ddl statement?

1 967

What is difference between equi join and inner join?

1 1048

What is the most common type of join?

1 1047

What is a periodical index?

1 989

What is abstracting periodical?

1 1005

What is mean by candidate key?

1 1069

What is purpose of normalization?

1 1005

What is the difference between composite index and covering index?

1 1018

What is difference between count (*) and count column?

1 955

What is the synonym of join?

1 1022

Un-Answered Questions { Databases }

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1200

what is sql server agent? : Sql dba

1162

How to convert numeric expression data types using the cast() function?

1134

Explain system functions or built-in functions? What are different types of system functions?

1052

How to provide default values to function parameters?

1235

What are the kinds of subquery?

1087

Does view occupy space?

998

What is the current mysql version?

1082

what is dbms? : Sql dba

1048

How to use values from other tables in update statements using oracle?

1139

What versions of clipper does netlib support?

1062

How did mongodb get its name?

Can you index views?

946

Why should you use or avoid select * statements?

1094

what is bcp? When does it used? : Sql dba

1040

For More Un-Answered { Databases } Questions Click Here