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

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 20397

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

1 4730

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

iGate,

1 6802

What are advantages of dateset in datastage?

iGate,

2320

To find second largest salary in Employee table

CSS,

17 20981

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

Satyam,

15 41668

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

iNautix,

2 13462

what is the difference between cursor FETCH and FOR LOOP ?

CG-VAK, Tech Mahindra,

3 25958

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

Cap Gemini, iNautix,

24 52484

what is difference between DBMS and RDBMS?

Metric Stream,

2 6585

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 11610

how to get second highest sal of emp table

6 10249

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

2090

How can we Use Linked Server? Uses of Linked server

IBM,

1 5678

What are the Pre Requisites when you apply Srvice Packs?

IBM,

1 4377

Un-Answered Questions { Databases }

What is a Transformation?

1073

How would you lock a table in sybase?

991

What is the use of RDBMS?

1064

What is the difference between ddl and dml?

1108

what is a unique key ? : Sql dba

1157

What is cursor in pl sql?

1199

What is indexed view?

1035

How to convert csv to table in oracle?

1052

what are defaults? : Sql server database administration

1175

What is access runtime 2007?

940

How do I view views in sql server?

1071

What are a collation and state the different types of collation sensitivity?

1263

What is Extended user-defined?

1037

What is meant by truncate in sql?

1111

What is the importance of a recovery model?

1102

For More Un-Answered { Databases } Questions Click Here