Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3259)
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 Join and explain its types?

1103

What is the user of Primary key?

985

How does index makes search faster?

QuestPond,

979

How can we delete Duplicate row in table?

Wipro,

1066

How would you use user_constraints table in DB?

Wipro,

1008

Why do we backup Active Directory ?

1042

What is normalization? Describe its different types.

Wipro,

1103

What is the difference between DATETIME2 and DATETIME?

Infosys,

1080

What do you mean by the term 'normalization'?

Tech Mahindra,

1209

What is the difference between clustered and a non-clustered index?

NA,

1028

What is the difference between TRUNCATE and DROP?

1140

What are the disadvantages of using querystrings to send data from one page to another?

1008

What is the difference between ddl,dml and dcl commands?

BirlaSoft, Verifone,

1112

Explain DBCC?

QuestPond,

960

Explain what role entity and relationship play in an ER diagram.

1071

Un-Answered Questions { Databases }

How do you truncate?

906

What is cursor and its types?

1073

Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?

190

What is Multivalued dependency?

781

How to define an oracle sub procedure?

1144

Can you name some of the dml commands in sql?

1031

Is the internet a database?

938

How do I know if oracle client is installed on windows?

1024

What do you understand by unique key?

987

What is difference between stored procedure and user defined function?

1106

As couchdb is written in erlang and erlang is known as slow to adopt unicode. So, if it creates a problem for couchdb?

When you used JKM ?

587

what is meant by magic query

2186

What is a data source file?

974

how to toggle ms word to ms excel or ms excel to ms word

2077

For More Un-Answered { Databases } Questions Click Here