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

why should required for Indexed by table in pl/sql

3 7696

create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

IBM,

8 10856

What is the difference between Outer join and Full outer join?

5 40204

how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...

ADP, Satyam, Tech Mahindra,

7 13848

which query u can write to sql server doesn't work inbetween 7.00PM to nextday 9.00AM

Wipro,

5 11817

Hello everybody, my self is Imtiyaz, i made a small database programm for challan in MS Access, but i am facing one problem in it... if u have seen any challan, it has few boxes like, crore, lacks, thousands, hundred, ten.....and when you put a figure like 20536, at that time in that boxis TWENTY will wrote in "thousand" box FIVE will be in "hundred" box and THIREE will be in "ten" box...... so, in sort i need to know that how can i do module for this that it appears automatically in perticular boxs...thanks

2 5370

what is vlook up in ms excel and how does it used???

CybAge,

1 5748

HI THIS IS SHEKAR MY QUTION IS IF I HAD 10 YEARS DATA IN MY SOURCE THEN I WANT TO LOAD ONLY LAST YEAR DATA HOW IT IS POSSIBLE BY USING DATASTAGE7.5.

1 3086

can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?

1 4524

can you any body tell me why are go for the rebuild the master database.what is the reason?

2 4366

what is package and it uses and how can u call a package

Satyam,

2014

What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning

TCS,

3 9925

how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used

UST,

11 19239

how to insert data into partitioned table partition done by Range partition

1 15515

What different of iner joint & outer joint with example

4 10031

Un-Answered Questions { Databases }

Is it possible to update the views? If yes, how, if not, why?

1029

Tell me what is use of except clause? How it differs from not in clause?

962

How to check duplicate data in mongodb?

What is a derived table?

928

Is oracel sql developer written in java?

1104

What are the difference between and myisam and innodb?

1021

What is oracle in java?

969

What are rdbms concepts?

936

What is " group by " clause?

881

How do I run a pl sql program?

1128

What is meant by an index?

1145

Define left outer join?

970

What version is sql?

1031

Explain what you mean by 3 tier architecture.

1077

Differentiate between sga and pga.

1163

For More Un-Answered { Databases } Questions Click Here