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 13368

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

ESS,

5 7555

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

1999

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

1 4201

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

2767

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

4511

what is the size of date datatype in sql?

2 5274

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 5146

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

HCL, Wipro,

3 10973

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,

2059

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

9 17849

how to calcuate the second highest salary of he employee

Synechron,

13 18992

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

Fiserv, Herbinger, Synechron,

1 11456

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

17 32744

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 7529

Un-Answered Questions { Databases }

Explain data dictionary.

968

Explain about your sql server dba experience? : sql server DBA

1160

What is max connection in mysql?

989

What is the syntax to add a record to a table?

1155

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

1070

What is a function in postgresql?

970

What are the various constraints used in oracle?

1106

What are the Advantages of using CTE in sql server?

1171

How do databases help businesses?

931

Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.

611

What the different types of Replication and why are they used?

1134

Tell me about builtinadministrator?

1047

How to delete exactly duplicate records from a table?

1116

What is root password?

968

What is optimization and its types?

1043

For More Un-Answered { Databases } Questions Click Here