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

Explain hostprotectionattribute in sql server 2005?

1075

What is exclusive locks?

1016

What is update locks?

940

Determine when an index is appropriate?

1137

Can you explain important index characteristics?

1033

Explain the purpose of indexes?

1027

Explain full-text indexing?

1045

Do you know clustered and non-clustered index?

1025

Explain the difference between clustered and non-clustered index?

971

Explain having clause and where clause?

1103

Explain indexes disadvantages?

1151

Explain what is it unwise to create wide clustered index keys?

1028

Ms sql server index?

1105

Do you know what is fill factor and pad index?

1047

How to maintain a fill factor in existing indexes?

1060

Un-Answered Questions { Databases }

What are constraints in microsoft sql server?

1221

What is merge statement?

1139

suppose you want to audit specific activities on sensitive data. How can you achieve that?

1059

What causes the "snapshot too old" error? How can this be prevented or mitigated?

554

In which language it is written?

1012

Is it good to store image in database?

954

Differentiate between syntax and runtime errors.

1242

Write command to import an mysql file?

1098

How do I disconnect mysql workbench?

1116

How do I find duplicates in the same column?

1177

By default, which replica sets are used to write data?

Explain constraining triggers.

1167

What is SQL Azure Data sync?

123

How to install oracle database 10g xe?

1066

What is 'mysqldump'?

1122

For More Un-Answered { Databases } Questions Click Here