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 16889

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

C3I, eSoft, iPRO Solutions, Wipro,

3 19745

What is an extended Stored Procedure?

1 6634

What is Trigger?

Misys,

3 10972

What is a view? is View updatable?

IBM, L&T,

17 35763

What is the difference between having and where clause?

4 10774

Why we need a group by clause?

4 10586

What is a join and their types?

Challenger Financial,

2 7753

What is the difference between referencing and joining?

1 4267

What is the difference between constraints and triggers?

Wipro,

9 37055

What is ACID Property of Transaction?

10 38313

What is an index?

Yardi Software,

8 15802

What is normalization and its forms?

Challenger Financial,

4 14585

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

8 19659

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

11 54846

Un-Answered Questions { Databases }

What is the primary use of the model database?

1144

How many concurrent programs you have customized, can you name some of them?

what is the difference between openrowset and openquery?

1186

What is standby servers? Explain types of standby servers.

1075

how to start mysql server? : Sql dba

1260

How efficient you are in oracle and SQL server?

1251

what is sql server agent? : Sql dba

1179

What is a coalesce function?

1275

Are you familiar with user exits in reports?

List out the different types of locks available in sql server?

1045

Why and when do stored procedure recompile?

1052

What are the properties of the transaction?

1069

How to define array in mongoose schema?

How can I check that whether automatic statistic update is enabled or not?

1108

in oracle BPM composer in part BA model on design model in enterprise model i cannot connection with value chain model work not links in part properties do you can me help me?

1605

For More Un-Answered { Databases } Questions Click Here