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

Explain how to use linked server?

1005

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

929

Do you know what are acid properties of transaction?

973

Explain what is lock escalation?

1079

Explain what are magic tables in sql server?

1007

Tell me what are cursors and when they are useful?

968

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

1034

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

1108

Tell me when is the update_statistics command used?

1133

Explain the xml support sql server extends?

1047

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

998

Do you know what is rank function?

1091

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

1037

Do you know what are acid properties?

1093

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

989

Un-Answered Questions { Databases }

did u received a single file or multiple files

2028

What are the different types of keys in the database?

960

What is difference between equi join and natural join?

1054

How do I start sql server?

989

Does a primary key have to be a number?

976

How do I start pgadmin 4 on windows?

896

What is database mirroring?

1127

Can pl sql procedure have a return statement?

1040

How to retrieve field values using mssql_result()?

1334

What are the restrictions while creating batches in sql server?

1076

Can I run multiple instances of sql server 2000 at the same time on one computer?

1086

When are we going to use truncate and delete?

1001

What is called dbms?

1064

If a ‘movechunk’ fails, is it necessary to cleanup the partially moved docs?

What is end user data?

811

For More Un-Answered { Databases } Questions Click Here