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 normalization? Explain different forms of normalization?

1170

Explain candidate key, alternate key, and composite key?

1013

Please explain go command in sql server?

1067

Tell me what is log shipping?

992

Do you know what is lock escalation?

1023

What are the different index configurations a table can have?

977

Explain difference between cross join and full outer join?

1018

What is the stuff and how does it differ from the replace function?

1147

Explain what is use of dbcc commands?

1071

Explain what is raid and what are different types of raid levels?

1037

Explain the use of keyword with encryption. Create a store procedure with encryption?

970

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

955

Explain what are the basic functions for master, msdb, model, tempdb databases?

994

Explain what are commit and rollback in sql?

943

please differentiate between delete and truncate?

1004

Un-Answered Questions { Databases }

What is the role of driver manager?

1025

What is spool?

1063

What is ms access and features?

833

we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

2540

What you know in mapping of erd to dfd?

979

How to declare and use cursor variables?

1187

Can binary strings be used in arithmetical operations?

948

What is the best postgresql gui tool?

831

What is the maximum length of an alert name?

1013

What is the function of DML Compiler?

1228

Where is data stored in a database?

1017

What are stored procedures in mysql?

1032

How do queries work in a database?

1037

How to set the time zone for MySQL to particular country time?

3209

What is a pdo connection?

1058

For More Un-Answered { Databases } Questions Click Here