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 25096

What is the difference between Drop and Truncate

GT Nexus, IBM,

20 38014

Anyone please explain me the concept of Serialization?

3 5454

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 7936

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

5 9817

What is transaction ? Give me one example.

Melstar, Wipro,

11 27911

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

iGate, TCS,

7 14224

What is difference between TRUNCATE and DELETE statement

CTS,

12 23108

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 23684

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

IMS Health, NIIT,

8 19361

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

2 4580

defination of bitmap index

NIIT,

2146

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 12073

What is pragma exception and how, when, where us

5 15472

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

Amdocs, MediaSoft,

5 9488

Un-Answered Questions { Databases }

Can mysql and mariadb coexist?

1110

How would you begin to troubleshoot an ORA-3113 error?

2098

What is the functionality and features provided by oracle clusterware?

How does using a separate hard drive for several database objects improves performance right away?

948

What is difference between group by and having?

964

why the Ctl file u put only in bin folder why not in other folder

2067

What are the advantages of mysql?

1007

What types of joins are used in writing subqueries?

1000

How to create a new table in mysql?

1058

What is the difference between float and double?

1141

What are different types of constraints?

942

how to use regular expression in pattern match conditions? : Sql dba

1045

What is %type in sql?

976

What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?

4633

What is pl sql record in oracle?

1053

For More Un-Answered { Databases } Questions Click Here