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 16718

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

C3I, eSoft, iPRO Solutions, Wipro,

3 19564

What is an extended Stored Procedure?

1 6550

What is Trigger?

Misys,

3 10756

What is a view? is View updatable?

IBM, L&T,

17 35034

What is the difference between having and where clause?

4 10556

Why we need a group by clause?

4 10368

What is a join and their types?

Challenger Financial,

2 7558

What is the difference between referencing and joining?

1 4142

What is the difference between constraints and triggers?

Wipro,

9 36628

What is ACID Property of Transaction?

10 37948

What is an index?

Yardi Software,

8 15433

What is normalization and its forms?

Challenger Financial,

4 14331

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

8 19266

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

11 54330

Un-Answered Questions { Databases }

Which language is used in sql?

1066

What is inverted file ?

1409

How many triggers are possible in mysql?

969

What is microsoft access database engine 2010?

932

What is datadir?

889

Is there a free version of mysql?

942

I have 2 tables with 1 million rows each. I have updated 1 row in first and 1 million update on second table. Now I commit both the updates. Which one will commit fast and Why?

2627

How many types of attribute relationships are there? : sql server analysis services, ssas

1081

What are the applications of rdbms?

876

You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?

612

what is the difference between join and union? : Sql dba

1122

Does sql support programming?

1076

What is localhost in mysql?

1008

How can a database be repaired?

996

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2244

For More Un-Answered { Databases } Questions Click Here