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 how to use linked server?

1033

What do you mean by an execution plan? How would you view it?

972

Do you know what are acid properties of transaction?

1008

Explain what is lock escalation?

1113

Explain what are magic tables in sql server?

1048

Tell me what are cursors and when they are useful?

998

Do you know what is a linked server in sql server?

1073

Do you know what is difference between stored procedure and user defined function?

1158

Tell me when is the update_statistics command used?

1208

Explain the xml support sql server extends?

1087

Explain the rules for designing files and file groups in sql server?

1022

Do you know what is rank function?

1128

Tell me what is normalization? Explain different forms of normalization?

1075

Do you know what are acid properties?

1124

Do you know what are the steps to process a single select statement?

1020

Un-Answered Questions { Databases }

How do I start microsoft access?

940

What is difference between database and dbms?

1063

How many scalar data types are supported in pl/sql?

1106

What is @@rowcount in sql?

1058

What is autocommit sql?

1046

What is a trigger what are the advantages of trigger?

1068

What is information schema in database?

1009

In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

1362

how to show all tables with 'mysql'? : Sql dba

1161

what is package and it uses and how can u call a package

2071

What is the purpose of ms access?

876

What's the difference between mysql and sql server?

1045

Explain concepts of analysis services?

1018

What is the boxing and unboxing concept in .net?

980

What are the properties and different types of sub-queries?

1063

For More Un-Answered { Databases } Questions Click Here