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

how to find the second salary?

HCL, Prithvi,

10 13402

LOV can best describe a) window b)modal c)list d) none of these d)

ESS,

5 7594

can u plz provide me oca sql dumps please i need them

1 2006

i need query for displaying the eno,ename in a table from row 2 to row 5

1 4223

using primary can we relate two table, with out foreign key?

1 2775

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

1 4513

what is the size of date datatype in sql?

2 5291

Which of the following is used to enter or display data via Internet? Data in it is stored as HTML files, with data read from and written to the database. Macros Queries Forms Pages

Wipro,

1 5164

is it necessary to write group by and order by clause together

HCL, Wipro,

3 10993

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

Sierra Atlantica,

1 2064

How to swap the data of two columns in a table. both the columns containing varchar values.

9 17887

how to calcuate the second highest salary of he employee

Synechron,

13 19072

what is outer join? what is selef join? what is difference between them? what is cartecion join?

Fiserv, Herbinger, Synechron,

1 11462

i need department wise top 2 employees salary.which logic i will use

17 32850

If we declare constraints Unique and Not null on a single column then it will act as a Primary key, so what is the use of primary key??

3 7544

Un-Answered Questions { Databases }

What is sql server query analyzer?

1111

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2035

What are the kinds of subquery?

1087

What is the current mysql version?

1082

What is the primary use of the model database?

1141

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

1110

What are wait types?

1219

What is acid mean in sql server?

1218

Disadvantages of the indexes?

1205

What are the different types of subquery?

1222

Why should you use or avoid select * statements?

1094

Can we rollback truncate?

1057

Can we use distinct and group by together?

1116

List the ways in which dynamic sql can be executed?

1071

What is clustered index

1069

For More Un-Answered { Databases } Questions Click Here