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

Differentiate between delete and truncate.

1077

You want to implement the many-to-many relationship while designing tables. How would you do it?

1010

Why do we need different type of parameter?

1069

What do you mean by acid?

1024

What is rank function?

1051

Explain different types of locks in sql server.

1098

What are the benefits of normalization?

1127

What are distributed partitioned views?

1089

Differentiate between a primary key and a unique key.

1086

Define candidate key, alternate key, and composite key.

938

Explain indexed views and partitioned view with their syntax.

1158

Difference between report and query parameter. Why do we need different type of parameter?

972

What is difference between stored procedure and user defined function?

1124

You want to implement the one-to-many relationship while designing tables. How would you do it?

973

What’s the use of custom fields in report?

960

Un-Answered Questions { Databases }

Can you copy and paste from excel to access?

830

What are 3 types of databases?

983

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1130

What is function of CUBE ?

1064

issues involved in modeling and building data werahouses

1977

What is the default sql server instance name?

1050

what is database black box testing? : Mysql dba

1128

Is natural join and equi join same?

990

What does >> do?

598

What is the depth of triggers?

996

write a query to mysql in safe mode and to change the root password

972

What are the difference between primary keys and foreign keys?

981

What do you mean by database?

1103

Do you know what are pages and extents? : SQL Server Architecture

1006

How to create a stored procedure with a statement block in ms sql server?

1089

For More Un-Answered { Databases } Questions Click Here