Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3239)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3312)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1391)
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 14939

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

1 3873

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

iGate,

1 5818

What are advantages of dateset in datastage?

iGate,

1738

To find second largest salary in Employee table

CSS,

17 16246

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

Satyam,

15 36594

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

iNautix,

2 12292

what is the difference between cursor FETCH and FOR LOOP ?

CG-VAK, Tech Mahindra,

3 23990

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

Cap Gemini, iNautix,

24 44542

what is difference between DBMS and RDBMS?

Metric Stream,

2 5443

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 9967

how to get second highest sal of emp table

6 7860

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

1433

How can we Use Linked Server? Uses of Linked server

IBM,

1 4827

What are the Pre Requisites when you apply Srvice Packs?

IBM,

1 3617

Un-Answered Questions { Databases }

What is a checkpoint and When does it occur?

462

A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?

281

What is background process in Oracle?

622

what are the advantages of using stored procedures? : Sql dba

609

What is dbms introduction?

486

What is a collation in ms sql server?

544

Difference between transaction type and transaction sources. : oracle accounts receivable

568

Is it true, that there is no difference between a rule and a check constraint?

519

What jobs use sql?

520

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

1726

In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...

2576

What do you mean by normalisation?

496

If the master device is full, how do I make the master database bigger?

522

I have 2 tables with 1 million rows each. I have updated 1 row in first and 1 million update on second table. Now I commit both the updates. Which one will commit fast and Why?

2125

What is filestream?

554

For More Un-Answered { Databases } Questions Click Here