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 the difference between distinct clause and group by clause?

HHH, Value Labs,

2 16738

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

C3I, eSoft, iPRO Solutions, Wipro,

3 19580

What is an extended Stored Procedure?

1 6566

What is Trigger?

Misys,

3 10782

What is a view? is View updatable?

IBM, L&T,

17 35124

What is the difference between having and where clause?

4 10595

Why we need a group by clause?

4 10397

What is a join and their types?

Challenger Financial,

2 7578

What is the difference between referencing and joining?

1 4154

What is the difference between constraints and triggers?

Wipro,

9 36687

What is ACID Property of Transaction?

10 38012

What is an index?

Yardi Software,

8 15490

What is normalization and its forms?

Challenger Financial,

4 14360

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

8 19320

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

11 54395

Un-Answered Questions { Databases }

What are the uses of Oracle Rollback Segment?

1145

Explain the difference between function and stored procedure?

962

How can you perform pattern matching in sql?

1009

master table and child table performances and comparisons in Oracle ?

2151

A tablespace has a table with 30 extents in it. Is this bad? Why or why not.

595

Do you know what is a trace frag? Where do we use it?

1022

Explain the different normalization forms?

1126

What are four common errors found in an alert .log?

571

Write an sql query for deleting duplicate rows?

1013

Equi join and non equi join is possible with sql server?

1036

How many columns can a table have?

935

Explain trigger and trigger types?

1001

Write a query to stop mysql in unix

1066

How many row comparison operators are used while working with a subquery?

1044

1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

17683

For More Un-Answered { Databases } Questions Click Here