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 19943

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

1 4638

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

iGate,

1 6687

What are advantages of dateset in datastage?

iGate,

2263

To find second largest salary in Employee table

CSS,

17 20385

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

Satyam,

15 41150

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

iNautix,

2 13329

what is the difference between cursor FETCH and FOR LOOP ?

CG-VAK, Tech Mahindra,

3 25746

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

Cap Gemini, iNautix,

24 51662

what is difference between DBMS and RDBMS?

Metric Stream,

2 6459

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 11411

how to get second highest sal of emp table

6 9985

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

2026

How can we Use Linked Server? Uses of Linked server

IBM,

1 5593

What are the Pre Requisites when you apply Srvice Packs?

IBM,

1 4309

Un-Answered Questions { Databases }

How to backup encryption key ?

182

What is dml command?

968

What is sql server locking?

992

What is mysql shell?

985

What is Trigger in Oracle?

1171

What are null values in ms sql server?

1088

What is secure property?

Define denormalization.

1171

How many mysql connections can handle?

892

What is the difference between value type and reference type?

921

How to read/write files from pl/sql?

1035

Is mysql query case sensitive?

971

What is the left table in sql?

963

Is microsoft access available in office 365?

893

How do I restore a mysql database dump file in linux?

976

For More Un-Answered { Databases } Questions Click Here