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

How To delete duplicate record from a particular table?

eXensys, Foxfire,

12 25026

What is the difference between Drop and Truncate

GT Nexus, IBM,

20 37907

Anyone please explain me the concept of Serialization?

3 5432

how to insert values like 10:10:00,30:25:00 etc.into table after insert how can i sum the above insert values to get the result as 40:35:00

3 7911

how to truncate date and get only time part 9:20:00

5 9786

What is transaction ? Give me one example.

Melstar, Wipro,

11 27846

UPDATE statement can on a single table or on the multiple table?

iGate, TCS,

7 14206

What is difference between TRUNCATE and DELETE statement

CTS,

12 23039

what is the difference between oracle reports 6i and oracle reports 10g? give atleast 10 differences? (plz give the answer vvvvvvvvvvv.urgent)

IBM, Oracle,

1 23663

what is the output of select * from emp where null=null & select * from emp where 1=1

IMS Health, NIIT,

8 19306

can any one please send sql quries most used in applications.

2 4556

defination of bitmap index

NIIT,

2132

I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column and value, how can is possible

9 12015

What is pragma exception and how, when, where us

5 15436

Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command

Amdocs, MediaSoft,

5 9462

Un-Answered Questions { Databases }

How to pronounce postgresql?

1064

Is sql a database?

935

What is the difference between postgresql and sql?

839

How to insert multiple rows with a subquery?

1140

How to create a stock management database in microsoft access?

924

What is the difference between partitioning and sharding?

1012

What are the different types of tables in sql?

1010

Define a relation schema and a relation.

1087

Can sql servers linked to other servers like oracle?

958

Is it important for a database administrator to understand the operating system and file access?

1005

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

1427

I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.

3982

What is data file in computer?

956

What privilege is needed for a user to create indexes in oracle?

1028

When should you use an instead of trigger?

959

For More Un-Answered { Databases } Questions Click Here