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 7705

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 10883

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

5 40220

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 13862

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

Wipro,

5 11833

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 5375

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

CybAge,

1 5754

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 3090

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

1 4527

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

2 4370

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

Satyam,

2017

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 9929

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 19285

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

1 15517

What different of iner joint & outer joint with example

4 10043

Un-Answered Questions { Databases }

What is attribute relationships, why we need it? : sql server analysis services, ssas

973

what are the differences between an exclusive lock and a shared lock?

994

How can we find out the current date and time in oracle?

1093

How to rename an existing column with sql server management studio?

1001

how can you enable flashback feature?

961

Can varchar be primary key?

931

Explain what is mongodb?

How do you edit data in pgadmin?

862

Is natural join same as inner join?

947

What is a file group?

1096

What are the properties of a transaction?

1130

How to override dml statements with triggers?

1191

What are the types of dbms?

975

Is there any need to create database command in mongodb?

What happens to the data files if a tablespace is dropped?

1062

For More Un-Answered { Databases } Questions Click Here