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

how to find the second salary?

HCL, Prithvi,

10 13076

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

ESS,

5 7384

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

1951

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

1 4106

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

2712

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

4446

what is the size of date datatype in sql?

2 5175

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 5049

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

HCL, Wipro,

3 10829

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,

2012

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

9 17541

how to calcuate the second highest salary of he employee

Synechron,

13 18571

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

Fiserv, Herbinger, Synechron,

1 11377

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

17 32230

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 7397

Un-Answered Questions { Databases }

What do you know about normalization and de- normalization?

931

Explain where clause?

992

Is mariadb nosql?

1041

What are data resources?

918

What is normal form in dbms?

910

Describe how to use the linked server?

1143

What happens if you are trying to access a schema not owned by you?

968

Why is it called postgresql?

893

What is insert command in sql?

1132

How to create software using microsoft access?

960

What is synonyms?

1059

When to use inner join and left join?

961

How many tables we can create in mysql database?

952

What are slow queries?

906

What are the most important characteristics of pl/sql?

1161

For More Un-Answered { Databases } Questions Click Here