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

What is the difference between distinct clause and group by clause?

HHH, Value Labs,

2 16822

can we call stored Procedure in Function in Sql Server 2000 and vice versa.

C3I, eSoft, iPRO Solutions, Wipro,

3 19696

What is an extended Stored Procedure?

1 6611

What is Trigger?

Misys,

3 10909

What is a view? is View updatable?

IBM, L&T,

17 35588

What is the difference between having and where clause?

4 10717

Why we need a group by clause?

4 10512

What is a join and their types?

Challenger Financial,

2 7691

What is the difference between referencing and joining?

1 4230

What is the difference between constraints and triggers?

Wipro,

9 36931

What is ACID Property of Transaction?

10 38200

What is an index?

Yardi Software,

8 15693

What is normalization and its forms?

Challenger Financial,

4 14511

What is a cursor in SQL Server 2000 and their types?

8 19527

How do we get month name in SQL Server 2000, Oracle, MS Access?

11 54702

Un-Answered Questions { Databases }

What are actual parameters and formal parameters?

1180

What are the different authentication modes in sql server?

1170

How many rows can you have in an access table?

886

What is the difference between database trigger and stored procedure?

1144

What is database architecture? : SQL Server Architecture

1102

What is full form of rtm?

1056

What does mongodb mean?

How exceptions can be handled in sql server programming?

1077

What are temporal tables in sql server 2016?

934

How do I install mysql workbench?

951

What is the role of binary large object in informix?

What is the limitation of mysql?

1015

What is the difference between dropping a database and taking a database offline?

1223

What is the difference between composite index and covering index?

1011

What is index, cluster index and nonclustered index?

1052

For More Un-Answered { Databases } Questions Click Here