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 7732

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 10907

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

5 40250

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 13899

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

Wipro,

5 11863

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 5391

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

CybAge,

1 5771

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 3104

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

1 4546

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

2 4388

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

Satyam,

2033

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 9960

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 19331

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

1 15532

What different of iner joint & outer joint with example

4 10079

Un-Answered Questions { Databases }

How to get the number of affected rows?

1017

What is multi-statement table-value user-defined function?

1009

How you can import data from other sources into access database?

1003

Can you joined two sources without common column?

627

What is postgresql and pgadmin?

855

What is the usage of nvl function?

1050

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

973

What are the advantages of database management system?

956

When columns are added to existing tables, what do they initially contain?

1048

How view is different from a table?

1047

Can you please differentiate between a primary key and a unique key?

1020

what does the no logging option do? Why would we use it?

559

Explain entity ?

1043

Explain the microsoft sql server delete command?

1033

what is online transaction processing (oltp)? : Sql dba

1004

For More Un-Answered { Databases } Questions Click Here