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

i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75

IBM,

12 19953

Shall I get Pro*C Compiler in Oracle-10g release ?

1 4640

how to see the data (in unix) using dataset in datastage?

iGate,

1 6695

What are advantages of dateset in datastage?

iGate,

2263

To find second largest salary in Employee table

CSS,

17 20406

Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)

Satyam,

15 41166

what will be the output: select 1 from emp union all select 2 from emp;

iNautix,

2 13332

what is the difference between cursor FETCH and FOR LOOP ?

CG-VAK, Tech Mahindra,

3 25756

Write a query to find five highest salaries from EMP table. (there is a column SALARY)

Cap Gemini, iNautix,

24 51684

what is difference between DBMS and RDBMS?

Metric Stream,

2 6467

There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?

IBM,

4 11418

how to get second highest sal of emp table

6 9993

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

2029

How can we Use Linked Server? Uses of Linked server

IBM,

1 5595

What are the Pre Requisites when you apply Srvice Packs?

IBM,

1 4312

Un-Answered Questions { Databases }

Is there some bulk load or other way to import a lot of data fast?

854

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1935

What are record groups ? Explain the types of record group.

Is mysql faster than postgresql?

780

Explain the flow of creating a cube? : sql server analysis services, ssas

1053

How to download and install microsoft .net framework version 2.0?

1139

What is the purpose of access?

840

between cast and convert which function would you prefer and why?

957

Where is the data stored in a database?

1046

How to verify a login name with sqlcmd tool?

1224

what is not null constraint? : Sql dba

1037

What are the types of database engines available in mysql?

1042

what is a materialized view? : Sql dba

1067

Where the sql logs gets stored?

991

How do you concatenate in sql?

1030

For More Un-Answered { Databases } Questions Click Here