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

How do triggers work?

960

Can we call stored procedure in function?

979

Why is theta join required?

1156

What is procedure explain with example?

980

Is full outer join same as cross join?

987

What is difference between nchar and nvarchar?

1051

Can we use commit inside a trigger?

1105

What is procedure explain with program?

1035

How does cross join work?

971

Which table is left in left join?

1030

How does stored procedure reduce network traffic?

1026

What is difference between table and view?

1079

What are types of joins?

986

Can we use view in stored procedure?

918

What is program debugging?

1276

Un-Answered Questions { Databases }

What are the new features are introduced in sql server 2012 reporting services?

156

how to fetch common records from two tables? : Sql dba

1197

How to experiment a data lock in oracle?

1072

What do you understand by the term 'normalization'? Explain the various modes of normalization?

567

Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?

545

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

2130

What is rank in database?

895

Are subqueries faster than joins?

1037

How many types of locks are present in a database?

1147

Are sql connections encrypted?

1043

What is normalization and denormalization in sql server?

1031

What is a trigger and types of a trigger?

997

What is the simplest way to create a new database in ms sql server?

1019

Is mysql easy to learn?

956

What is a record in a database?

1075

For More Un-Answered { Databases } Questions Click Here